SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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)

Read more

0 comments, 823 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…

Read more

0 comments, 1,048 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)

Read more

0 comments, 578 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)

Read more

0 comments, 669 reads

Posted in Allen White on 13 June 2010