SQL Server 2022 is Here!
SQL Server 2022 becoming generally available was announced on Nov 16th 2022. This is the most Azure-enabled release of SQL Server yet, which is pretty exciting. A major Azure-enabled...
2022-11-17
8 reads
SQL Server 2022 becoming generally available was announced on Nov 16th 2022. This is the most Azure-enabled release of SQL Server yet, which is pretty exciting. A major Azure-enabled...
2022-11-17
8 reads
Foreword
Thank you everyone for participating! There is a total of 15 submissions and thanks to them, I’ve widened my perspective.
The order of the posts is chosen at random.
Greg Moore
Contribution|Blog|Twitter
Greg...
2022-11-17
7 reads
Happy to be chosen to live blog the keynote events out at the PASSDataSummit in Seattle, Washington this week. This page will be updated through the Keynotes, all you...
2022-11-16
13 reads
A while back I wrote a post about creating a pacemaker cluster to run SQL Server availability group using the new Ubuntu images in Azure. Recently I had to...
2022-11-16 (first published: 2022-11-03)
143 reads
Today’s coping tip is to change your normal routine today and notice how you feel. I am a person who likes a routine. While I travel a lot and...
2022-11-16
6 reads
I’m part of a Redgate promotion at the PASS Data Community Summit. They ordered some Lego Steve’s, which will be available at the booth. You can post some photos...
2022-11-16
16 reads
In publishing, and Im sure many other industries, we get data at both the daily level and the weekly level. To properly tie these two pieces of data you...
2022-11-16 (first published: 2022-11-05)
299 reads
I’ve been reading Bob Ward’s book “SQL Server 2022 Revealed” and one of the new features in Intelligent Query Processing (IQP) jumped out at me. Not because it’s going...
2022-11-16
74 reads
It's that time again...TUESDAY!
https://www.mememaker.net/static/images/memes/4791280.jpg
I mean...NOVEMBER!
https://tinyurl.com/33hezsje
OK fine...SUMMIT!
https://img.memegenerator.net/images/10802365.jpg
I have very much missed in-person events and I am glad that Redgate (@Redgate) has managed to continue the @PASSDataSummit framework - virtual presentations...
2022-11-16
42 reads
Today’s coping tip is to sign up to try a new activity, course, or community. I somewhat did this early in the fall by choosing to go through the...
2022-11-15
8 reads
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...
By Steve Jones
I missed blogging yesterday as I was on stage/backstage for quite a bit of...
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