State of the Database Landscape Survey 2024
Hello all! This post is nothing but a simple request. Please, if you have a few spare minutes, meander on over to this link and fill out the State...
2024-09-04 (first published: 2024-08-13)
141 reads
Blog Posts
Simple Talks Episode 5
The fifth episode of Simple Talks is out. Simple Talks is the Redgate podcast from myself, Grant, Ryan, and Louis. The main page is here, and it has links...
2024-09-03
39 reads
The Secrets of One of the World’s Largest Ad-Free Blogs
There are no secrets about how PostSecret handles millions of visitors.
2024-09-03
13 reads
The Secrets of One of the World’s Largest Ad-Free Blogs
There are no secrets about how PostSecret handles millions of visitors.
2024-09-03
2 reads
Using T-SQL Snapshot Backup - Point in Time Recovery - Azure Edition
Introduction In this post, the third in our series on using T-SQL Snapshot Backup, I will guide you through using the new T-SQL Snapshot Backup feature in SQL Server...
2024-09-03
13 reads
Building a Cost-Effective SQL Server Failover Cluster in Google Cloud Platform
Building a SQL Server Failover Cluster in Google Cloud Platform (GCP) is a powerful way to ensure your databases remain highly available, even in the face of unexpected failures....
2024-09-02 (first published: 2024-08-13)
243 reads
Expanding Northwind with Prompt+
I was trying to do a little testing of our subsetter and needed a larger database. So I decided to ask Prompt + to help me with a little...
2024-09-02 (first published: 2024-08-14)
195 reads
Using T-SQL Snapshot Backup - Are Snapshots Backups?
Introduction Traditional SQL Server backups can struggle with large databases, resulting in longer backup times and resource contention. T-SQL Snapshot Backup, a new feature in SQL Server 2022, addresses...
2024-09-01 (first published: 2024-08-31)
56 reads
A New Word: Flashover
flashover – n. the moment a conversation becomes alive and real, when a spark of rust shorts out the delicate circuits you keep insulated under layers or irony, momentarily...
2024-08-30
8 reads
Developer Q&A: Dika Fei of Jelly Pixel Studio
"Let me know where you get your magic pixie dust from!"
2024-08-30
20 reads
Blogs
Day 2 at PASS Data Community Summit 2024
By Steve Jones
I missed blogging yesterday as I was on stage/backstage for quite a bit of...
PASS Summit 2024 – Wednesday
By Brian Kelley
A common theme in the PASS Summits I've attended is community and that's definitely...
Taming Database Challenges: Insights from Redgate Keynote
By Chris Yates
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying...
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