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: August 2013

I have a dream

It seems fitting with the anniversary of Martin Luther King’s “I have a dream” speech that I would write about discrimination this week in my piece “Stunned”. There’s a long discussion over at SQLServerCentral, and along with a phone call with a friend, I thought a bit about… Read more

0 comments, 1,042 reads

Posted in The Voice of the DBA on 28 August 2013

Backup Your Certificate for TDE

If you’ve enabled TDE, you need to be sure you have a copy of the certificate that protects the Database Encryption Key (DEK). If you follow my instructions, then you have one.

If you didn’t make a backup, or you have just discovered a TDE database, make one now,… Read more

0 comments, 1,830 reads

Posted in The Voice of the DBA on 26 August 2013

Decisions, Decisions. Fall Events

I was looking over my travel calendar this fall, and I’m somewhat amazed at the variety of events that are being held for SQL Server professionals. There are a number of SQL Saturdays, and if you can attend those, I’d highly urge you to do so. Most are free,… Read more

0 comments, 1,133 reads

Posted in The Voice of the DBA on 23 August 2013

The Podcast is in the Windows Store

If you’ve got a Windows Phone, or any of the Windows devices that support podcasts, the Voice of the DBA podcast is in the store. I did a quick search and found it, though the image isn’t there yet.

I was visiting a Red Gate customer last week and one… Read more

0 comments, 1,311 reads

Posted in The Voice of the DBA on 21 August 2013

Better Searching on Google

One of the keys to being a successful technologist is being able to search for information. Google has a lot of operators, and I ran across this list of terms, thanks to Kevin Kline.

It’s on the GoogleGuide site and lists and defines the operators. I’d encourage you… Read more

0 comments, 971 reads

Posted in The Voice of the DBA on 21 August 2013

Restoring a TDE Database on a New Instance

You’ve enabled Transparent Data Encryption (TDE) on one of your databases, and the server has failed. How do you get this database working on a new instance? This short post will show you how this works.

Files Needed

There are two files you need in order to restore the database. Read more

0 comments, 1,061 reads

Posted in The Voice of the DBA on 19 August 2013

iOS v Android–A Short Term Update

I ordered my first new new phone this year. I’ve never purchased a new, unreleased model of a cell phone before. I’ve gotten some nice phones, but always 6-12 months after other people have had a chance to use, review, and complain about them. However my wife’s Galaxy S3 was… Read more

8 comments, 2,554 reads

Posted in The Voice of the DBA on 16 August 2013

T-SQL Tuesday #45–Follow the Yellow Brick Road

It’s T-SQL Tuesday time again, and this month Mickey Stuewe hosts the party. It’s an interesting topic, and one that I think is important, and will be more important, as we capture, store, analyze, and depend on more and more data.

The topic this month is auditing, and you can… Read more

1 comments, 991 reads

Posted in The Voice of the DBA on 13 August 2013

I Hesitate to Commit

At work my boss this week my boss gave me some quotes about me. We solicit feedback twice a year from co-workers and use that to evaluate how employees are doing. This goes up and down the chain, so everyone from the CEO down gets anonymous quotes.

A few of… Read more

1 comments, 2,165 reads

Posted in The Voice of the DBA on 12 August 2013

Disaster Recovery Docs–Offsite

Years ago I worked at an ISO certified organization, where we took our administration and planning seriously. We ensured everything was backed up, we had backup drills, we each practiced recovering systems, loading tapes, even calling the company that rotated our tapes from an offsite location.

One of our administrators… Read more

1 comments, 2,291 reads

Posted in The Voice of the DBA on 8 August 2013