June 2010 - Posts

• Don't Do This

  In working on applications at client sites you tend to come across code that makes you think "what were they thinking"? This week I found one that just made me do the "facepalm": select top 1 @_StateTrueKey = OverEngineeredKey from OverEngineered where Read More... Posted Friday, June 25, 2010 12:14 PM by AllenMWhite | 9 Comments Filed under: Database Administration

• PowerShell Script to Remove Old Backups

  A Twitter user asked for a script to remove old backups, and I had one I built back in February, so here it is (use at your own risk): #rmbackup.ps1 # Removes database and transaction log backups # # Change log: # February 2, 2010: Allen White # Initial Read More... Posted Thursday, June 24, 2010 1:46 PM by AllenMWhite | 1 Comments Filed under: PowerShell, Database Administration

• Lots of Speaking Engagements Coming Up

  SQL Saturday - Columbus, OH, June 26, 2010 I'll be presenting two sessions this Saturday (June 26, 2010) in Columbus, OH - XQuery Basics and Gather SQL Server Performance Data with PowerShell . The event takes place at Goodwill Columbus, 1331 Edgehill Read More... Posted Wednesday, June 23, 2010 11:25 AM by AllenMWhite | 0 Comments Filed under: PowerShell, Database Administration, Speaking

• TechEd 2010 Followup

  Last week I presented a couple of sessions at Tech Ed NA in New Orleans. It was a great experience, even though my demos didn't always work out as planned. Here are the sessions I presented: DAT01-INT Administrative Demo-Fest for SQL Server 2008 SQL Server Read More... Posted Sunday, June 13, 2010 3:25 PM by AllenMWhite | 4 Comments Filed under: PowerShell, Database Administration, SQL Server 2008, Speaking Attachment(s): TechEd2010.zip