We have some data we can query using the serverless SQL pools in Azure Synapse Analytics. For this blog post, I’m querying data that is stored in Azure Cosmos...
2022-12-09 (first published: 2022-11-23)
239 reads
I’ve republished an editorial today from another author, called What do you do to relax after work? I’m thinking about that a few weeks ahead, because I needed to...
2022-12-09
20 reads
One of my favorite parts of having a new job is that I learn a ton. (No really, my brain ... Continue reading
2022-12-08
119 reads
Today’s coping tip is to be curious. Learn about a new topic or an inspiring idea. My daughter pointed a new podcast out to me: What’s Her Name? This...
2022-12-08
7 reads
Unity Catalog in Databricks provides a single place to create and manage data access policies that apply across all workspaces and users in an organization. It also provides a...
2022-12-07 (first published: 2022-11-23)
233 reads
Today’s coping tip is to stop for a minute when you walk outside and just enjoy nature. It’s getting cold in Colorado, but we had a day recently that...
2022-12-07
10 reads
One of the reasons you may be considering encryption is due to the relevant data protection regulation: either because the regulation specifies that data should be encrypted or because...
2022-12-07
19 reads
We’ve all been there as DBAs…people requesting access to the servers that we look after to be able to view certain things. I’ve always got, well, twitchy with giving...
2022-12-07 (first published: 2022-11-23)
343 reads
Today’s coping tip is to find a new way to tell someone you appreciate them. My daughter is away at school, but she has a prescription that is still...
2022-12-06
11 reads
Welcome to the final T-SQL Tuesday for 2022. My ask is, what do you have planned for end-of-year activities for your SQL environment? Do you have annual processes or...
2022-12-06
2 reads
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
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...
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