Disk Space Checker
One method my company deploys our software is in a dedicated hosted environment. In this situation, we partner with a...
2013-03-28
1,174 reads
Blog Posts
Exploring Excel 2013 for BI Tip #4: Adding a Slicer
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-03-28
1,965 reads
SQL Server 2012 Business Intelligence Enhancements
My first article in SQL Server Pro magazine has been published. It is entitled “SQL Server 2012 Business Intelligence Enhancements”...
2013-03-28
1,569 reads
SQLTreeo – Migration of extended properties to local storage
New SQLTreeo version introduced local storage option when your folders are stored to file system as structure of files and...
2013-03-28
1,686 reads
SSPI error and Incorrect timing.
TweetG’day,
Recently, quite out of the blue I started seeing this error when I tried to log into my SQL instance...
2013-03-28
1,664 reads
Execution Plans in Azure SQL Database
Microsoft has stated pretty clearly that they’re putting code on Azure first, ahead of the desktop. Which makes one wonder...
2013-03-27 (first published: 2013-03-25)
3,641 reads
Network Packet Size: to Fiddle With or Not to Fiddle With
A network pipeline isn’t nearly as pleasant to look at as the oil pipeline (or anything) in Alaska, but it’s...
2013-03-27
3,272 reads
PowerShell Usage in DBA Work – Case Study 6/7
SQL Server SMO is a great resource for DBAs, unfortunately, before PowerShell, it is a pretty deep learning curve to...
2013-03-27 (first published: 2013-03-23)
2,720 reads
The DBA Team #1–Code and Slides
Our first DBA Team event, in Richmond, VA just before SQL Saturday #187 went well. Overall I think our experiment...
2013-03-27
1,651 reads
What to Do When You Can't Wipe an Infected System
When it comes to workstations within most organizations, the solution when one gets infected is to wipe it and re-image...
2013-03-27
2,668 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