AlwaysON health check alerts
The script gets the database health check whether synchronized or not from the primary or secondary. This code needs to scheduled through as a job to get alerts.
2025-10-20 (first published: 2025-10-13)
801 reads
Scripts
Bat and SQL script to generate DB user permissions for all Databases in SQL server
Get a list of all user permissions in a database
2025-10-15 (first published: 2025-10-13)
2,294 reads
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)
1,110 reads
Index Efficiency & Maintenance Advisor
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)
969 reads
Enables Change Data Capture (CDC) on all user databases
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)
855 reads
Free T-SQL Script: Database Schema Documentation Generator for Generative AI Services Integration
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)
1,489 reads
Fetch fields like email address from multiple records into single cell
COALESCE smartly helps to concatenating the multiple rows value into one cell.
2025-09-01 (first published: 2025-08-25)
1,719 reads
Cleanup backup file folder future 7 days
Two PowerShell scripts to create backup folders and clean up old files.
2025-08-29 (first published: 2025-08-16)
432 reads
Stored Procedure Generation Script
This script produces scripts for all the stored procedures in a database.
2025-06-18 (first published: 2025-06-13)
1,134 reads
T-SQL Table Valued Function to compare Semantic Versions
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
336 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers