Manage Reporting Services using SSMS
Sometimes you’ll want to manage reporting services functionality through SQL Server Management Studio (SSMS). This would be the case if...
2010-06-29
2,340 reads
Getting Drive Info Part 1, sp_OA
This blog series will cover several different methods to collect drive information from a Windows server that is running SQL...
2010-06-29
2,655 reads
SQL Server Instance Checklist
This is my third in a series of checklists that I am putting together for a new book designed for...
2010-06-29
2,961 reads
ASK SQLServerCentral - The New Community Model
We had an unexpected switch last weekend. My boss decided that we were ready to move from the Stack Exchange...
2010-06-29
1,741 reads
Function Calls are Evil Incarnate
The following queries look extremely innocent. However, they are all application killers once the target table grows to more than...
2010-06-28
1,357 reads
AWOL: DBA Turned Gardener Temporarily, but Still Obsessed with Transaction Log Files
After 10 Years, a Move Closer to School and Work
Wow, how moving house interrupts life. I can appreciate we have...
2010-06-28
516 reads
PASS Update #35
It’s been a busy month for me for PASS activities. I spent almost the entire week last week on PASS...
2010-06-28
704 reads
First Performance Virtual Chapter Webcast
Thanks to the outstanding efforts of Tim Edwards (twitter | blog), our fearless leader, and the rest of the crew, the PASS...
2010-06-28
901 reads
2010-06-28
688 reads
Kent Sql Server UserGroup
One of my back burner projects is to setup a local user group.
I'm delighted to now say that this is...
2010-06-28
405 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
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...
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