Have You Backed Up Your Database Master Key?

If you have encrypted columns in a database or certificates used to create them, you need to make sure that you back up the Database Master Key as part of your maintenance, and then protect that backup file. Here’s the short version of the command: BACKUP MASTER KEY TO FILE = ‘<complete path and filename>’…

1

Another Reason to Use A Special Service Account

When I’m asked what the least-used feature of SQL Server is, I often have to reply that it is "good security". Many installations take all the default settings, and most use programmatic security rather than the features built in to SQL Server. This is especially true of the service accounts used to run the SQL…

1

Quote of The Day – Salt Water Cures Everything

Just got back (late last night) from our Florida vacation. I really miss "home" – Safety Harbor, Florida – and while I was there I saw a quote from my favorite author, Isak Denison: "Anything can be cured with Saltwater – Tears, Sweat, or the sea." I agree. Work, remorse with purpose, and the ocean…

1

This is NOT a New Year’s Resolution Blog Entry

I read a lot of blogs, as I’m sure you do. Many of them lately tell me about the author’s New Year’s resolutions – and I’m sure those are important. But I don’t think you care about mine. Neither do I. In fact, as a family, we don’t make any. Since we don’t stay out…

1