Find Largest size Tables in a Database
To find a list of Tables (User or System tables)according to their size.
2013-01-02 (first published: 2008-07-10)
4,308 reads
Scripts
Generate Drop / Create Script for views, stored Procedures
This Script generates drop and create scripts for views or stored procedures.
2013-01-01 (first published: 2007-10-19)
6,367 reads
The Ultimate Index Usage Reporter
Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.
2012-12-27 (first published: 2008-08-01)
7,973 reads
Show Table, Index and Image/Text size.
This is a simple script that show size from a table and yours related objects.
2012-12-24 (first published: 2007-09-27)
2,724 reads
Query all objects created or modified after specified date
This script will query across all databases, returning a result of objects recently created or modified.
2012-12-21 (first published: 2012-11-27)
2,062 reads
2012-12-20 (first published: 2012-12-04)
1,720 reads
Update Trigger to Store Only Updated Column and Former Value
History table needs individual rows for each column that has been updated, i.e., a column history.
2012-12-17 (first published: 2012-12-04)
1,169 reads
2012-12-14 (first published: 2012-11-27)
1,921 reads
Report Server Report Usage
Get information about how often, how fast your reports run and how big they are.
2012-12-12 (first published: 2012-11-27)
1,641 reads
Find Single use plans in Plan Cache
This script will return all the Adhoc Single use Plans currently in your Plan Cache.
It also excludes Plan Shells created from auto/forced parameterization. Works for 2005/2008
2012-12-11 (first published: 2012-11-26)
828 reads
Blogs
Adding an HTTP MCP Server to VSCode
By Steve Jones
I wrote earlier this week about the SQL MCP Server using the Data API...
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Forums
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Building Your Own Software
Comments posted to this topic are about the item Building Your Own Software
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers