Removing Identical Duplicate Rows
Deleting duplicate rows out of a table can be tricky. A brute force way to do this is with a...
2012-02-28 (first published: 2012-02-21)
4,205 reads
Deleting duplicate rows out of a table can be tricky. A brute force way to do this is with a...
2012-02-28 (first published: 2012-02-21)
4,205 reads
Here's a script from my toolbox I use to find dependencies between SQL objects. The where clause has a number...
2012-02-21
1,034 reads
"Cannot alter a server audit from a user database. This operation must be performed in the master database."
If you're trying...
2012-02-03
1,030 reads
Sent: Friday, January 20, 2012 10:30 AM
To: William Assaf
Subject: dba has a questionWilliam,
Can you send me references to support my contention that NOLOCK...
2012-01-24 (first published: 2012-01-21)
3,865 reads
This news may be a few months old, but it is worth noting that there is now a column called...
2011-12-16
1,376 reads
Got stored procedure problems? I feel sorry for you son.
Here's a quick query to pull the cached execution plan out...
2011-12-16
1,690 reads
A query that calls sys.dm_exec_requests and pulls the statement text out of the request is a handy script for any DBA's...
2011-10-19
3,143 reads
Here's my official blog page for my presentation on SQL Server Admin Best Practices with DMV's from the Houston TechFest...
2011-10-15
920 reads
One of the things I run into every now and then is this provincial idea that reports can and should...
2011-10-10
1,297 reads
At the Houston TechFest 2011 Conference at the University of Houston I will be hosting a User Group Leadership Summit...
2011-10-06
572 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