Maintenance Plan Owner
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit some things that are not so good. Other times...
2012-06-25
2 reads
Blog Posts
Speaking at PASS Summit 2012
It’s about that time again, PASS Summit 2012 is right around the corner in Seattle, WA. It will be held...
2012-06-25
947 reads
SQLRally 2012 Eval Scores
I was just browsing the results of the presentations at SQLRally 2012. I ended up with a evaluation average of...
2012-06-25
640 reads
Unable to activate a Windows 2003 VM on Hyper-V behind a proxy
Ok, so this is not strictly a post about SQL itself (and it's about a fairly old OS), but I...
2012-06-25
2,688 reads
Excellent SSIS 2012 Upgrade Video
This presentation gives an excellent overview of the process of upgrading SQL Server 2008 SSIS packages to work with SQL...
2012-06-24
1,301 reads
Using SQL Server 2012 FileTables
SQL Server 2012 allows you to store file/directories in a special table called FileTable that builds on top of SQL...
2012-06-24
13,716 reads
Inspirational Database Administration Requirements
Just as a society’s civilization is mostly nurtured by its culture, I believe that DBA work quality is mostly determined...
2012-06-23
923 reads
SQL Server 2012 Installation Guide
This article walks the user through installation of SQL Server 2012 on a Windows Server 2008 system using the SQL...
2012-06-23
214,934 reads
I don’t care and why that is good for my blog
I expressed in my About page that this blog is never meant to be a technical blog. But the pressure...
2012-06-22
794 reads
Indexed view deadlocking
Deadlocks can be a really tricky thing to track down the root cause of. There are lots of articles on...
2012-06-22 (first published: 2012-06-13)
3,777 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