Database File Growth Report Script
A T-SQL script to track and monitor the growth of your SQL Server Databases.
2025-09-12 (first published: 2025-09-04)
307 reads
A T-SQL script to track and monitor the growth of your SQL Server Databases.
2025-09-12 (first published: 2025-09-04)
307 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-09-10 (first published: 2025-06-27)
286 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-09-05 (first published: 2025-08-25)
421 reads
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)
743 reads
COALESCE smartly helps to concatenating the multiple rows value into one cell.
2025-09-01 (first published: 2025-08-25)
1,463 reads
Two PowerShell scripts to create backup folders and clean up old files.
2025-08-29 (first published: 2025-08-16)
206 reads
This script produces scripts for all the stored procedures in a database.
2025-06-18 (first published: 2025-06-13)
787 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
170 reads
This script will help to find orphan users on all databases and will remove them.
2025-05-20
251 reads
2025-05-06
536 reads
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers