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: February 2012

AdventureWorks in SQL Server 2012 RC0

The sample databases for SQL Server 2012 haven’t been completely finalized, but I was able to find the latest version here for AdventureWorks. This download gives you an mdf, and that’s it. You can’t directly attach that in SSMS, but you can use T-SQL to do it.


1 comments, 1,903 reads

Posted in The Voice of the DBA on 29 February 2012

Azure is Down

I saw a note about an outage on Windows Azure, apparently one that’s been going on for seven hours. Once again it seems that February 29 has struck again with a computer issue, and it makes me worry that if we mess with daylight savings time, we might have… Read more

0 comments, 1,712 reads

Posted in The Voice of the DBA on 29 February 2012

Backing up a Certificate

If you create your own certificate in SQL Server, you need to make sure that you back it up immediately. Once you start to encrypt anything with a certificate, you increase the risk that you’ll lose your data if an catastrophic event occurs. In this case, if you lose the… Read more

1 comments, 8,271 reads

Posted in The Voice of the DBA on 27 February 2012

No MVP Summit for Me

On the corner of my rather messy desk is little recognition item in the image to the right. It’s a 5 year marker, representing my 5 years as a Microsoft MVP. I’m honored that they think I’m doing enough for the community to be recognized.

Next week is the annual… Read more

0 comments, 834 reads

Posted in The Voice of the DBA on 24 February 2012

Checking Your Service Account with T-SQL

Somehow this slipped by me, but there were some new DMVs added in SQL Server 2008 R2 SP1. I suspect my test machines were mostly SQL Server 2008 or SQL Server 2012, and I hadn’t been paying attention to the changes in SP1.

You can now use T-SQL to check… Read more

3 comments, 2,748 reads

Posted in The Voice of the DBA on 22 February 2012

Where’s My Backup? SQL Server Backup Issues

You can cause yourself problems if you don’t know where your backups are stored, and how they are being made. It also helps to understand the defaults of how your backups are created in files.

Here’s a short story to illustrate an issue you might encounter as a beginner if… Read more

0 comments, 1,496 reads

Posted in The Voice of the DBA on 21 February 2012

Creating Your Own Certificates

Did you know that you don’t need to go to Digicert or Thawte, or any other company to get a certificate to use in SQL Server? You can create your own certificate.

Why you would want to do this is a longer discussion, but suffice it to say that… Read more

1 comments, 1,240 reads

Posted in The Voice of the DBA on 16 February 2012

Hardware Fun

This has been a bit of a hardware week for me, which is strange. I used to love hardware, building my own computers, picking out the components, and making something work out of a pile of parts.

Now I just want my tools to work.

Our Windows Home Server died… Read more

1 comments, 1,077 reads

Posted in The Voice of the DBA on 10 February 2012

Computed Columns and Divide by Zero

I have a few posts on computer columns, the basics of computed columns, using CASE in a computed column, and UDFs in computed columns, but there was another use that someone pointed out to me recently: catching divide by zero errors.

Suppose you have a column that… Read more

6 comments, 3,931 reads

Posted in The Voice of the DBA on 7 February 2012

A few quick time calculations

Have you ever needed to do a quick time calculations of the amount of hours/minutes/seconds that have passed? Suppose you needed to get the total number of minutes that have passed for a total time of ‘2:24’.

There are some easy ways to do this, and the normal calculation that… Read more

2 comments, 1,082 reads

Posted in The Voice of the DBA on 1 February 2012