SSRS Tip: Simplest Method to Pass MDX Multi-Select Parameters to MDX Datasets I recently ran across a poorly covered topic in regards SSRS development using MDX parameters and datasets. After...
2013-02-07
8 reads
HP Announcement: PDW V2 Appliance Features
New features for the HP’s Enterprise Data Warehouse (EDW) V2 appliance for SQL Server...
2012-11-16
2,196 reads
HP Announcement: PDW V2 Appliance Features New features for the HP’s Enterprise Data Warehouse (EDW) V2 appliance for SQL Server PDW have been announced! Highlights: Lower price point (backup...
2012-11-16
8 reads
As with any other project our objective is to drive PDW POC success! To clear and cultivate the playing field...
2012-10-23
1,134 reads
As with any other project our objective is to drive PDW POC success! To clear and cultivate the playing field for successful POC engagements, we must, at a minimum,...
2012-10-23
9 reads
I received the following error today when attempting to use Visio’s ‘Database Model Diagram’ template under category ‘Software and Database’.
The...
2012-10-18
1,167 reads
I received the following error today when attempting to use Visio’s ‘Database Model Diagram’ template under category ‘Software and Database’. The program VISIO.EXE version 14.0.6122.5000 stopped interacting with Windows...
2012-10-18
22 reads
When loading tables in Microsoft’s Parallel Data Warehouse (PDW) via T-SQL, one will soon encounter the need to load data...
2012-10-15
1,816 reads
When loading tables in Microsoft’s Parallel Data Warehouse (PDW) via T-SQL, one will soon encounter the need to load data into a new table. Whether the developer needs to...
2012-10-15
22 reads
Before we get to the backup and restore syntax, its worth noting that the Parallel Data Warehouse (PDW) appliance architecture offers...
2012-10-04
5,384 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