Powershell Archives - Performance Tuning And Infra Automation

How to execute a sql query on multiple servers using 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.

How to Use Credential Manager for Storing and Retrieving Passwords

Powershell SQLMonitor TSQL

How To Handle Passwords in PowerShell Automation

By Ajay Dwivedi December 17, 2023

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

Powershell TSQL

Best Practices for Production Grade Code

By Ajay Dwivedi November 8, 2022

How to Write Prod Grade Code

$PackageManagement\Install-PackageProvider : No match was found for the specified search criteria for the provider 'NuGet'$

Powershell

Error/Fix: PackageManagement\Install-PackageProvider : No match was found for the specified search criteria for the provider ‘NuGet’

By Ajay Dwivedi August 1, 2020

Yesterday I was trying to install dbatools powershell module in one virtual machine that I…

ScriptOut-LinkedServers-With-Actual-Password

Powershell

ScriptOut Linked Server with Actual Password

By Ajay Dwivedi October 25, 2019

Within my organization, we work in a controlled environment. That means, with each SQL Instance…

Powershell

Copy SQL and Batch Files from Source to Destination using PowerShell

By Ajay Dwivedi May 2, 2018

Recently as part of Server Migration, I had to move nested folders and files from…

Powershell

Get-ProcessForDBA cmdlet in SQLDBATools Module

By Ajay Dwivedi April 22, 2018

Troubleshooting high memory utilization on servers involves finding out processes which are consuming RAM. But…

Performance Tuning Powershell TSQL

Deploy SQL-Server-First-Responder-Kit with Powershell

By Ajay Dwivedi July 19, 2017

There are many tools in market that can help you troubleshoot in specific situations. My…