Subscribe to this blog
Archives: June 2010
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)
0 comments, 237 reads
Posted in Allen White on 25 June 2010
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…
0 comments, 451 reads
Posted in Allen White on 24 June 2010
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)
0 comments, 178 reads
Posted in Allen White on 23 June 2010
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)
0 comments, 180 reads
Posted in Allen White on 13 June 2010