C# Explicit Interface Implementation
In C# it is possible to write classes that implement an interface but only show the methods of the interface...
2012-06-07
38 reads
Blog Posts
How to Drop One Plan from Cache
While presenting this weekend at SQL Saturday #117 in Columbus, OH (great event, if you missed it, you missed it),...
2012-06-07 (first published: 2012-06-04)
3,304 reads
PAGE_VERIFY – Checksum vs. Torn Page Detection
All this talk of testing backups and data integrity and checksums has me thinking that maybe now would be a...
2012-06-07
10,796 reads
Do You Know An Exceptional DBA?
Do you know a DBA that saves the day time and again? Or one that doesn’t need to save the...
2012-06-06
978 reads
Getting started with SQL Server on private cloud
I have been invited to a private beta of SQLDirector by ScaleGrid. “SQLDirector is a MS SQL as a Service...
2012-06-06
1,510 reads
Just another SQL blog
I started out as a software developer back in 1996 in Denver, CO, doing Client/Server development in PowerBuilder. The internet...
2012-06-06
573 reads
On Break
I’m at Orlando International as I write this, about to fly to Parsippany for meetings today and tomorrow, then back...
2012-06-06
624 reads
Optimise Your Disk Subsystem I/O with An Index File Group and Index Compression
As a DBA who is always seeking solutions to performance bottlenecks, amidst the
daily rituals of validating backups and other regular...
2012-06-06
1,676 reads
Powershell Add-Type – Where’s That Assembly!
I’ve been working a lot lately with SMO and the differences between the various versions between SQL 2005, 2008, and...
2012-06-06
17,420 reads
Presenting Tips
Having done a number of presentations, I have accumulated a list of items to go over before each presentation to...
2012-06-06
1,154 reads
Blogs
Day 2 at PASS Data Community Summit 2024
By Steve Jones
I missed blogging yesterday as I was on stage/backstage for quite a bit of...
PASS Summit 2024 – Wednesday
By Brian Kelley
A common theme in the PASS Summits I've attended is community and that's definitely...
Taming Database Challenges: Insights from Redgate Keynote
By Chris Yates
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying...
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