THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Database Administration   (RSS)
Showing page 3 of 8 (76 total posts)
  • Getting Job History Correctly

    In my last blog post I walked through a way to grab the duration from the EnumHistory method of the JobServer/Job object. As I worked through getting a solution in place for a client I found that the duration calculation was only part of the problem. First, when EnumHistory() is invoked, it runs the sp_help_jobhistory stored procedure. You can ...
    Posted to Allen White (Weblog) by AllenMWhite on March 1, 2012
  • [Speaking] Manage SQL Server 2012 on Windows Server Core with PowerShell

    This evening I'll be presenting a brand new session on installing and managing SQL Server 2012 with PowerShell. Here's the abstract: Windows Server 2008 introduced Server Core, the operating system without the Graphical User Interface. SQL Server 2012 is the first version of SQL Server to support Server Core. To gain the maximum efficiency from ...
    Posted to Allen White (Weblog) by AllenMWhite on January 17, 2012
  • Speaking about Performance and PowerShell

    I'll be presenting at the South East Michigan SQL Server User Group (SEMSSUG) tonight. The session will be Gather SQL Server Performance Data with PowerShell. We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always ...
    Posted to Allen White (Weblog) by AllenMWhite on December 8, 2011
  • For Servers the Command Line Rules

    When I first learned to program, back in the fall of 1968, the first 'word' the computer I connected to said to me was 'READY'.  That summed it up neatly. The computer was ready to do work, it was just waiting for me to give it instruction. As I progressed through my knowledge of programming and my focus on providing businesses useful ...
    Posted to Allen White (Weblog) by AllenMWhite on October 26, 2011
  • Check the Default Database Setting for your Admin Accounts

    Last weekend, as I was waiting for the start of the performance of the Cleveland Orchestra at its summer outdoor venue, Blossom Music Center, a client called with a problem. The databases on his principal production server had failed over to the mirror server, and now he couldn't connect to the principal server. After trying a couple of things ...
    Posted to Allen White (Weblog) by AllenMWhite on August 31, 2011
  • Pull Performance Data from Perfmon Logs with PowerShell

    For the last year and a half or so I've been presenting a session on how to gather perfmon data with PowerShell. Here's a link to my blog after the 2010 Tech Ed conference that has the download scripts. These scripts include the database tables and stored procedures I use to store the data for reporting. Sometimes when I'm at client sites I'm ...
    Posted to Allen White (Weblog) by AllenMWhite on August 21, 2011
  • What Encryption Algorithms Are You Using?

    Security is an important consideration when designing a database application. Who can get access to what data? How much damage can someone do if they get at your data? In SQL Server 2005 Microsoft implemented column-based encryption, and in SQL Server 2008 they added Transparent Data Encryption. Both solutions work well for their intended use, ...
    Posted to Allen White (Weblog) by AllenMWhite on May 31, 2011
  • Endpoints Need Privileges Too

    Yesterday I delivered a session for the PASS DBA Virtual Chapter on Service Broker. In preparing for the session I was having trouble with my demo environment. Since early this year, after I upgraded my laptop to a Lenovo W510 with 10GB RAM, I've been using VM Workstation for my demo and test machines, replacing the Microsoft Virtual PC demos ...
    Posted to Allen White (Weblog) by AllenMWhite on May 26, 2011
  • Monitor your SQL Server Agent Proxies Using PowerShell

    Over time it's easy to lose track of the things you set up to get work done. As a consultant, I have to discover what's set up on a client system. In either case, it's important to know what security settings are in place to know if they're appropriate and well managed. One of the hidden gems (and potential nightmares) in SQL Server is the use ...
    Posted to Allen White (Weblog) by AllenMWhite on May 25, 2011
  • Find your Enabled SQL Server Network Protocols Using PowerShell

    Another quick check I like to do when in 'discovery mode' on a client system is to see what network protocols are enabled. Those of us around in 2003 will remember well the headaches caused by the SQL Slammer virus, and know to shut down Named Pipes unless it's absolutely necessary, just as a precaution. As part of my investigation on new ...
    Posted to Allen White (Weblog) by AllenMWhite on May 21, 2011
< Previous 1 2 3 4 5 Next > ... Last »
Privacy Statement