June 2009 - Posts

• Best Thing I Learned at PASS

  At the 2003 PASS Summit in Seattle the organization had a "SIG Challenge" that involved developing a database solution to a business problem. They assigned people to teams and allowed us to work on the problem only when sessions weren't occurring, but Read More... Posted Monday, June 29, 2009 8:35 AM by AllenMWhite | 0 Comments Filed under: User Group Meetings

• Emergency Procedures

  In a followup to Aaron Bertrand's recent blog post on Disaster Recovery, I'd like to mention something I always mention when I teach SQL Server classes. One of the best sources of training I received for being a DBA was, in fact, the training I received Read More... Posted Monday, June 22, 2009 4:34 PM by AllenMWhite | 3 Comments Filed under: Database Administration

• PASS Summit 2009 - PowerShell and Performance

  Over the weekend I received the great news that I've been selected to present a new session, Gather SQL Server Performance Data with PowerShell, at the 2009 PASS Summit in Seattle. Here's the abstract: We all know how important it is to keep a baseline Read More... Posted Monday, June 15, 2009 8:46 AM by AllenMWhite | 1 Comments Filed under: Speaking

• PowerShell Whitepaper Published

  My first whitepaper for Microsoft, Understanding and Using PowerShell Support in SQL Server 2008 has been published. It was a great honor to have been selected to write the paper, and I thank Kalen Delaney for giving me the opportunity. I hope you find Read More... Posted Saturday, June 13, 2009 1:50 PM by AllenMWhite | 3 Comments Filed under: PowerShell, SQL Server 2008

• Handling Errors in PowerShell

  Scripting tasks in PowerShell is a fairly easy way to automate tasks, but you have to know when you get errors and what the real error is. There have been quite a number of blog posts on how to handle errors in PowerShell, like this one by Joel 'Jaykul' Read More... Posted Monday, June 08, 2009 9:41 AM by AllenMWhite | 2 Comments Filed under: SMO, PowerShell

• Scripting Our Daily (Professional) Lives

  I talk a lot about scripting tasks on our servers to automate our regular processes, but in this case I'm talking about a different kind of script. When I first started college, I was a Theatre major. Of course, I learned pretty quickly that my success Read More... Posted Wednesday, June 03, 2009 1:00 PM by AllenMWhite | 1 Comments Filed under: Database Administration