Certifications: What are they good for?
Reblogged from SQL Studies: Since Microsoft decided to drop the MCM/MCA program there has been an enormous amount of discussion...
2013-09-16
614 reads
Reblogged from SQL Studies: Since Microsoft decided to drop the MCM/MCA program there has been an enormous amount of discussion...
2013-09-16
614 reads
Reblogged from SQL Server Portal: I came across this query many times and most often we need the previous row...
2013-09-16
690 reads
This lesson is the third and last part of topic for Managing Data which covers 20% of the certification exam....
2013-09-08
696 reads
This topic is the second part for lesson Manage Data which covers 20% of the examination. Understanding Backup Types SQL...
2013-09-01
536 reads
This review topic is part of Managing Data lesson which covers 20% of the certification exam. SQL Server Agent enables...
2013-08-31
1,198 reads
More than running sp_who2, which gives you more information than the good ol’ sp_who, or querying sys.dm_exec_sessions to check all...
2013-08-24
796 reads
When doing any kind of troubleshooting in your SQL Server first thing you ask is who is currently connected to...
2013-08-24
661 reads
I have a setup of Central Management Servers in my SQL Server and it’s been a big help to me...
2013-08-14
693 reads
This review topic is still covered under the Optimize and Troubleshoot SQL Server lesson which covers 14% of the exam....
2013-08-13
581 reads
Prior to building and deploying your SSIS project to the SQL SSIS server, you need to build and create a...
2013-08-02
885 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