We can use below query to check the port on which SQL Server is listening. DECLARE @InstanceName nvarchar(50) DECLARE @value...
- BY Editor
- February 9, 2023
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...