More SQL Azure Samples
I have been playing around some more with SQL Azure in order to get ready for an upcoming presentation, so...
2010-03-05
2,279 reads
Index your FK
A few months ago I read an article from SQLServerCentral.com about some Foreign Key gotchas. Since that article, I have seen...
2010-03-05
871 reads
Time Off, Down Time, Round Up
I have taken some time off this week, I have been to the beach with my two golden retriever puppies....
2010-03-04
692 reads
Speaking at SQLSaturday #33 in Charlotte
I'll be presenting two sessions this Saturday (March 6, 2010) in Charlotte - Automate SQL Server Administration with PowerShell and Gather...
2010-03-04
573 reads
Schedule for SQLSaturday #33
Final schedule for the Charlotte event and it is impressive – 9 tracks, 54 sessions!
2010-03-04
513 reads
Focus on Your Passion
Tuesday night I was having a conversation with my younger son, whom we call Turtle. It's a nickname that came...
2010-03-04
1,084 reads
Output = MAXDOP 1
It is widely know that data modifications on table variables do not support parallelism, Peter Larsson has a good example...
2010-03-04
560 reads
Timing Matters
A few weeks ago I got an email from my backup administrator with a message like this:
Set type : Backup
Set...
2010-03-04
311 reads
Self Promotion & Self Marketing
The title of this post illustrates my own ambiguity on the topic. It’s fair and necessary to let others know...
2010-03-04
627 reads
Heading to Charlotte
I think I’ll forever associate Charlotte, NC with my middle son. We were heading back to Denver from Virginia Beach...
2010-03-04
378 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