My First Technical Job – T-SQL Tuesday #150
I’m late to the party on May’s T-SQL Tuesday, but thought it was an interesting enough topic to be worth a belated blog post. It’s about first technical jobs...
2022-06-05
28 reads
Sqlrider - Speed enthusiast
Upgrade Strategies – T-SQL Tuesday #147
This month’s T-SQL Tuesday is about how we look at SQL Server upgrades, hosted by Steve Jones. My experience of SQL upgrades is that they tend to be largely...
2022-02-08
2 reads
A Hard Drive Retrospective – SQL Server Edition
Sometimes it’s good to look back and appreciate what we have and how far we’ve come. This applies to many things, but today I’m talking about the humble hard...
2022-02-18 (first published: 2022-02-06)
546 reads
Estimating Nonclustered Index Size in SQL Server (Powershell)
I recently encountered a requirement to estimate the size of (a lot of) nonclustered indexes on some very large tables due to not having a test box to create...
2021-08-13 (first published: 2021-08-01)
436 reads
Estimating Nonclustered Index Size in SQL Server (Powershell)
I recently encountered a requirement to estimate the size of (a lot of) nonclustered indexes on some very large tables due to not having a test box to create...
2021-08-01
2 reads
Nonclustered index leaf records always contain a null bitmap – since SQL 2012
While testing a script that involved calculating index record size recently I was getting some confusing results depending on server version, and after some digging it appears there was...
2021-07-28
50 reads
Nonclustered index leaf records always contain a null bitmap – since SQL 2012
While testing a script that involved calculating index record size recently I was getting some confusing results depending on server version, and after some digging it appears there was...
2021-07-28
2 reads
Automating AlwaysOn Availability Group Failover for SSISDB 2012/2014
Hopefully not many people are still configuring SSIS instances on SQL 2012 or 2014 – especially HA instances – but if you are, this post is for you. If...
2021-05-28
75 reads
Automating AlwaysOn Availability Group Failover for SSISDB 2012/2014
Hopefully not many people are still configuring SSIS instances on SQL 2012 or 2014 – especially HA instances – but if you are, this post is for you. If...
2021-05-28
1 reads
A Very Simple Blocking Alert
Blocking in SQL Server can be good – after all, it’s one of the ways consistency is guaranteed – we usually don’t want data written to by two processes...
2021-05-24 (first published: 2021-05-13)
708 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