Off to the Summit and SQL Saturday Oregon
I’m traveling this morning. My second to last trip of the year, and another long one. Today through the 20th I’ll be in Portland and Seattle. First is Portland,...
2022-11-11
8 reads
I’m traveling this morning. My second to last trip of the year, and another long one. Today through the 20th I’ll be in Portland and Seattle. First is Portland,...
2022-11-11
8 reads
As you might be aware I started a new job last week. Which means a new workstation and installing lots ... Continue reading
2022-11-11
155 reads
If you’re interested in getting a digital copy, my brand spanking new book is now available here. It’s in the intro, but let me tell you a little bit...
2022-11-11
224 reads
I have attended and presented at a ton of conferences over the years (see the entire list at Presentations | James Serra’s Blog). If you are looking to learn...
2022-11-10
4 reads
Today’s coping tip is to respond to a difficult situation in a different way. There are plenty of difficult situations I find myself in, some of which create lots...
2022-11-10
6 reads
At the PASS Data Community Summit, Thursday is the day when the Women in Technology (WIT) luncheon takes place. This is an event I’ve come to enjoy as I...
2022-11-10
61 reads
At Tuesday the 13th of December, I give a webinar about Unison, a self-service online data quality tool of Melissa Data. This is a 30-minute webinar, sponsored by Melissa...
2022-11-10
7 reads
Today’s coping tip is to make time for a friend and have a coffee, meal, or just spend time. It’s been a busy few months for me. Since Sept...
2022-11-09
11 reads
Query multiple SQL Server instances at one time! Thanks for watching! Kevin3NF Follow @Dallas_DBAs
The post SQL Server Registered Servers appeared first on DallasDBAs.com.
2022-11-09 (first published: 2022-10-28)
442 reads
I’ve seen a few people start Azure Data Factory (ADF) projects assuming that we would have one source control repo per environment, meaning that you would attach a Git...
2022-11-09 (first published: 2022-10-31)
290 reads
By Steve Jones
I missed blogging yesterday as I was on stage/backstage for quite a bit of...
By Brian Kelley
A common theme in the PASS Summits I've attended is community and that's definitely...
By Chris Yates
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying...
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