Skip to content

Performance Tuning And Infra Automation

I love performance tuning and building automation

  • Home
  • About Me
  • SQL Resources
  • Privacy Policy
  • Contact Me
  • Home
  • About Me
  • SQL Resources
  • Privacy Policy
  • Contact Me
  • facebook.com
  • twitter.com
  • t.me
  • instagram.com
  • youtube.com
Subscribe
StackOverflow2013 database on PostgreSQL
Posted inDatabase Administration PostgreSQL

Get StackOverflow2013 Database for PostgreSQL & SQLServer

Posted by 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.
Read More
Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer
Posted inErrors TSQL

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

Posted by By Ajay Dwivedi June 28, 2025
Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer
Read More
LogRotate Policy For PostgreSQL
Posted inLinux PostgreSQL

LogRotate Policy For PostgreSQL

Posted by By Ajay Dwivedi April 25, 2025
Learn how to create a log rotation policy for postgresql logs based on size
Read More
Build CI/CD Github Action Pipeline for Ansible Playbook
Posted inAnsible DevOps

Run Ansible Playbooks with Github Action

Posted by By Ajay Dwivedi March 21, 2025
Build CI/CD Github Action Pipeline for running Ansible Playbook
Read More
Server getting slow over time until restart
Posted inBaseline-SQL-Server Performance Tuning SQLMonitor

SQLServer Gradually Becomes Slow Until Reboot

Posted by By Ajay Dwivedi November 14, 2024
How to resolve issue where SQLServer gets slow over time until reboot
Read More
SQLServer Alerts on Slack
Posted inBaseline-SQL-Server SQLMonitor

Setup SQLServer Alerts with Open Source SQLMonitor

Posted by By Ajay Dwivedi November 6, 2024
Setup SQLServer monitoring and alerting using open source tool SQLMonitor. Send slack alert notifications.
Read More
How to execute a sql query on multiple servers using PowerShell
Posted inPowershell

Run SQL Query on Multiple Servers Using PowerShell – Serially

Posted by 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.
Read More
How to Use Credential Manager for Storing and Retrieving Passwords
Posted inPowershell SQLMonitor TSQL

How To Handle Passwords in PowerShell Automation

Posted by By Ajay Dwivedi December 17, 2023
This blog describes how to handle passwords when writing PowerShell automation using Credential Manager
Read More
SQLMonitor - Open source tool to monitor SQLServers
Posted inBaseline-SQL-Server Performance Tuning SQLMonitor

Baseline SQLServer with SQLMonitor v1.6.0

Posted by By Ajay Dwivedi December 10, 2023
How to baseline & Monitor SQLServers using open source monitoring tool SQLMonitor.
Read More
Self Hosted Website Access from Internet
Posted inSQLMonitor

How to Access Home Lab Using Internet

Posted by By Ajay Dwivedi September 8, 2023
How to access self hosted website from Internet.
Read More

Posts pagination

1 2 3 … 10 Next page
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

See what other community members think about SQLMonitor.
Recent Posts
  • Get StackOverflow2013 Database for PostgreSQL & SQLServer
  • Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer
  • LogRotate Policy For PostgreSQL
  • Run Ansible Playbooks with Github Action
  • SQLServer Gradually Becomes Slow Until Reboot
Facebook With Ajay Dwivedi
Facebook With Ajay Dwivedi

CATEGORIES

  • Ansible 1
  • Baseline-SQL-Server 22
  • Database Administration 11
  • DevOps 1
  • Errors 15
  • Execution Plan 8
  • Growth & Development 2
  • Health Check 8
  • Internals 3
  • Linux 4
  • Performance Tuning 35
  • PostgreSQL 3
  • Powershell 8
  • SQL Alerts 5
  • SQLMonitor 17
  • TSQL 41
Post You Might Like
StackOverflow2013 database on PostgreSQL
Posted inDatabase Administration PostgreSQL
Get StackOverflow2013 Database for PostgreSQL & SQLServer
Posted by By Ajay Dwivedi June 30, 2025
Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer
Posted inErrors TSQL
Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer
Posted by By Ajay Dwivedi June 28, 2025
Posted inLinux PostgreSQL
LogRotate Policy For PostgreSQL
Posted by By Ajay Dwivedi April 25, 2025
Build CI/CD Github Action Pipeline for Ansible Playbook
Posted inAnsible DevOps
Run Ansible Playbooks with Github Action
Posted by By Ajay Dwivedi March 21, 2025
Copyright 2025 — Performance Tuning And Infra Automation. All rights reserved. Bloglo WordPress Theme
Scroll to Top