Certifiable?
I have recently begun to contemplate pursuing the MCSA Certification. I have been working with SQL Server for almost 20...
2013-05-17
629 reads
Blog Posts
PowerSQL – Find Size, Name, LastAccess and Last Modified time of all bak files across ALL Servers
We came across a scenario where database bak files being created from long time which are no more in use...
2013-05-17 (first published: 2013-05-13)
2,446 reads
Software Design and Schizophrenic Windows 8 Part 2
I know it’s not schizophrenic, but that sounds better. It’s really a split personality.
I wrote recently about Windows 8 and...
2013-05-17
1,166 reads
SQLSaturday #220 Atlanta
From the tweets, it looks like there will be about 800 attendees sitting in on 11 different tracks with 5...
2013-05-17
514 reads
Windows, RIP (1992 – 2013)
Today is a very sad day for me. My love, my dear Windows has passed away. We were together for...
2013-05-17
1,085 reads
Bill Gate’s speech
One of my friend shared this content. I’m just sharing with you all.Good one and I like it pretty much!!!!Bill...
2013-05-16
613 reads
DMV-11 : T-Log space used by transaction……..sys.dm_tran_database_transactions
sys.dm_tran_database_transactions DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms186957.aspx
Returns information about transactions at the database level.
Some time , T-log...
2013-05-16
2,010 reads
Dragging a name from the object explorer to a query window
In the same vein as Steve Jones’ series on Customizing SSMS this is a fairly basic trick, but one that...
2013-05-16 (first published: 2013-05-13)
3,854 reads
From Google Reader to Feedly
I shifted to Reader about a year ago mainly for the ability to access my feeds on multiple devices. I’ll...
2013-05-16
636 reads
Indexes – Unused and Duplicates
Indexes aren’t free, and many databases end up with unused indexes. Every time you make any update to a table...
2013-05-16
1,730 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