The Advantages of Telecommutting
It isn't often that I see what the real advantages are, and I've been doing it so long that I...
2008-02-22
1,338 reads
Blog Posts
Call for Speakers for PASS Summit is Open Through March 28, 2008
The Summit is being held in Seattle, WA, Nov 18-21, 2008. Call for speakers is open through March 28. It's...
2008-02-21
1,423 reads
LINQ Again!
I recently attended SQLSaturday#2 in Tampa and had the brief chance to chat with David Hayden about LINQ (I suspect I...
2008-02-21
1,809 reads
Changing the Command Prompt
I spend a lot of time at the command prompt and to be perfectly honest, I'm tired of looking at:
...
2008-02-20
1,742 reads
New Book from Celko - Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL
I've been meaning to post this, Joe's latest book Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in...
2008-02-20
1,509 reads
A Welcome Delay
I get a bit of a delay in working on the set down in the basement thanks to the weather....
2008-02-19
1,395 reads
Dry Erase Board v2
When we first set up shop for End To End Training we knew we wanted both a flip chart and...
2008-02-19
1,597 reads
Errata for SQL Server Certification Books
Back in this blog post, I indicated which books I was using to complete the MCITP certifications for SQL Server....
2008-02-19
1,724 reads
How Stable is SQL Server 2005?
I've been calling for Service Pack 3 and I've been debating the need, the criticality, and even the problems with...
2008-02-19
1,521 reads
SQLSaturday #3 - Jacksonville 2008 - Registration and Call for Speakers is Open
My business partnerBrian Knight just finalized the venue for the next SQLSaturday. Number three will be held at the University...
2008-02-19
1,209 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