SQL Server 2022 is Coming
We still don’t have an exact release date for SQL Server 2022 but at this stage we can have strong confidence that it will be with us before the...
2022-11-15
84 reads
Blog Posts
Daily Coping 14 Nov 2022
Today’s coping tip is to get outside and observe the changes in nature around you . Nature is changing in Colorado as winter approaches. It’s been a dry year,...
2022-11-14
9 reads
Getting Started Speaking – #NewStarNovember
My journey might be somewhat unusual, but perhaps not. I started writing articles on the Internet at a few different places before I started SQL Server Central. There were...
2022-11-14 (first published: 2022-11-01)
80 reads
SQL Homework – July 2022 – Getting ready for the next time you have to look for a job.
Back in July I suggested that you get your resume up to date. It’s something I’d wish I’d kept up ... Continue reading
2022-11-14 (first published: 2022-11-01)
248 reads
Tales From The Field Weekly Wrap Up for the Week of 11-07-2022 Run Disney, Gareth, & Veteran's Day
Hello Dear Reader! Last week I was fresh off of finishing the Run Dinsey 5K, 10K, & Food and Wine Half Marathon. My good friend Josh Luedeman (@JoshLuedeman |...
2022-11-14
46 reads
The Importance of New Speakers–#NewStarNovember
Many of us have learned how to research and get new information online. I certainly think the written word, whether from formal articles at places like SQL Server Central...
2022-11-14
4 reads
PASS Data Community Summit 2022
As I write this, it’s the weekeend before PASS Data Community Summit 2022 and depending upon when I finish, it’ll post either shortly before SQL Saturday Oregon, or in...
2022-11-12
35 reads
Cloning in Snowflake
Cloning is a powerful feature within snowflake (also known as zero copy clone). You can obviously clone at the database or schema level but also tables too. It’s a...
2022-11-11
79 reads
Create Service Principal Names Along with a Managed Service Account
In a few previous articles, I have talked a lot about Managed Service Accounts (MSA) and Service Principal Names (SPN) and given examples of managing the separately. As a...
2022-11-11 (first published: 2022-11-01)
315 reads
Daily Coping Tip 11 Nov 2022
Today’s coping tip is to make a list of new things you want to do before the end of the year. Hmm, definitely some things to do, but what’s...
2022-11-11
7 reads
Blogs
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...
Day 2 at PASS Data Community Summit 2024
By Steve Jones
I missed blogging yesterday as I was on stage/backstage for quite a bit of...
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