User Group Meeting – Migrate your SSIS skills to ADF & More
This Monday (the 5th of December 2022), my employer AE hosts a user group meeting for dataminds. There will be two sessions: It’ll be a very interesting evening, and...
2022-11-30
12 reads
Blog Posts
Automatically Take Missed Backups with Ola Hallengren’s Scripts
I blogged a few years ago about my configuration tables for Ola Hallengren’s maintenance solution that allows me to pull the configuration parameters from tables
The post Automatically Take Missed...
2022-11-29
36 reads
SQL Server 2022 is GA!
The big announcement at the PASS Data Community Summit 2022 was that SQL Server 2022 is now generally available. See the official announcement. My top 10 list of new...
2022-11-29
41 reads
Daily Coping 28 Nov 2022
Today’s coping tip is to broaden your perspective: read a different source of media. I’m off to the UK today. I tend to read books a lot when I...
2022-11-28
7 reads
Database Mirroring login attempt failed with error: ‘Connection handshake failed. An OS call failed: (80090302) 0x80090302(The function requested is not supported).
Here’s a quick one for today and is an issue that had me stumped for a while. It’s not one that I’d come across before and there isn’t really...
2022-11-28 (first published: 2022-11-16)
286 reads
How to cluster SAP ASCS/SCS with SIOS DataKeeper on VMware ESXi Servers
This article describes the steps you take to prepare the VMware infrastructure for installing and configuring a high-availability SAP ASCS/SCS instance on a Windows failover cluster by using SIOS...
2022-11-28
103 reads
How to Install SQL Server 2022
SQL Server 2022 has been released! In this blog post, I’ll walk you through how you can install the latest version of SQL Server on your machine. I’ll be...
2022-11-28 (first published: 2022-11-17)
1,614 reads
Tell My Story of Public Speaking
This month the fine folks behind New Stars of Data and the DataGrillen Newcomer Track bring us the Tell Your Story blog party. Where we
The post Tell My Story...
2022-11-28
35 reads
The Last Trip of 2022
It’s the last trip for me today. I head to the UK for a few work things and then my wife is coming over to take a quick vacation...
2022-11-28
97 reads
Daily Coping 25 Nov 2022
Today’s coping tip is to connect with someone from a different generation. This tip makes me feel old. When I see “different generation” I used to think of someone...
2022-11-25
7 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