SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: June 2009

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)

Read more

0 comments, 1,186 reads

Posted in Allen White on 29 June 2009

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)

Read more

0 comments, 324 reads

Posted in Allen White on 22 June 2009

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 of performance metrics that allow… Read more

0 comments, 308 reads

Posted in Allen White on 15 June 2009

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 it useful.


Share this post:

Read more

0 comments, 350 reads

Posted in Allen White on 13 June 2009

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' Bennett.… Read more

0 comments, 839 reads

Posted in Allen White on 8 June 2009

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 in that field would… Read more

0 comments, 300 reads

Posted in Allen White on 3 June 2009