Jacksonville Code Camp 2012
Hello one, hello all. It has been quite a while since I have blogged. I am looking forward to starting...
2012-10-04
1,164 reads
BrianKMcDonald
SQL Saturday 85 Follow Up
Last weekend I travelled down to SQL Saturday 85 in Orlando, FL. Like all of the other events that I’ve...
2011-10-02
972 reads
Dataset with Text or Stored Procedure
As most of you already know, Reporting Services reports make use of Datasets to get data. These Datasets can get...
2011-10-02
1,220 reads
SQL Saturday 85 – Orlando
Grab your computer and get registered for SQL Saturday 85 in Orlando. If you’re new to the SQL world and...
2011-09-19
1,028 reads
Task Factory's Surrogate Key Transform
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,316 reads
Task Factory's Secure FTP Task
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
2,447 reads
Task Factory: Email Source and Delete Email Task
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,357 reads
Task Factory: Data Validation Transform
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,659 reads
Task Factory: Data Cleansing Transform
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,218 reads
Task Factory: Compression Task
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,361 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