Stored Procedure Generation Script
This script produces scripts for all the stored procedures in a database.
2025-06-18 (first published: 2025-06-13)
643 reads
Scripts
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
125 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
156 reads
2025-05-06
356 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
379 reads
fetch an execution plan from SQL Server's buffer cache
To fetch an execution plan from SQL Server's buffer cache (i.e., the in-memory cache of execution plans), you can query the dynamic management views (DMVs) that SQL Server exposes.
2025-04-30
90 reads
List the Databases To Which You Have Access
Explanation: sys.databases contains information about all databases on the SQL Server instance. • HAS_DBACCESS(name) = 1 filters out the databases you dont have access to. •ORDER BY name sorts the result alphabetically.
2025-03-04
245 reads
Database mdf & ldf files size, used space, Free space in MB
This script will help to get the Database mdf & ldf files size, used space, Free space in MB.
2025-02-27 (first published: 2025-02-25)
213 reads
T-SQL Script for Monitoring Database Size in SQL Server
This T-SQL script helps you monitor the size and status of all databases on your SQL Server instance, providing insights into space usage and performance.
2025-01-29 (first published: 2025-01-20)
757 reads
Table Index Size
This procedure gets current table and index sizes of particular database and stores it to tables.
2025-01-07
248 reads
Blogs
Accessing the Kubernetes API from SQL Server 2025
The sp_invoke_external_rest_endpoint stored procedure that’s available in 2025 allows for SQL Server to hit...
Empowering Technical Teams: Leading with Vision, Not Micromanagement
By Chris Yates
Let’s be honest; technical teams don’t thrive under a microscope. They thrive under a...
Azure DMS Tutorial: Migrate Databases to Azure with Minimal Downtime
By Rohit Garg
Migrating databases to the cloud can be complex, but Azure Database Migration Service (DMS) simplifies the...
Forums
How to safely and surgically restore filegroups
Comments posted to this topic are about the item How to safely and surgically...
Get Your Chores Done
Comments posted to this topic are about the item Get Your Chores Done
Trouble Sending Email from Scheduled Job
I'm a little rusty with SQL, been away a while. I have SQL Mail...
Question of the Day
Capacity Planning for an Existing SQL Server Workload?
You're tasked with planning capacity for a new SQL Server database workload. Which of the following is the most accurate way to determine how much CPU, memory, and I/O throughput your workload requires? What single or multiple tools would you use to answer the questions around resource needs?
See possible answers