Archives: August 2013
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
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
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
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
It’s on the GoogleGuide site and lists and defines the operators. I’d encourage you… Read more
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.
There are two files you need in order to restore the database. Read more
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
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
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
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