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

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.

Ajay Dwivedi December 23, 2023

How to Use Credential Manager for Storing and Retrieving Passwords

Powershell SQLMonitor TSQL

How To Handle Passwords in PowerShell Automation

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

Ajay Dwivedi December 17, 2023

Powershell TSQL

Best Practices for Production Grade Code

How to Write Prod Grade Code

Ajay Dwivedi November 8, 2022

$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’

Yesterday I was trying to install dbatools powershell module in one virtual machine that I created for online SQL Class. [crayon-6934653a9e197302703328/] Resolution:- In order to solve this issue permanently, I…

Ajay Dwivedi August 1, 2020

ScriptOut-LinkedServers-With-Actual-Password

Powershell

ScriptOut Linked Server with Actual Password

Within my organization, we work in a controlled environment. That means, with each SQL Instance migration, we have strict rules to script out everything including System database user objects, operators,…

Ajay Dwivedi October 25, 2019

Powershell

Copy SQL and Batch Files from Source to Destination using PowerShell

Recently as part of Server Migration, I had to move nested folders and files from Source server to Destination. This task becomes hard when directory has child folders and files…

Ajay Dwivedi May 2, 2018

Powershell

Get-ProcessForDBA cmdlet in SQLDBATools Module

Troubleshooting high memory utilization on servers involves finding out processes which are consuming RAM. But default methods like Task Manager, or Get-Process cmdlet of PowerShell are difficult to read and…

Ajay Dwivedi April 22, 2018

Performance Tuning Powershell TSQL

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

There are many tools in market that can help you troubleshoot in specific situations. My personal favorite for finding out issue with SQL Server is SQL-Server-First-Responder-Kit created by Brent Ozar…

Ajay Dwivedi July 19, 2017