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

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

Archives: July 2011

When Did That Restore Finish?

I saw this question come across Twitter under the #sqlhelp tag one day and was wondering myself. Someone suggested the default trace, I was thinking msdb.dbo.restorehistory and decided to check.

First I hit Books Online. It notes that the restore_date column means: Date and time of the restore operation. Can… Read more

5 comments, 7,598 reads

Posted in The Voice of the DBA on 28 July 2011

A Guest at the Ranch

From the other side of the world, I had a guest at the ranch today.

Pinal Dave, a friend from India, sent me an email that he’d unexpectedly come to Denver this week. He had some time, so I invited him out to the ranch today for a few hours… Read more

2 comments, 798 reads

Posted in The Voice of the DBA on 19 July 2011

SQL Server Backup – Inadvertent Striping

When I started working with SQL Server I got bit in the rear one day while I was testing backups. I was in the process of making a quick backup before I deployed some changes. I think this was in the Enterprise Manager days of SQL 2000, but it could… Read more

2 comments, 1,689 reads

Posted in The Voice of the DBA on 18 July 2011

Office Work

I have been working at home for over 8 years, sharing an office with my wife for most of that time. I like working at home, though I do notice that if my wife is gone for a few days, I go a little stir crazy being completely by myself.… Read more

0 comments, 1,671 reads

Posted in The Voice of the DBA on 14 July 2011

Striping Backups in SQL Backup Pro

There are times you really do want to stripe backups across multiple files. If you have a short backup window, or a large data set, if you can write the backup to multiple files at the same time, you can drastically reduce your backup window. I think I heard one… Read more

0 comments, 2,277 reads

Posted in The Voice of the DBA on 11 July 2011

The IF Statement in a T-SQL Query

I’ve seen quite a few posts from people asking how to do something like this:

, IF a.MyChar = 'A' THEN 'Success'
  ELSE 'Fail'
FROM MyTable a

Of course, that doesn’t work in T-SQL, and you’ll get something like this:

Msg 156, Level 15,… Read more

1 comments, 158,011 reads

Posted in The Voice of the DBA on 7 July 2011

Recovering a Database

So you’re restored a database, restored a few logs, all with NORECOVERY as expected and realize there are no more logs. You see this in Management Studio and wonder what do to:

I’ve run a bunch of code, restoring lots of files, but I’m done.


Read more

2 comments, 895 reads

Posted in The Voice of the DBA on 6 July 2011

Wild West Day

One of the things I’m missing today is Wild West Day at Red Gate. It’s not just because I don’t live anywhere near the office (they’re in Cambridge, UK, I’m in Denver, CO), but also because I have a vacation scheduled. Camping up near Fort Collins with family is on… Read more

0 comments, 1,585 reads

Posted in The Voice of the DBA on 4 July 2011


An early peak at the bloopers going out on Monday. Feel free to enjoy today. I’ve included the editorial and then the raw bloopers from the last month, which has a few more mistakes in there.

The official Independence Day 2011 Videos


The raw ones are below, and include… Read more

0 comments, 1,362 reads

Posted in The Voice of the DBA on 1 July 2011