Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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, 1,835 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, 310 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, 839 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, 615 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, 908 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:

SELECT
  a.ID
, 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, 54,613 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.

RESTORE DATABASE db4 FROM DISK…

Read more

2 comments, 357 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, 656 reads

Posted in The Voice of the DBA on 4 July 2011

Bloopers

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, 622 reads

Posted in The Voice of the DBA on 1 July 2011