This script automatically generates comprehensive schema documentation that can be easily consumed by AI services for natural language querying, automated report generation, and intelligent data analysis.
2025-09-03 (first published: 2025-08-25)
558 reads
COALESCE smartly helps to concatenating the multiple rows value into one cell.
2025-09-01 (first published: 2025-08-25)
1,422 reads
Two PowerShell scripts to create backup folders and clean up old files.
2025-08-29 (first published: 2025-08-16)
164 reads
This script will help DBAs to find inefficient indexes and duplicate indexes, by providing the following metrics: usage statistics, fragmentation levels, size, and index duplication analysis.
2025-08-29 (first published: 2025-06-27)
12 reads
This script loops through all user databases, skips system DBs and any you want to exclude, and enables CDC if it’s not already enabled.
2025-08-25
11 reads
This script produces scripts for all the stored procedures in a database.
2025-06-18 (first published: 2025-06-13)
740 reads
Semantic versioning (SemVer) is a standardized system for labeling software releases using a three-part number—major, minor, and patch—optionally followed by pre-release labels and build metadata. Comparing semantic versions is complex because it requires handling both numeric and string components, as well as special precedence rules for pre-releases and stable versions. SQL Server’s hierarchyid data type is ideally suited for comparing the numeric parts of semantic versions, enabling efficient and accurate ordering without the pitfalls of string comparison or manual parsing.
2025-05-27
154 reads
This script will help to find orphan users on all databases and will remove them.
2025-05-20
199 reads
2025-05-06
465 reads
This script runs a SQL server Health check for services, databases, Always On, replication, CDC job status.
2025-05-05
455 reads
By John
Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...
By Steve Jones
As I use containers more and more to run various things, I decided I...
By Kevin3NF
Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve...
I maintain an application written years ago, where the database is on a Windows...
I’m working on a jewelry e-commerce project and need advice on designing an efficient...
Comments posted to this topic are about the item The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers