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)
330 reads
Scripts
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,041 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
255 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
495 reads
2025-05-06
900 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
1,113 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
244 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
363 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)
379 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)
951 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
BCA KCU BANDUNGTelepon 083179431638
WhatsApp:083179431638Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
BCA KCU PURI INDAH No.Telpon 087781685647
Whatsapp 087781685647 Jl. Puri Indah Raya No.1-3 Blok 02, RT.3/RW.2, Kembangan Sel., Kec. Kembangan,...
BCA KCU SCBD No. telp:087757645171
Whatsapp:087757645171 Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl. Jenderal...
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers