Posts tagged with "powershell"

Optimizing SQL Server Backup Transfers with Robocopy

Faced with unreliable VPN throughput, the author splits a large .bak file into parts, benchmarks Robocopy’s multithreading (/MT) settings in PowerShell, then runs parallel copy sessions and explains how to reassemble the chunks into a single backup file.

Using PowerShell to Automate Glenn Berry's SQL DMV Queries

Leveraging the dbatools PowerShell module and ImportExcel, this post introduces a script that connects to a SQL Server instance, runs Glenn Berry’s diagnostic DMV queries, exports results to CSV, and compiles them into a single Excel workbook for streamlined performance analysis.