SQLServer Archives - Performance Tuning And Infra Automation

SQL Server Lab 01 – MultiSubnet Availability Group with FCI

As a SQL Server DBA, it is very important to learn concepts by doing or implementing. Following this rule, I often create a SQL Server Lab setup for myself and…

Ajay Dwivedi July 4, 2021

Baseline-SQL-Server TSQL

Get Time Duration in [DD hh:mm:ss] format

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. For example,…

Ajay Dwivedi August 29, 2020

TSQL

Some useful Scripts

As a DBA/Developer, there have been many occasions where I had to write my own scripts/automation to fulfill specific business requirements. Below are some of those useful scripts that I…

Ajay Dwivedi September 8, 2019