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,303 reads
Scripts
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)
142 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-08-29 (first published: 2025-06-27)
5 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-08-25
10 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-08-25
22 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)
733 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
154 reads
Script-Drop Orphan users from SQL Server Database
This script will help to find orphan users on all databases and will remove them.
2025-05-20
193 reads
2025-05-06
457 reads
SQL Server Heath Check Script
This script runs a SQL server Health check for services, databases, Always On, replication, CDC job status.
2025-05-05
448 reads
Blogs
The Book of Redgate: Meetings
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
New article: Automating SQL Server Builds
By Brian Kelley
I refresh my test SQL Servers at least monthly with a fresh VM. Setting...
Leading with Accountability: How Extreme Ownership Transforms Leadership
By Chris Yates
Embracing Total Responsibility In every organization there comes a moment when teams must choose...
Forums
Change Tracking Default Retention
Comments posted to this topic are about the item Change Tracking Default Retention
ssrs subscription file share
I am trying to create a subscription that posts to a one drive directory. ...
What is Delayed Durability in SQL Server — And Should You Turn It On?
Comments posted to this topic are about the item What is Delayed Durability in...
Question of the Day
Change Tracking Default Retention
I run this command on my SQL Server 2022 database:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;What is the default data retention period? See possible answers