Profisee Master Data Maestro
I have been using Microsoft’s Master Data Services (MDS) on a daily basis for the last 8 months. I also...
2013-03-07
3,124 reads
Blog Posts
Speaking at SQL Saturday Detroit on March 16
Ahhh – Motor City. What a fun place to start my 2013 SQL Saturday rounds! Detroit, here I come! You all...
2013-03-07
612 reads
SQL Saturday Kosovo #225
I’m so exciting to announce that the SQL Saturday Kosovo is going to be held on May 18, 2013 and...
2013-03-07
1,094 reads
SQL Server – TSql to find Records matching certain criteria in all the tables of a DB.
Generally, we try to find out records matching a certain criteria from a single or few tables. However, there are...
2013-03-07
1,997 reads
SQL Server : Understanding the IAM Page
In my earlier post, we have discussed about Data,GAM,SGAMand PFS pages. In this post, let us try to understand about...
2013-03-07
7,862 reads
Twitter Talk Theatre, Episode 1: “RAID is good enough!”
But We’ve Never Had a Disaster Before!
This week, some of my Twitter followers were kind enough to chime in on...
2013-03-07
702 reads
Benchmark SQL Server Disk Latency
Typically, I am a big advocate of performance monitor but one place I commonly see performance monitor being misused is with benchmarking...
2013-03-06 (first published: 2013-02-25)
4,467 reads
Business Intelligence Projects now supported in Visual Studio 2012
Since the release of Visual Studio 2012, business intelligence developers have been limited in how much they could use this...
2013-03-06
1,560 reads
Dropping Indexes
While working on some demos recently, I needed to drop an index for a test. I executed this generic statement...
2013-03-06
1,257 reads
Getting Started with Microsoft Data Explorer
What is Data Explorer
Data Explorer simplifies the data discovery phase for Excel users that are creating self-service Business Intelligence solutions. ...
2013-03-06
1,084 reads
Blogs
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...
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...
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