Category: TSQL

How to Write Prod Grade Code

Dynamic SQL To Collect Remote SQL Server Health

Troubleshoot CPU Issue on SQL Server using SQLMonitor

Resolve high cpu issues on SQL Server using Open Source tools

Troubleshoot SQL Server Memory Related Performance Issues using Free Tools

Losing single_user database connection is painful, and this script helps to regain the database access by getting database back to multi_user mode.

Troubleshoot SQL Server Health using Live Health Check Query or SQLMonitor

I often see various SQL Server DBA & professionals struggling with tempdb. As a DBA it is very common to see issues where some user processes cause tempdb

Recently I have been working on setting up baselining for my SQL Server lab environment. As part of baselining, I capture all the required Perfmon counters both at

As DBA, there are various scenarios where I display duration in results. More often, for visual effects, I like to convert the same duration into [DD hh:mm:ss] format.