You’re invited! I’m thrilled to be co-presenting a session on the top five SQL Server virtual machine performance tuning tips with our friends at Sanity Solutions on July 21st...
2022-07-13 (first published: 2022-06-25)
389 reads
Deb Melkin (b | t) is hosting T-SQL Tuesday this month and is letting us rant. Who doesn’t like to rant about databases and the famous “it depends”. She...
2022-07-13 (first published: 2022-07-12)
24 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-07-12
13 reads
Often enough I get questions regarding partitioning to try to help alleviate performance issues with very large tables. A common misconception is that due to the table being large,...
2022-07-12
34 reads
I know I can say that I’m a friend of Allen White without getting into trouble. Allen and I have a shared a lot of things over the years...
2022-07-12
104 reads
A great invitation this month from Deborah Melkin. I thought this was very apt, as I use this phrase often. Many of us do. This was a tougher post...
2022-07-12
20 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month, and this month Deborah Melkin (blog | twitter) asks us for a database-related rant.
I...
2022-07-12
1 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-07-11
7 reads
One of my favorite little bits of information about Extended Events is the fact that everyone running a full instance of SQL Server has deadlock information available to them,...
2022-07-11
14 reads
TLDR; The code to do this is below but it’s a bit hokey and probably isn’t worth it. It’s pretty ... Continue reading
2022-07-11 (first published: 2022-06-24)
470 reads
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
By Brian Kelley
Let’s start with the keynote. The biggest take away was how having to support...
Comments posted to this topic are about the item Step by step guide to...
Comments posted to this topic are about the item Backing up the Database Encryption...
Comments posted to this topic are about the item Technology Fears
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