Measuring Transactional Replication Latency Without Tracer Tokens
Measuring Transactional Replication Latency Without Tracer Tokens SQL Server 2005 introduced Tracer Tokens (SQL 2005 | SQL 2008), a new methodology for...
2010-03-25
7,122 reads
Recovery Models and Backup Strategies for SQL Server 2008
I had a question via e-mail from one of my new students at University of Denver, University College this morning,...
2010-03-25
3,068 reads
Simple Series : SSIS Conditional Split
Conditional Split is a very powerful component, enabling you to send records in different directions or exclude them from the downstream...
2010-03-25
1,127 reads
SQL Server 2008 Activity Monitor
For those people who like to use the Activity Monitor in the SQL Server Management Studio GUI instead of, or...
2010-03-25
2,873 reads
What Sessions Do You Want for the PASS 2010 Summit?
Survey was announced in the Connector on Wednesday, reposting the link here. We need your thoughts on this!
http://www.zoomerang.com/Survey/WEB22ADZ7NCK9A
2010-03-25
672 reads
A Fan and a Friend
I went to the UK SQL Server User Group in Cambridge on Wednesday. I’m not sure it’s the Cambridge group...
2010-03-25
688 reads
Have a Question? Use the Forums
I try to keep a pretty tight lid on the comments to the blog because there's a lot of SPAM...
2010-03-25
535 reads
Managing the Size of the Security Cache (TokenAndPermUserStore) in SQL 2005
Introduction
In an earlier post I walked through the diagnosis of a problem with TokenAndPermUserStore bloat in SQL 2005.In this post...
2010-03-25
1,096 reads
Goodbye Live Spaces, Hello WordPress
After blogging on Live Spaces for a 517 days, I’ve made the difficult decision to move to my own domain...
2010-03-25
659 reads
Meeting Offsite and a Little Vacation
I’m heading to our “publishing summit” today at one of the Cambridge University buildings. I’m a part of the group...
2010-03-24
784 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