SQLDBATools Archives - Performance Tuning And Infra Automation

$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-6aa3df4b7c45e135566304/] 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

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

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