SQL Server 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

Errors TSQL

Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer

Ajay Dwivedi June 28, 2025

Server getting slow over time until restart

Baseline-SQL-Server Performance Tuning SQLMonitor

SQLServer Gradually Becomes Slow Until Reboot

How to resolve issue where SQLServer gets slow over time until reboot

Ajay Dwivedi November 14, 2024

Baseline-SQL-Server SQLMonitor

Setup SQLServer Alerts with Open Source SQLMonitor

Setup SQLServer monitoring and alerting using open source tool SQLMonitor. Send slack alert notifications.

Ajay Dwivedi November 6, 2024

Powershell

Run SQL Query on Multiple Servers Using PowerShell – Serially

In this blog, we explore how to execute a sql server on multiple SQL Servers using PowerShell in serial manner. Then we save the result in Excel and SQL Table. As source servers list, we consider plan text file along with excel & sql query result.

Ajay Dwivedi December 23, 2023