IF RDBMS = SQL Server, NoSQL = ???
SQL Server is, arguably, the leading relational database management system out there. With continuous development and enhancement of exciting features...
2017-11-08
448 reads
SQL Server is, arguably, the leading relational database management system out there. With continuous development and enhancement of exciting features...
2017-11-08
448 reads
It’s said that “promises are made to be broken”. Surely database administrators don’t fall in that category? It’s that time...
2016-12-28
683 reads
Is this one of those weird food combinations like honey on pizza or salt and pepper on apples that’s going...
2016-11-22
565 reads
Three men are in a hot-air balloon. Soon, they find themselves lost in a canyon somewhere. One of the three...
2016-09-20
393 reads
Suffering SQL Server Performance Issues?: A story of Olympic sprints and handy SQL Server hints!!!
Usain Bolt, the world’s fastest runner,...
2016-08-18
370 reads
Recently, a customer mentioned that they seemed to be missing records in tables they don’t delete from. Generally, at this...
2016-02-25
1,436 reads
SQL Server statistics can make things a bit freaky. You might have read one of my previous articles portraying a...
2015-10-30
1,519 reads
Microsoft are releasing regular CTP updates for SQL Server 2016. In the very recent release (CTP 2.4), there is a...
2015-10-20 (first published: 2015-10-16)
3,528 reads
Statistics, in simplest terms, refer to the distribution of data in a column or index. They are represented in a...
2015-09-21
754 reads
Look at some of the graphs produced by the intra query parallelism deadlocks, below.
Bart Duncan explains this “phenomenon” (bug, rather)...
2015-09-10
1,357 reads
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
By Brian Kelley
Let’s start with the keynote. The biggest take away was how having to support...
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...
Comments posted to this topic are about the item Technology Fears
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