Posts tagged with "powershell"

How to Deploy a SQL Server Availability Group for High Availability

A walkthrough for building a two-node SQL Server 2025 Availability Group with automatic failover, from standing up the AD forest to proving failover works.

sql-serverpowershell

How To Split a SQL Server Backup File

Learn three ways to split a large SQL Server backup file for migration: native backup striping, PowerShell, and 7-Zip.

sql-serverpowershell

How to Timeout an External Process in PowerShell

How to use WaitForExit(Int32) to give an external process a time limit in PowerShell, and what to do when it runs out.

Automating sp_WhoIsActive Installation

Install sp_WhoIsActive across your SQL Server instances with a single dbatools command instead of running the script by hand.

sql-serverpowershell

Installing dbatools

A quick reference for installing the dbatools PowerShell module, covering the PowerShell Gallery install and offline options.

sql-serverpowershell

Optimizing SQL Server Backup Transfers with Robocopy

Split a large .bak file, benchmark Robocopy multithreading in PowerShell, run parallel copies, and reassemble the backup on the far end.

powershellsql-server

Using PowerShell to Automate Glenn Berry's SQL DMV Queries

A dbatools and ImportExcel script that runs Glenn Berry's diagnostic DMV queries and compiles the results into one Excel workbook.

powershellsql-server