Ajay Dwivedi's SQL Server Blog

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

How to Run a SQL Query on Multiple SQL Servers using PowerShell - Serial Manner 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...

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

Troubleshooting High Stolen CPU Scenario On SQLServer - Ajay Dwivedi's SQL Server Blog Troubleshooting SQLServer Stolen CPU using SQLMonitor

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

Troubleshooting SQL Server Storage IO - Ajay Dwivedi's SQL Server Blog How to troubleshooting SQL Server Storage IO Issues using open source tool

Live Troubleshooting High CPU on SQL Server - Part 1 - Ajay Dwivedi's SQL Server Blog Resolve high cpu issues on SQL Server using Open Source tools

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

Resume Writing & Interviewing Tips - Ajay Dwivedi's SQL Server Blog What are the tips and tricks of resume writing and interviewing.