February '14 Acadiana SQL Server User Group
I am honored to be the very first presenter of the new PASS chapter in Lafayette, Louisiana this Tuesday, presenting...
2014-02-23
604 reads
I am honored to be the very first presenter of the new PASS chapter in Lafayette, Louisiana this Tuesday, presenting...
2014-02-23
604 reads
I will be speaking and whiteboarding for Data Architecture Virtual Chapter meeting on February 27, 2014 on the fitting topic...
2014-02-23
466 reads
Wrote this email exchange with some developer colleagues about to embark on performance tuning.
Subject: bag o' tricks from DMV talk
From: A. Developer
Hey...
2014-02-12 (first published: 2014-02-05)
2,078 reads
After the restore of a database, or perhaps a bare-metal restore of a Windows server running SQL Server, unique IDs...
2014-01-30
1,115 reads
If you've already configured your local machine's PowerShell environment to interact with your Azure subscription (see here: http://www.windowsazure.com/en-us/documentation/articles/install-configure-powershell/), then you can...
2014-01-30 (first published: 2014-01-27)
1,720 reads
I often use these scripts to check on the backups of all databases in an unfamiliar SQL Server instance, regardless...
2014-01-22
543 reads
I was recently approached by a client who was running SQL Server 2008 with some databases in SQL 2000 compatibility...
2014-01-15
1,137 reads
I know this might seem like an odd topic on a SQL Server blog, but it's a common and critical...
2014-01-07
1,159 reads
Assuming you're in a case-insensitive ("CI" in the collation name) column, this UPDATE statement:
UPDATE tablefoo
set foo = 'Z'
where foo = 'z'
will just...
2013-12-20 (first published: 2013-12-16)
1,764 reads
There's an issue with some characters in T-SQL when validating numeric values out of raw varchar fields, and it can...
2013-12-17 (first published: 2013-12-12)
5,569 reads
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...
By Steve Jones
I missed blogging yesterday as I was on stage/backstage for quite a bit of...
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