Introduction to Using Profiler with SSAS 2008
There are many ways to optimize your analysis services cubes, but the real trouble is how do you know where...
2010-02-22
594 reads
There are many ways to optimize your analysis services cubes, but the real trouble is how do you know where...
2010-02-22
594 reads
This whitepaper from Greg Lowe talks about the important strategy behind disk partition alignment. This is focused mainly in SQL...
2010-02-21
512 reads
Ok so I know a statement like that will whip some of you into a frenzy, but it’s true. No...
2010-02-21
527 reads
I am excited to be speaking at SQLLunch.com on March 1st. SQL Lunch is a great website event where Host...
2010-02-21
341 reads
There are a large number of Member functions in MDX that do everything from returning ancestry of a member to...
2010-02-21
1,681 reads
When configuring measure groups in SSAS, you want to make sure you address a few important properties. They are show...
2010-02-21
2,873 reads
When configuring measures in SSAS, you want to make sure you address a few important properties. They are show in...
2010-02-21
1,094 reads
There is a recently published whitepaper that talks about Microsoft AdCenter using SSAS 2008 to accelerate performance over 2005. Most...
2010-02-21
521 reads
Recently, I was working with a client we were working on a calculated measure using the aggregate function to rollup...
2010-02-21
665 reads
One of the most aggravating things when work with the SSIS expression language is when you have to combine file...
2010-02-20
2,041 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