September 2012 - Posts

• Scanning the Error Log with PowerShell

  One of the most important things you can do as a DBA is to keep tabs on the errors reported in the error log, but there's a lot of information there and sometimes it's hard to find the 'good stuff'. You can open the errorlog file directly in a text editor Read More... Posted Tuesday, September 25, 2012 3:33 PM by AllenMWhite | 10 Comments Filed under: SMO, PowerShell, Database Administration Attachment(s): scan-errorlog.zip

• 24 Hours of PASS - PowerShell 101 for the SQL Server DBA

  Thanks to everyone who came out for the session today. It was a lot of fun and I hope you had a great experience as well. I've attached the demo scripts and slide deck to this post, and I look forward to seeing you in November at the PASS Summit! Alle Read More... Posted Thursday, September 20, 2012 11:32 PM by AllenMWhite | 1 Comments Filed under: SMO, PowerShell, Database Administration, Speaking, PASS Summit Attachment(s): PowerShell101ForTheSQLDBA.zip

• Speaking - 24 Hours of PASS, Summit Preview Edition

  There's so much to learn to be effective with SQL Server, and you have an opportunity to immerse yourselves in 24 hours of free technical training this week from PASS, via the 24 Hours of PASS event. I'll be presenting an introductory session on PowerShell Read More... Posted Tuesday, September 18, 2012 10:26 PM by AllenMWhite | 1 Comments Filed under: SMO, PowerShell, Database Administration, Speaking, PASS Summit

• Speaking - Red Gate's SQL in the City

  The great folks at Red Gate have invited me to join the festivities at the SQL in the City events in both Chicago on October 5, and in Seattle on November 5. In both cities I'll be presenting a session entitled Automated Deployment: Application And Database Read More... Posted Tuesday, September 11, 2012 9:43 PM by AllenMWhite | 0 Comments Filed under: Speaking

• T-SQL Tuesday #34: Help me, Obi-Wan Kenobi, You're My Only Hope!

  This T-SQL Tuesday is about a person that helped you understand SQL Server. It's not a stretch to say that it's people that help you get to where you are in life, and Rob Volk ( @sql_r ) is sponsoring this month's T-SQL Tuesday asking who is that person Read More... Posted Monday, September 10, 2012 10:58 PM by AllenMWhite | 0 Comments