Deepam Ghosh

I am currently working as a DBA Lead at VGL Group, Jaipur, India. I have 6+ years of experience in MSSQL Database Administration.
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.

All authors

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 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2025-08-20

8,453 reads

SQLServerCentral Article

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(5)

You rated this post out of 5. Change rating

2025-06-06

9,892 reads

All authors

Blogs

App-Consistent MongoDB Snapshots Across Multiple Pure Storage FlashArrays

By

Introduction When you’re running MongoDB at scale with data distributed across multiple Pure Storage...

PASS: Quantum Computing Slides

By

If you're an attendee at the PASS Data Community Summit this year, there are...

A New Word: Dead Reckoning

By

dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would...

Read the latest Blogs

Forums

Looking for help with SQL statement

By DalF1960

Hi there I am seeking some help with an SQL statement. Any help would...

Personal Contact Is Vital

By Grant Fritchey

Comments posted to this topic are about the item Personal Contact Is Vital

Getting the Schema for Tables

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the Schema for Tables

Visit the forum

Question of the Day

Getting the Schema for Tables

What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database? 

SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; 
GO

See possible answers