Database Administration Archives - Performance Tuning And Infra Automation

StackOverflow2013 database on PostgreSQL

Get StackOverflow2013 Database for PostgreSQL & SQLServer

Download StackOverflow2013 database for PostgreSQL & SQLServer to compare performance. We can figure out which if faster between PostgreSQL & SQLServer.

Ajay Dwivedi June 30, 2025

Database Administration

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

Database Administration

Indexing Maintenance Solution for Replication

Like any other DBA, I fell into the trap of using straight maintenance solution using Reorganize operation for Indexes with avg fragmentation with 30% or less with Index Rebuild for…

Ajay Dwivedi July 10, 2018

Database Administration

OlaHallengren Maintenance Solution – DatabaseBackup – Configurable Backup Directory folder names

If you are a DBA then you understand the importance of having robust Database Maintenance Solution. Like everybody in SQL Server Community, Ola Hallengren's Maintenance Solution is my favorite. Two…

Ajay Dwivedi April 24, 2018

Database Administration

Setup Custom Log Shipping in SQL Server

When it comes to Disaster Recovery Setup, every DBA has its own preference. I personally prefer Log Shipping since it involves very little effort to setup. Log shipping has many…

Ajay Dwivedi April 7, 2018

Database 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 access/permissions. This is not required since we have very easy way to verify user permissions.…

Ajay Dwivedi November 8, 2017

Database Administration

New SQL DBA Coaching Batch Starting from Nov 2017

Hi Friends, I am starting new batch for SQL Server DBA Classroom training from first week of November. I take only 5 students for this in-person training classes. So, those…

Ajay Dwivedi September 12, 2017

Database Administration

Setup fresh/Scriptout Existing Mirroring on SQL Server

In my current organization, we have lot of servers where database mirroring is used as a disaster recovery option. Either we are setting up mirroring from scratch or dropping the…

Ajay Dwivedi January 25, 2017

Database Administration

A Curious Case of Orphan User

Hi Friends, Today at work I received an access request to provide multiple database permissions to multiple AD groups on servers. After providing appropriate db roles membership to requested AD…

Ajay Dwivedi November 30, 2016

Database Administration Errors

Error/Fix: The Extended Events session named “blocked_process” could not be found.

Two days back while I am presenting in a KT session within team on how to use Extended Events for trapping blocking and deadlocks, and use the SQL Sentry Plan…

Ajay Dwivedi November 24, 2016