In the Interest of Disclosure
Yesterday I attended an internal training course on social networking. The class was targeted toward the 100 level, but like...
2010-09-03
413 reads
Yesterday I attended an internal training course on social networking. The class was targeted toward the 100 level, but like...
2010-09-03
413 reads
Today’s post is one that I have been debating on whether to publish for a while. The purpose of the...
2010-09-01
974 reads
This post provides the code for a stored procedure to move SSIS packages between SQL 2005 SSIS servers. Continue reading ?
2010-09-01
7 reads
This post provides the code for a stored procedure to move SSIS packages between SQL 2005 SSIS servers. Continue reading ?
The post A Stored Procedure to Move SSIS Packages...
2010-09-01
Mladen Prajdic (Blog|Twitter) recently announced that the newest version of SSMS Tools Pack is coming out and I am excited.
Why...
2010-08-20
524 reads
Mladen Prajdic recently announced that the newest version of SSMS Tools Pack is coming out and I am excited.
Continue reading ?
2010-08-20
1 reads
Mladen Prajdic recently announced that the newest version of SSMS Tools Pack is coming out and I am excited.Continue reading ?
The post Great News! SSMS Tools Pack 1.9 is...
2010-08-20
I recently finished taking down a bunch of servers that I was using to scale out my environment by forcing...
2010-07-16
511 reads
This script takes a distribution server name and an output directory as parameters then works through all publications on each of the servers that connects to the distribution server,...
2010-07-16
4 reads
This script takes a distribution server name and an output directory as parameters then works through all publications on each of the servers that connects to the distribution server,...
2010-07-16
2 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