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

$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-692358d3cfec1704396809/] Resolution:- In order to solve this issue permanently, I…

Ajay Dwivedi August 1, 2020

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

TSQL

Script-SQLDatabaseRestore cmdlet in SQLDBATools Module

Restoring multiple databases can be painful especially when each of them have multiple database file(s). Four years back, I wrote TSQL script that would accept database backup path, and result…

Ajay Dwivedi April 14, 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