Display the SELECT statement for any table
Found this lovely T-SQL script to display the SELECT statement for any table.
2013-08-22 (first published: 2013-08-06)
3,242 reads
Scripts
Show database size info across an instance
This script shows size information of every database on the instance.
2013-08-21 (first published: 2010-07-26)
5,957 reads
Generate Create View statements for database tables.
Create views based on table definitions for backwards compatibility when relocating tables to a new database.
2013-08-16 (first published: 2013-07-30)
1,119 reads
Execute T-SQL Scripts in Parallel
Transact-SQL does not have a simple method to launch multiple parallel running scripts. This tool will change the game. It requires SQL Server 2005 or above.
2013-08-13 (first published: 2009-08-28)
17,530 reads
usp_tableReference
Use this script to find the Stored Procedures which are referencing the table passed as argument from all databases on the server.
2013-08-12 (first published: 2013-08-02)
1,136 reads
Dynamically Drop a User From Your SQL Instance
Dynamically drop a user from each database on an SQL instance by their server login SID, then remove there server login as well. Plus some helpful printable information when ran.
2013-08-09 (first published: 2013-07-16)
915 reads
Simplest way to search any string in db objects
Easiest way to search for a string in any object within the database.
2013-08-08 (first published: 2013-07-29)
2,315 reads
Display the number of days since last Database backup.
A simple T-SQL script to display the number of days since the last database backup.
2013-08-07 (first published: 2013-07-29)
1,663 reads
2013-07-31 (first published: 2008-07-15)
1,618 reads
2013-07-30 (first published: 2013-06-12)
1,532 reads
Blogs
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...
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where...
EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00...
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