Posted inExecution Plan Health Check
[sp_HealthCheck] – Get SQL Server Health Details
Hi Friends, Ever wanted to check the heartbeat of SQL Server. It is a very…
![[sp_HealthCheck] – Get SQL Server Health Details](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2018/03/sp_HealthCheck.gif?fit=1024%2C500&ssl=1)
Posted inExecution Plan Health Check Performance Tuning TSQL
What’s Running – Find All Details of Running Queries
I often see DBAs/developer struggling to find what's wrong with query. The first step in…
Posted inInternals
Myth – Shrinking Log Files is OK
Many times I have seen that DBAs feel like its OK to Shrink Log files…
![[usp_AnalyzeSpaceCapacity] – SQL Server Space Management Made Easy](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2018/03/%40getVolumeSpaceConsumers_TableResult.jpeg?fit=1024%2C661&ssl=1)
Posted inTSQL
[usp_AnalyzeSpaceCapacity] – SQL Server Space Management Made Easy
DBAs! We all know the pain of creating new data or log files at new…
Posted inPerformance Tuning
First Responder Kit Power BI Dashboard
Recently Brent Ozar team added yet another great feature of Power BI Dashboard on data…
Posted inExecution Plan Performance Tuning
Procedures with RECOMPILE Option
Hi Friends, I often work on Performance Issues, and I found that developers use RECOMPILE…
Posted inDatabase Administration
How to Verify Given Access/Permissions to User/Login
Hi Friends, I have seen DBAs to wait for user's confirmation for long after providing…
Posted inErrors
Error/Fix: Database Mails using Gmail getting to Unsent Items
Recently I tried to setup Database Mail profile in SQL Server 2016 instance using 2-Step…
Posted inPerformance Tuning TSQL
Common Myth: Loop is Always Faster than Cursor
From past few weeks, I have been taking interview for Sr. SQL DBA position in…
Posted inPerformance Tuning Powershell TSQL
Deploy SQL-Server-First-Responder-Kit with Powershell
There are many tools in market that can help you troubleshoot in specific situations. My…