Some Pester Tests for SQL Defaults
When I was at PowerShell Conference EU in Hannover last month (The videos are available now – click here and the...
2016-05-24
606 reads
SQL DBA With A Beard
DBA Database scripts are on Github
It started with a tweet from Dusty
The second session I presented at the fantastic PowerShell Conference Europe was about using the...
2016-05-16
780 reads
A Day In The Life of a SQLBits Volunteer
So SQLBits has finished for another year. About 1500 people registered for the largest SQL Conference in Europe held over...
2016-05-10
648 reads
Using PowerShell to set Extended Events Sessions to AutoStart
When you look after more than a few SQL Servers you will need to perform the same actions against a...
2016-04-08 (first published: 2016-03-28)
1,660 reads
Backing up to URL container name – case is important
If you use SQL Backup to URL to backup your databases to Azure blob storage remember that for the container name...
2016-03-11 (first published: 2016-03-03)
1,211 reads
PowerShell Pester Testing for Parameter Validation
This error caught me out. I am putting this post here firstly to remind me if I do it again...
2016-02-08 (first published: 2016-01-31)
1,744 reads
PowerShell Pester Testing for Parameter Validation
This error caught me out. I am putting this post here firstly to remind me if I do it again...
2016-01-31
711 reads
PowerShell Pester – "The script failed due to call depth overflow."
This error caught me out. I am putting this post here firstly to remind me if I do it again...
2016-02-04 (first published: 2016-01-31)
1,690 reads
PowerShell Pester – "The script failed due to call depth overflow."
This error caught me out. I am putting this post here firstly to remind me if I do it again...
2016-01-31
843 reads
Temporary Post Used For Theme Detection (7bc987a8-70ff-4bce-b0b5-d4bad4ef7912 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (c6d728fb-93d8-4ec0-a66c-6dd5e7281550 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2016-01-14
440 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