New Personal Site Launched !
Hey there folks. I finally was able to get my persona domain name from a squatter who has been holding...
2009-10-21
383 reads
Hey there folks. I finally was able to get my persona domain name from a squatter who has been holding...
2009-10-21
383 reads
My presentation and sample files from SQLSaturday in Orlando are now online for you to download. Check them out at...
2009-10-21
382 reads
When working with a dimensionally modeled data warehouse it is common for a large number of your queries to follow...
2009-09-16
5,791 reads
There are many different ways to manipulate dates when working with them in SSIS. Many great examples have been posted...
2009-09-10
1,154 reads
Have you ever wondered where to go to get good information that will help you in your day to day...
2009-09-09
450 reads
Hey there Gang !
Most of you probably know Jamie Thompson has move his blog over to SQLBlog.com. This is worth noting...
2009-09-09
412 reads
There are many different ways to manipulate dates when working with them in SSIS. Many great examples have been posted...
2009-09-08
3,468 reads
Have you ever received the following error when developing your ETL or working with data cleanup?
Msg 544, Level 16, State...
2009-09-08
573 reads
Have you ever lost your project file for a SQL Server Analysis Services database? There is a great option to...
2009-09-08
588 reads
Intellisense is one of my favorite features in SQL Server Management Studio and BIDS for 2008. A common frustration I...
2009-09-08
970 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