November 2010 - Posts

• [Speaking] Scripting SQL Server Objects with PowerShell

  In conjunction with the launch of Red Gate's SQL Source Control product, I'm presenting a webinar on Thursday, November 18 at noon EST. I'll present an introduction to PowerShell for those who've never seen it, walk through the basics of the SQL Server Read More... Posted Wednesday, November 17, 2010 9:21 AM by AllenMWhite | 2 Comments Filed under: PowerShell, SMO, Speaking

• SQL Agent Error Handling with PowerShell

  When you run a PowerShell script in a SQL Server Agent task (or JobStep, as the SMO object is called) I've figured out that when the step fails, Agent records the PowerShell error (as in what line in the script failed), but I've been sending my detailed Read More... Posted Monday, November 15, 2010 2:15 PM by AllenMWhite | 3 Comments Filed under: PowerShell, SMO

• Scripting Index Maintenance with PowerShell

  One of the things that Maintenance Plans do poorly is index maintenance. Unless you create your own scripts, the process simply rebuilds all the indexes in all the databases. This is one of the reasons why I really dislike maintenance plans. (My pre-con Read More... Posted Saturday, November 13, 2010 9:20 PM by AllenMWhite | 12 Comments Filed under: PowerShell, SMO Attachment(s): indexmaint.zip

• PASS PowerShell PreCon was a Success

  I'd like to thank everyone who attended my pre-conference session at PASS on Using PowerShell to Get the Most Out Of SQL Server. It was a huge success, and (at the last count I heard) I had 63 people in attendance. The demos for the session have been Read More... Posted Friday, November 12, 2010 10:19 AM by AllenMWhite | 3 Comments Filed under: PowerShell, Speaking, User Group Meetings Attachment(s): DBA232P Use PowerShell to Get the Most out of SQL Server.zip

• PASS Summit 2010 - SQL Server and PowerShell

  Next week is the eagerly anticipated PASS Summit 2010 . I've attended every year since 2003, but this one is special, because I'm presenting both a Pre-Conference session and a Spotlight session! In addition to these, I'll be a contestant in Monday evening's Read More... Posted Saturday, November 06, 2010 7:10 PM by AllenMWhite | 5 Comments Filed under: PowerShell, Speaking, User Group Meetings

• SQL Connections Presentations

  This week I presented two sessions at the Fall 2010 SQL Connections conference, in Las Vegas, Automating Policy-Based Management Using PowerShell and Managing SQL Server System and Performance Data with PowerShell . I thorougly enjoyed doing both presentations Read More... Posted Friday, November 05, 2010 2:03 PM by AllenMWhite | 1 Comments Filed under: Database Administration, PowerShell, SMO, Speaking Attachment(s): SQLConnectionsFall2010.zip