Deepam Ghosh
I am proficient in SQL Server High Availability & Disaster Recovery (HADR) solutions, including Always On Availability Groups, SQL Server Failover Cluster Instances (FCI), Log Shipping and Cross-Platform Database Migration.
I love automating repetitive DBA tasks by writing T-SQL and PowerShell scripts.
In my free time, I enjoy watching F1 or Cricket, reading books and exploring nature.
Regular Expressions in SQL Server 2025
This article examines the new regular expression functions added to T-SQL in SQL Server 2025.
2025-10-31
15,331 reads
Database Ledger in SQL Server 2022
Learn how ledger databases and ledger tables work in SQL Server 2022.
2025-10-20
15,259 reads
Parameter Sensitive Plan Optimization in SQL Server 2022
Learn about a new feature of SQL Server 2022 - Parameter Sensitive Plan Optimization(PSPO)
2025-09-15
1,664 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)
480 reads
Contained Availability Groups in SQL Server 2022
SQL Server 2022 introduced a new feature called Contained Availability Groups. It allows the Database Administrators to effectively manage the Server Level objects, such as Logins, SQL Agent jobs, etc. in an HA environment. In today's article, we will learn about this new feature of SQL Server. The Challenge of Managing Server Objects in Availability […]
2025-08-20
8,513 reads
2025-07-18
5,833 reads
Automating SQL Server Inventory Collection with SQLInventory
Learn about a free inventory tool to help you keep track of basic information on your servers.
2025-07-04
4,817 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)
877 reads
SQL Automate - A DBA's Time-Saving Toolkit
SQLAutomate is a lightweight PowerShell tool that simplifies SQL Server deployment by automating both installation and post-installation configuration. Whether you're setting up one instance or dozens, this guide shows how to use SQLAutomate to save time and reduce manual work.
2025-06-06
9,914 reads
Blogs
SQL Training Black Friday Deals
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
Dry-run xp_delete_file Before Actually Deleting Files?
BySQLPals
Dry-run xp_delete_file Before Actually Deleting Files?xp_delete_file doesn’t really have a...
Happy Thanksgiving! (USA Holiday)
In the United States, today is Thanksgiving. The intent behind the holiday is to...
Forums
FinOps - the new name for performance tuning
Comments posted to this topic are about the item FinOps - the new name...
Which Object Definitions Are Available?
Comments posted to this topic are about the item Which Object Definitions Are Available?
What's Your Theme Music?
Comments posted to this topic are about the item What's Your Theme Music?
Question of the Day
Which Object Definitions Are Available?
For which of these object types can I get the code when I run the OBJECT_DEFINITION() function in SQL Server 2025? (choose 3)
See possible answers[8]ページ先頭