SQL Server Archives - Performance Tuning And Infra Automation

StackOverflow2013 database on PostgreSQL

Get StackOverflow2013 Database for PostgreSQL & SQLServer

By Ajay Dwivedi June 30, 2025

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

Errors TSQL

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

By Ajay Dwivedi June 28, 2025

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

Server getting slow over time until restart

Baseline-SQL-Server Performance Tuning SQLMonitor

SQLServer Gradually Becomes Slow Until Reboot

By Ajay Dwivedi November 14, 2024

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

Baseline-SQL-Server SQLMonitor

Setup SQLServer Alerts with Open Source SQLMonitor

By Ajay Dwivedi November 6, 2024

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

Powershell

Run SQL Query on Multiple Servers Using PowerShell – Serially

By Ajay Dwivedi December 23, 2023

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.