Script SQL Table Schema as XML-XSD
When creating XML messages for Service Broker or other applications use this simple method to build a validation XSD.
2009-10-28 (first published: 2009-10-06)
1,567 reads
Scripts
The Ultimate Connection Summarizer and Trouble Finder
Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group.
2009-10-22 (first published: 2008-09-18)
6,105 reads
2009-10-21 (first published: 2009-10-01)
2,329 reads
The Ultimate Table Searcher Mk2
Searches for tables who's names contain the search string. Gives Aggregate Size, Rows, Index, and Column information as well.
2009-10-20 (first published: 2008-11-04)
942 reads
The Ultimate Column Searcher
Searches for columns with names containing @Colname that belong to tables with names containing @TableName or schemas with names containing @SchemaName. Gives size and rowcount for tables.
2009-10-16 (first published: 2008-08-01)
1,537 reads
The Ultimate Index-Less Foreign-Key Finder
Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.
2009-10-15 (first published: 2009-10-01)
1,958 reads
The Ultimate Table Searcher
Searches for tables who's names contain the search string. Gives Size and Rows information as well.
2009-10-14 (first published: 2008-08-01)
2,302 reads
The Ultimate Foreign Key Researcher
Searches for actual and potential foreign key columns for a given primary key reference.
2009-10-12 (first published: 2008-06-20)
2,553 reads
2009-10-09 (first published: 2009-09-29)
2,109 reads
The Ultimate Precompiled Procedure Searcher
Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.
2009-10-08 (first published: 2008-06-20)
1,924 reads
Blogs
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Forums
Alamat BCA KCP Thamrin Nine Telp:0821°7555°651
Telp/Wa 628217555651 Thamrin Nine Podium Area - UG Unit A, Jl. MH Thamrin No.10,...
Alamat BCA KCP Samanhudi Telp:08218200203
Telp/Wa 628218200203 Jl. Samanhudi No.57 B, RT.5/RW.3, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta...
Alamat BCA KCP AM Sangaji Telp:08218200233
Telp/Wa 628218200233 Jl. A.M Sangaji No.020 A, RT.3/RW.04, Petojo Utara, Kecamatan Gambir, Kota Jakarta...
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers