Backup Compression in SQL Server 2008 – The Complete Presentation
From the PASS 2010 Summit Survey: 29% of people want a presentation on backup compression. OK, here it is.
Turn it...
2010-04-28
2,369 reads
A DMV a Day – Day 28
The DMV for Day 28 is sys.dm_io_pending_io_requests, which is described by BOL as:
Returns a row for each pending I/O request...
2010-04-28
1,265 reads
BLOB Index Columns
For the April T-SQL Tuesday, I blogged about a report to find information on the BLOBs in a database. I...
2010-04-27
1,233 reads
SQL Server 2008 and 2008R2 Diagnostic Information Queries
Since SQL Server 2008 R2 has gone RTM, and will be available on MSDN Subscribers on May 3, I thought...
2010-04-27
1,929 reads
The PowerShell and XML Corollary
Girl Property Surrounded by Geek Objects
I’ve just started watching The Big Bang Theory so I figured I’d borrow a naming...
2010-04-27
802 reads
In, Exists and join – a roundup
Over the last several months I’ve had a look at IN, Exists, Join and their opposites to see how they...
2010-04-27
1,351 reads
A DMV a Day – Day 27
The DMV for Day 27 is sys.dm_tran_locks, which is described by BOL as:
Returns information about currently active lock manager resources....
2010-04-27
7,553 reads
PASS Summit, Kilt Wednesday
Last year at the PASS Summit we held a silly little event called Kilt Wednesday. Only three people took part,...
2010-04-27
1,404 reads
SQLSaturday #49 Call for Speakers is Open & Call for Our PreCon Seminar
SQLSaturday #49 will be held in Orlando on October 16th, 2010, and our call for speakers is now open. We’re...
2010-04-27
592 reads
One Trip Booked – TechEd 2010
Tia thinks I’m crazy to book early, but I like to have a choice of flights, and I like to...
2010-04-27
781 reads
Blogs
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where...
EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00...
Forums
Backing Up a DMK
Comments posted to this topic are about the item Backing Up a DMK
The Quiet Part
Comments posted to this topic are about the item The Quiet Part
BIT_COUNT in SQL Server
Comments posted to this topic are about the item BIT_COUNT in SQL Server
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers