Possible interview questions for Intern/Junior DBA or Developer
I wrote these questions thinking about what some basic t-sql statements that I would want to see if I were...
2008-05-10
3,792 reads
Blog Posts
A View Variable
I saw that Erland Sommerskag posted a Connect item that asked for a "View Variable" to be added to the...
2008-05-09
1,254 reads
A little fun with SSIS Expression Language
The SSIS expression language is a powerful yet enigmatic entity. Once you get used to its syntax - which is part...
2008-05-08
4,820 reads
Follow Up Notes on SQLSaturday #3
Our most recent SQLSaturday went well, but there is always room for improvement. Here are my notes from this event:
The...
2008-05-08
385 reads
Kindle Research - Procs and Cons with the Sony Reader
After the editorial on the Kindle, which got quite a few responses, I've continued to look around and research things....
2008-05-08
958 reads
ACM, 5 Year Anniversary, and Customer Service
Time moves by and I was surprised to get a coffee mug in the mail from ACM (Association for Computing Machinery)...
2008-05-07
479 reads
Thoughts on SQL Saturday in Jacksonville
I was able this Saturday to head down to Jacksonville and speak at the SQL Saturday there. There were a...
2008-05-07
722 reads
One More SQL Feature Wish
It would be handy to have a checkbox/SET option/something that would tell SQL not to cache plans run in a...
2008-05-06
402 reads
Photos from SQL Saturday
Check out the photos from SQL Saturday 3 - Jacksonville:
http://tim-mitchell.spaces.live.com/
2008-05-06
885 reads
SQL Backup 5 (Red Gate)
So after many months of trudging through native SQL Server backups for new mission-critical application I'm deploying, I have decided...
2008-05-06
667 reads
Blogs
PASS Data Community Summit 2024 Day 3 Keynote
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
A New Word: Skidding
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
PASS Summit – Thursday
By Brian Kelley
Let’s start with the keynote. The biggest take away was how having to support...
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