SQL Server Central Guest Editorial
My second guest editorial is up at SQL Server Central. These are fun to do (especially the video) even though they’re...
2009-10-14
545 reads
My second guest editorial is up at SQL Server Central. These are fun to do (especially the video) even though they’re...
2009-10-14
545 reads
What great historical figures would make great DBAs? A guest editorial from Grant Fritchey examines the traits and characteristics we look for in this role and which famous people we might choose and why.
2009-10-14
111 reads
If you’re involved with maintaining Microsoft Operations Manager, you probably have a few things you’d like to tell the developers,...
2009-10-13
515 reads
I keep seeing these concepts that have long been disproven, posted again and again on newsgroups as if they were valid information. The...
2009-10-13
660 reads
The PASS Summit is only three weeks away and I’m getting awfully excited. It’s not too late to register. Heck,...
2009-10-10
623 reads
Well, part of one anyway. I wrote three chapters of Rob Walter’s new book, Beginning SQL Server 2008 Administration. I...
2009-10-10
540 reads
Brent Ozar, Andy Warren and Jeremiah Peschka have put together a blogger award called the PASS Log Reader Award. I...
2009-10-08
719 reads
We had a good night with 13 people attending. I ran unopposed for president of SNESSUG for my second, and...
2009-10-08
593 reads
Another frequently heard story is that stored procedures get and reuse execution plans, but ad hoc queries do not. A...
2009-10-07
3,203 reads
Ohio?
I’m presenting on Thursday to the Columbus SQL Server Users Group, home of the newly minted MVP, Jeremiah Peschka (congrats again)....
2009-10-06
526 reads
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
By Brian Kelley
Let’s start with the keynote. The biggest take away was how having to support...
Comments posted to this topic are about the item Step by step guide to...
Comments posted to this topic are about the item Backing up the Database Encryption...
Comments posted to this topic are about the item Technology Fears
In my SQL Server 2022 database, I run this:
USE Sales; GO CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE MyServerCert; GOThis works, but I want to prepare for the future and potential issues. How do I back up my DEK? See possible answers