A collection of PowerShell scripts to assist SQL Server DBAs with automation, configuration, and day-to-day management tasks. These scripts are designed to save time, reduce human error, and streamline SQL Server administration.
Automates the installation and initial configuration of SQL Server, including setup of service accounts, features, maintenance, community tools, and other important settings.
π Script Folder
π Blog Post
Performs a comprehensive health check of SQL Server instances, covering configuration, performance, security, and best practices. A great way to quickly assess the state of your SQL Servers.
- π Script Folder
- π Blog Post
Unblock downloaded scripts (Windows typically blocks files from the internet) before running. You can unblock all scripts in a folder with this command:
Get-ChildItem -Path "C:\path\to\scripts" -Recurse -Filter *.ps1 | Unblock-FileReview each scriptβs parameters and examples before running in production.
This repository is licensed under the MIT License