Ajay Dwivedi's SQL Server Blog
Share
Stay connect to update yoru knowledge on SQL Server with me. The blog covers everything about SQL Server and other technical stuffs.
This is page for all blog post written by Ajay on http://ajaydwivedi.com for knowledge sharing.
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
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...
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/
How To Handle Passwords in PowerShell Automation - Ajay Dwivedi's SQL Server Blog 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/
Baseline SQLServer with SQLMonitor v1.6.0 - Ajay Dwivedi's SQL Server Blog 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 Find If SQLServer Needs More Memory? - Ajay Dwivedi's SQL Server Blog 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 High Stolen CPU Scenario On SQLServer - Ajay Dwivedi's SQL Server Blog 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/
How to Monitor All SQLServers LIVE - Ajay Dwivedi's SQL Server Blog Troubleshooting SQL Server Issues Using Wait Stats of SQLMonitor
12/11/2022
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
03/10/2022
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
30/09/2022
Troubleshooting SQL Server with High Memory Grants - Ajay Dwivedi's SQL Server Blog Troubleshoot SQL Server Memory Related Performance Issues using Free Tools
10/12/2021
Intelligent Blocking Alert with Auto Clearning & Delay features
Setup Blocking Alert on SQL Server - Ajay Dwivedi's SQL Server Blog 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....
Resume Writing & Interviewing Tips - Ajay Dwivedi's SQL Server Blog What are the tips and tricks of resume writing and interviewing.
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....
Please Wait... | Cloudflare 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.
Click here to claim your Sponsored Listing.
Contact the business
Telephone
Website
Address
Noida