SQL Bits – Europe’s largest SQL Conference
4th 7th March
ExCeL Centre in London, England
SQLBits have announced their dates for 2015.
I have been three times and...
2014-12-12
1,396 reads
Gethyn Ellis
Win a Free Copy of my Book - Getting Started with SQL Server 2014 Administration
Readers of my blog would be pleased to know that I have teamed up with Packt Publishing and we are...
2014-06-12
720 reads
I’ve Written a Book…Getting Started with SQL Server 2014 Administration
That’s folks you heard it here first. Since the end of 2013 through to April this year I have been...
2014-05-14 (first published: 2014-05-07)
2,236 reads
SSMS Add-ons
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on...
2014-05-05 (first published: 2014-04-24)
24,961 reads
Central Management Studio CMS
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-28 (first published: 2014-04-21)
1,956 reads
From where does SSMS get its database defaults?
We can create a database simply by typing in the command createdatabase DB1
We don’t have to provide any other...
2014-04-25 (first published: 2014-04-16)
2,363 reads
SSMS Queries on Function Keys
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-23
1,041 reads
SQL Server Training – Spring 2014
I have just returned from a trip to Washington DC where I was delivering course 2105 – SQL Server 2012 DBA...
2014-04-22
837 reads
SSMS Auto Recovery
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write...
2014-04-17
826 reads
Missing Database Owner
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-14
2,770 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