Two Digit Year Cutoff
I couldn't sleep this morning and decided to wake up and catch up on my email when I noticed a video link...
2010-12-15
1,657 reads
BrianKMcDonald
Group Level Page Numbering using Reporting Services 2008 R2
Using SQL Server Reporting Services, we have always had the ability to use the built in fields (the Globals collection)...
2010-12-14
17,989 reads
Adding Existing Reports to Reporting Services Solution
If you’re anything like me, you create a ton of objects and have them in various projects. And sometimes, you...
2010-12-13
541 reads
URL Based Images using SSRS
For header images, I typically embed an image into the report. However, there may be times when you need to...
2010-12-13
810 reads
Automating the Processing of a Measure Groups Index Using SSIS
In a recent post (Processing a Measure Groups Index Using SSMS), I showed you how to utilize SQL Server Management...
2010-12-07
1,001 reads
Processing a Measure Groups Index Using SSMS
As I had mentioned in a previous blog (Creating and processing an Analysis Services partition), instead of processing an entire...
2010-12-02
1,240 reads
SQL Server Magazine’s Favorite Go-To Websites for SQL Server Solutions
While flipping through this month’s SQL Server Magazine (December 2010), I came across what I thought was a very interesting...
2010-11-30
3,956 reads
SSIS Package Annotation in Denali
If you are anything like me, you document your SSIS packages for those who may have to maintain them after...
2010-11-30
3,749 reads
Column Based Indexing in Denali
Recently, I was asked to install Denali for a client because one of the employees attended PASS 2010 and had...
2010-11-24
925 reads
What’s New In Denali for SSRS
I was so excited when I found out that Denali was released last week. Like it was Christmas time, I...
2010-11-23
587 reads
Blogs
Day 2 at PASS Data Community Summit 2024
By Steve Jones
I missed blogging yesterday as I was on stage/backstage for quite a bit of...
PASS Summit 2024 – Wednesday
By Brian Kelley
A common theme in the PASS Summits I've attended is community and that's definitely...
Taming Database Challenges: Insights from Redgate Keynote
By Chris Yates
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying...
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