Pointers For SQL Saturday Attendance
I recently got an email from another SQL Saturday organizer asking for "pointers for getting more attendees" to their upcoming...
2013-08-20
488 reads
Will Assaf
Cannot find NT Service\MSSQL$SQL2012?
If you cannot find the virtual account used by the default settings installation of your SQL 2012 instance (in this...
2013-08-16
1,184 reads
Distribution setup SQL Server Agent error: "RegCreateKeyEx() returned error 5, 'Access is denied.'"
In the Configure Distribution Wizard, the step "Configuring SQL Server Agent to start automatically" errors with the following text:
TITLE: Configure...
2013-08-15
11,576 reads
Baton Rouge Startup Weekend
I'm spreading the word out about an event this weekend called Startup Weekend.
It's an event for developers, designers, and entrepreneurs...
2013-08-13
619 reads
Recap from SQL Saturday Baton Rouge 2013
As the head of the planning committee for SQL Saturday Baton Rouge this year, I had the distinct pleasure of...
2013-08-04
794 reads
SQL Saturday Baton Rouge 2013
SQL Saturday is a global event to bring Information Technology speakers and professionals together for a community-driven, community-attended free day...
2013-06-11
565 reads
SQL Saturday Baton Rouge Call for Speakers closes June 6!
SQL Saturday Baton Rouge Call for Speakers is open through June 6 (closes June 7 at midnight).
This year's pre-conference banquet...
2013-06-04
660 reads
Hunt Down Tables Without Clustered Indexes
This one's a gimme, but an underrated utility script when I enter a new environment and look for low-hanging fruit...
2013-05-09 (first published: 2013-05-03)
2,557 reads
Use the Default System Trace to Find Autogrowth Events
The SQL Server Management Studio built-in standard report for "Disk Usage" is very handy to view the performance-sucking autogrowth events...
2013-05-03
2,285 reads
TRY_CONVERT broken by WITH SCHEMABINDING in SQL Server 2012 Data Tools build
Here's a bug you might find if attempting to schemabind an object that uses the new TRY_CONVERT function.
To reproduce, run...
2013-03-21
1,011 reads
Blogs
A New Word: Skidding
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
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...
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