Microsoft Certified Trainer!
For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of...
2017-05-28
429 reads
For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of...
2017-05-28
429 reads
For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of my two-year working as a trainer at the Seavus...
2017-05-28
1 reads
For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of my two-year working as a trainer at the Seavus...
2017-05-28
1 reads
In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three...
2017-05-10 (first published: 2017-04-29)
2,373 reads
I’m writing this post because I want to put some more stuff around dates and times in one place. I...
2017-05-09
1,037 reads
I’m writing this post because I want to put some more stuff around dates and times in one place. I additionally teach SQL Server classes and often come up...
2017-05-09
1 reads
I’m writing this post because I want to put some more stuff around dates and times in one place. I additionally teach SQL Server classes and often come up...
2017-05-09
3 reads
In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three functions for a variable to ensure it never accepts...
2017-04-29
9 reads
In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three functions for a variable to ensure it never accepts...
2017-04-29
1 reads
MIXED_PAGE_ALLOCATION is a new option introduced with SQL Server 2016. It controls whether the database can create initial pages using...
2017-04-08
5,541 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