2008-09-30 (first published: 2008-07-24)
888 reads
Scripts
Getting schemas for your tables
A short script you can incorporate into any 2005/2008 code to get the full schema.table.
2008-09-29
665 reads
Script to return Rows count from table using sp_ExecuteSQL
Script to return Rows count from table using sp_ExecuteSQL
2008-09-26 (first published: 2008-07-20)
1,544 reads
Using Triggers for Detective Work
When a value is changed that causes an error, finding what caused the error can be tricky. Here an application was truncating a column. The trigger helped to identify the culprit.
2008-09-25 (first published: 2008-07-17)
1,403 reads
Checking fragmented indexes
A quick script to check for fragmentation in a database and generate a list of defrag statments you can run.
2008-09-24
2,479 reads
2008-09-19 (first published: 2008-07-20)
1,495 reads
2008-09-18 (first published: 2008-07-15)
709 reads
2008-09-16
338 reads
Create string from table
This simple script retrieves a range of values from a table and presents the results as a string.
2008-09-15 (first published: 2008-07-16)
1,626 reads
Get DBMail information
get the profile name and the account name etc about the dbmails created on the server
2008-09-12 (first published: 2008-07-13)
1,003 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