May 2012 - Posts

• SQL Rally Presentations

  As I drove to Dallas for this year's SQL Rally conference (yes, I like to drive) I got a call asking if I could step in for another presenter who had to cancel at the last minute. Life happens, and it's best to be flexible, and I said sure, I can do that. Read More... Posted Friday, May 11, 2012 10:48 AM by AllenMWhite | 4 Comments Filed under: Database Administration, PASS Summit, PowerShell, SMO, Speaking Attachment(s): 2012SQLRally.zip

• Script and Migrate Agent Jobs between Servers using PowerShell

  I'm nearing the end of a SQL Server upgrade project, migrating from SQL Server 2000 to SQL Server 2008 R2. The company uses SQL Server Agent to run about 150 jobs which execute DTS packages to do the work of moving data around. Now, there are any number Read More... Posted Wednesday, May 02, 2012 12:36 PM by AllenMWhite | 4 Comments Filed under: Database Administration, PowerShell, SMO