May 2010 S3OLV Meeting Recap
On the evening of May 13th, S3OLV held its monthly meeting. We had some really good discussion, and got to...
2010-05-14
688 reads
Jason Brimhall
Exceptional DBA
It is once again that time of year. It is time to nominate the DBA in your life for the...
2010-05-11
921 reads
May UG Meeting
This is just a quick note to remind any interested parties that the May S3OLV meeting will be held this...
2010-05-11
463 reads
T-SQL Tuesday #006: A Blobbing We Will Go
Once again it looks like I was early for the T-SQL Tuesday event. Last month I submitted my entry on...
2010-05-11
872 reads
SQL 2005 TableSpace
In the first post of this series I highlighted and described two stored procedures that are shipped from Microsoft. These...
2010-05-05
4,682 reads
Table Sizes
In SQL Server there are two stored procedures that help one to determine the size of a table. One is...
2010-05-03
856 reads
Marathon Schedule
Finally I am putting down to paper my marathon race list for this season. Some of my favorite races are...
2010-04-30
1,473 reads
BLOB Index Columns
For the April T-SQL Tuesday, I blogged about a report to find information on the BLOBs in a database. I...
2010-04-27
1,215 reads
Index Stats Duplication
I came across a recent posting about seeing multiple entries in sys.dm_db_index_usage_stats for the same index. This kind of behavior...
2010-04-22
2,052 reads
SQL 2008 R2
Really short post here. I just found out that Stacia Misner (blog |blog 2 | @StaciaMisner) and Ross Mistry have released...
2010-04-21
562 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