Ajay Dwivedi's SQL Server Blog

23/12/2023

In this blog/video, how to write a script to execute a query to multiple servers.

blog -> https://ajaydwivedi.com/powershell/run-sql-query-on-multiple-servers-using-powershell-serially/
video -> https://youtu.be/9p0Ep6K0mfk?feature=shared

In this video, we explore how to execute a sql query on multiple SQLServers serially.In part 2 video, we talk about how to run the same query on multiple ser...

17/12/2023

Don't write "Passwords" in your automation scripts. Rather use this easy approach.

https://ajaydwivedi.com/powershell/how-to-handle-passwords-in-powershell-automation/

This blog describes how to handle passwords when writing PowerShell automation using Credential Manager

10/12/2023

https://ajaydwivedi.com/baseline-sql-server/baseline-sqlserver-with-sqlmonitor-v1-6-0/

How to baseline & Monitor SQLServers using open source monitoring tool SQLMonitor.

26/12/2022

How to Decide if SQL Server needs more Memory?

How to decide if SQL Server needs more RAM or RAM upgrade?

14/12/2022

How can you find out non-SQLServer processes consuming CPU?

Troubleshooting SQLServer Stolen CPU using SQLMonitor

08/12/2022

Check out How to Monitor All your SQLServers Easily.
https://ajaydwivedi.com/performance-tuning/how-to-monitor-all-sqlservers-live/

Troubleshooting SQL Server Issues Using Wait Stats of SQLMonitor

12/11/2022

https://ajaydwivedi.com/performance-tuning/troubleshooting-sql-server-storage-io/?swcfpc=1

How to troubleshooting SQL Server Storage IO Issues using open source tool

03/10/2022

Resolve high cpu issues on SQL Server using Open Source tools

30/09/2022

Troubleshoot SQL Server Memory Related Performance Issues using Free Tools

10/12/2021

Intelligent Blocking Alert with Auto Clearning & Delay features

Setup/Configure Blocking Mail Notification Alet for SQL Server on-prem & cloud including Azure, AWS, etc.

03/12/2021

What are the tips and tricks of resume writing and interviewing....

What are the tips and tricks of resume writing and interviewing.

04/07/2021

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 destroy the same once done. In this blog/video series, I talk about how to create a SQL Server Lab environment that includes SqlCluster & Availability groups in multi-subnet architecture that would mirror environments within organizations....

If you are on a personal connection, like at home, you can run an anti-virus scan on your device to make sure it is not infected with malware.