Hostettler the Viking Needs a New Ship and Your Help
Hostettler the Viking Needs a New Ship…And Your Help.
My good friend Justin Hostettler Davies (Blog@DBExpertise) pinged me a mail in...
2011-04-11
582 reads
Gethyn Ellis
Microsoft Migration Assistant v5.0 Released
As I was surfing around twitter after the marathon TV event that was the Royal Wedding came to end last...
2011-04-06
684 reads
Blog Syndication
I got sent an email recently asking how I went about syndicating my blog on some of the popular SQL...
2011-03-21
1,729 reads
Stored Procedure Definitions and Permissions
I wrote a post a while back that showed how you can grant execute permission ‘carte blanche’ for a database...
2011-03-18
2,146 reads
Becoming a DBA: How to gain experience
Last week I had an interesting telephone call from a someone who I connected with on linkedin.com. On Linkedin I’m...
2011-03-16
1,683 reads
Stored Procedure Definitions and Permissions
I wrote a post a while back that showed how you can grant execute permission ‘carte blanche’ for a database...
2011-03-14
2,781 reads
The Joy of Contracting
As you may or may not know I have been contracting since 2007, almost 4 years now and I have...
2011-02-21
910 reads
February Update
I haven't written anything for a while and again, for the second month running I missed TSQL2usday. It's a shame...
2011-02-15
474 reads
Shameless Plug: My First SSC Article Published Today
Please forgive the shameless plug. My first article was published today on sqlservercentral.com. It’s titled “Backup and Housekeeping with Maintenance...
2011-01-26
548 reads
Ebooks: Deal of the Day
Apress, as I expect you know, publish some really good SQL Server books. Some of which are on the MCM...
2011-01-24
620 reads
Blogs
PASS Data Community Summit 2024 Day 3 Keynote
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
A New Word: Skidding
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
PASS Summit – Thursday
By Brian Kelley
Let’s start with the keynote. The biggest take away was how having to support...
Forums
Step by step guide to setup PostgreSQL on Docker
Comments posted to this topic are about the item Step by step guide to...
Backing up the Database Encryption Key
Comments posted to this topic are about the item Backing up the Database Encryption...
Technology Fears
Comments posted to this topic are about the item Technology Fears
Question of the Day
Backing up the Database Encryption Key
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