Business Intelligence Requirements Gathering
There are three fundamental steps in building a data warehouse for a BI solution (see Why you need Business Intelligence):
Identify...
2013-05-28
4,898 reads
Blog Posts
Internet Security Advice For The Family
Constant Vigilance!For today’s post I’m channeling my inner Brian Kelley (Blog | Twitter) and talking about security, in particular Internet security....
2013-05-28
997 reads
Investigating Plan Cache Bloat
SQL Server includes a DMV, sys.dm_exec_query_stats, that returns performance statistics for each query plan cached in memory. However, it can...
2013-05-28
1,139 reads
New Immersion Event Classes at SQLskills
There are three new upcoming Immersion Event classes from SQLskills, including one that I will be teaching, which is the...
2013-05-28
845 reads
Security Questions: Authentication Performance
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-05-28
757 reads
Security Questions: Differences between “Grant” and “With Grant?”
As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-05-28 (first published: 2013-05-23)
2,210 reads
SMO vs Invoke-Sqlcmd in Azure
I’m working on a series of Powershell scripts for the pre-conference seminars on Windows Azure SQL Database that I’m going to be...
2013-05-28
1,072 reads
SQL Server – Filtering objects in Object Explorer – Management Studio
When you are working on a database with a large number of objects sometimes it becomes a challenge to locate...
2013-05-28
1,026 reads
SQLPerformance.com
I have had the opportunity to go through the first three SQLSkills Immersion Events, and one of the side benefits...
2013-05-28
613 reads
Using CROSS APPLY to calculate an aggregate across a single row.
I’ve had CROSS APPLY on the mind recently. You could probably tell since its been the subject of my last...
2013-05-28
1,480 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
Managing Incidents and Fighting Fires
Comments posted to this topic are about the item Managing Incidents and Fighting Fires
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
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