Select All in a Power BI Slicer–#SQLNewBlogger
One of the things I’ve been working on this year is a Power BI report for the kids I coaco in volleyball. As a part of this, I want...
2022-11-25 (first published: 2022-11-09)
217 reads
One of the things I’ve been working on this year is a Power BI report for the kids I coaco in volleyball. As a part of this, I want...
2022-11-25 (first published: 2022-11-09)
217 reads
This blog post is not about which User Interface is better, Classic or Snowsight – If anyone does want my feedback on what I like and don’t like about...
2022-11-25
219 reads
Today’s coping tip is to try a new way to practice self-care and be kind to yourself. One of the things that I learned to do better during the...
2022-11-24
4 reads
Today’s coping tip is to build new ideas by thinking “Yes, and what if…”. I tend to look for the holes, problems, limitations, and downside of various proposals. I’ve...
2022-11-23
5 reads
Foreword
Even though I picked the question, I struggled to answer it.
Following my train of thought - production code should be of the highest quality. To enforce quality, we use...
2022-11-23 (first published: 2022-11-08)
262 reads
It’s that time of the month again! It’s T-SQL Tuesday and this month Tom Zika (blog|twitter) is hosting. Tom would ... Continue reading
2022-11-23 (first published: 2022-11-08)
358 reads
Today’s coping tip is to do something playful outdoors. Easy. Skiing today. First day of the season. I started to add a daily coping tip to the SQL Server...
2022-11-22
9 reads
Today’s coping tip is to revisit a coping tip from the past and see if it helped you.. I came up with this one after I tried to do...
2022-11-21
9 reads
Fairly short post here. Due to the recent events around Twitter (which I will not get into), I’m making an effort to reduce or completely cease my activity on...
2022-11-21
24 reads
Just a quick post to let you know that there’s a great sale right now at Springer on my brand new, completely rewritten, query performance tuning book. Get your...
2022-11-21
42 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