SQL Server 2012 Diagnostic Information Queries (May 2013)
Here is the May 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-05-07
748 reads
Glenn Berry
SQL Server 2012 Diagnostic Information Queries (April 2013)
Here is the April 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-04-16
917 reads
New SQL Server Cumulative Updates
Microsoft has released three new Cumulative Updates for SQL Server today, two for SQL Server 2008 R2 and one for...
2013-04-15
716 reads
Speaking at SQLSaturday #197 in Omaha on April 5-6
I will be speaking on both Friday and Saturday (April 5-6) at SQLSaturday #197 in Omaha, Nebraska. I will be...
2013-03-25
768 reads
Scaling SQL Server 2012 in Lisbon, Portugal
I had the opportunity to present a full-day preconference session on Friday, March 15, 2013 for SQLSaturday #188 in Lisbon,...
2013-03-16
724 reads
SQL Server Hardware
SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.
2013-03-15
14,917 reads
SQL Server 2012 Diagnostic Information Queries (March 2013)
Here is the March 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-03-04
1,058 reads
Hardware 301 Presentation
I had the opportunity to present the latest version of Hardware 301: Diving Deeper into Database Server Hardware two times...
2013-02-14
1,116 reads
Speaking at PASS Database Administration Virtual Chapter
I will be speaking at the PASS Database Administration Virtual Chapter on February 13, 2013 at 12PM MST. I will...
2013-02-09
796 reads
SQL Server 2008 R2 Diagnostic Information Queries (Feb 2013)
Here is the February 2013 version of my SQL Server 2008 R2 Diagnostic Information Queries, with some minor tweaks and...
2013-02-05
1,139 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