Scripts Archives - DBA Mantra

By using this site, you agree to the Privacy Policy and Terms of Use.

Navigating the complexities of SQL Server auditing can be daunting. Whether you’re ensuring compliance, securing data, or simply looking to...

We can use below query to check the port on which SQL Server is listening. DECLARE @InstanceName nvarchar(50) DECLARE @value...

Many a times Application team report SQL Server Blocking issues. In this article I will explain about Blocking and Its...

As a DBA, many times there are requirements to segregate data in a Database into multiple file groups. There can...

It’s a general requirement in the DBA job to scripts out the database objects and deployment the scripts in the...

Archives