Monday Monitor Tips: Changing the Fragmentation Alert
I had a customer that was concerned about the fragmentation alert for indexes and wanted to know how to change it. This post discusses the change. This is part...
2024-08-19
21 reads
I had a customer that was concerned about the fragmentation alert for indexes and wanted to know how to change it. This post discusses the change. This is part...
2024-08-19
21 reads
My personal experience Dockerizing a Ruby on Rails Application: Deploy to AWS ECR using Github ActionsI recently received a request on how to Dockerize a Ruby on Rails application after...
2024-08-19
28 reads
This post is dedicated to all 10 other DBAs that use Service Broker (you know who you are).
The main reason for this blog post is that I’ve got no...
2024-08-19 (first published: 2024-08-09)
164 reads
This is my own contribution to the T-SQL Tuesday I am hosting – on managing database code. I am from the older generation – where the farthest we went...
2024-08-18
28 reads
Here are the resources from my talks today. Best Practices for Seamless Database Deployments PPTX slides Architecting Zero Downtime Deployments git repo: https://github.com/way0utwest/ZeroDowntime PPTX slides Some good questions today,...
2024-08-18 (first published: 2024-08-17)
40 reads
povism – n. the frustration of being stuck inside your own head, unable to see your face or read your body language in context, only ever guessing how you...
2024-08-16
16 reads
The Problem While performing an instance migration this spring, I happened upon something I didn’t expect in [dbatools](https://dbatools.io/). It should have been a simple backup/restore copy of the databases,...
2024-08-16 (first published: 2024-08-06)
252 reads
Our special projects team was eager to build Beeper a new blogging home. Here's the beautiful result.
2024-08-16 (first published: 2024-08-15)
14 reads
This is a quick blog post to announce that I am reviving Kilt Day at PASS Data Community Summit. Over the last few years… ah hell, let’s just say...
2024-08-16 (first published: 2024-08-01)
122 reads
Social media has become unruly and hard to navigate. (An understatement, we know.) How can the fediverse make social media fun again? Tune in.
2024-08-16
5 reads
By Steve Jones
I missed blogging yesterday as I was on stage/backstage for quite a bit of...
By Brian Kelley
A common theme in the PASS Summits I've attended is community and that's definitely...
By Chris Yates
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying...
Generative AI is revolutionizing various industries by streamlining operations and enhancing creativity. In marketing,...
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...
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