Blocking – Capturing and Monitoring
If a query is taking longer to run than normal, there’s a good chance it’s being blocked by something else....
2013-05-22
695 reads
Blog Posts
Connecting a service between Publishing and Consuming SharePoint 2010 farm
Hello Friends,
As discussed in my previous blog the new architecture of Service Application in 2010. Let’s today discuss about connecting...
2013-05-22
703 reads
Cumulative Update – 11 for SQL Server 2008 SP3 Is Now Available !
The 11th cumulative update release for SQL Server 2008 Service Pack 3 is now available. Cumulative Update 11 contains all...
2013-05-22
648 reads
Database index design and optimization: Some guidelines
Well-designed indexes are an important part of database optimization because they are the key factor in achieving optimal query performance and response...
2013-05-22
1,548 reads
Designing and Implementing Online Analytical Processing (OLAP) Architecture (Part 1)
The well-designed online analytical processing (OLAP) solution is fundamental to organizations analysis capabilities. That is why, when designing the OLAP...
2013-05-22
890 reads
Do you check to see if an SSIS package has been modified?
Andy Leonard (blog | twitter) and I are putting together a presentation on protecting the entire ETL (Extract, Transform, Load) pipeline, specifically...
2013-05-22
2,722 reads
Holy Schnikes I’m Speaking at PASS Summit 2013
I am beyond excited to announce that I have been accepted to speak at the annual SQL PASS Summit 2013...
2013-05-22
1,186 reads
I’m Not Presenting at PASS Summit 2013
Last week I got the news that none of the four sessions I submitted for this year were accepted. Disappointing...
2013-05-22
682 reads
I'm thinking of hosting a series of webinars on SQL Server security
With the PASS Summit sessions announced, I took a quick look to see how many were what I'd consider security-centric....
2013-05-22
2,831 reads
Index Analysis May Update
Seems I managed to make it through all of April without an update to the index analysis stored procedure. It...
2013-05-22
586 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