Skip to content

Straight-Path-Solutions/PowerShell-automation

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
 
 
 
 
 
 

Repository files navigation

SQL Server DBA PowerShell Scripts

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.

📂 Scripts Included

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.


🛠 Usage

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-File

Review each script’s parameters and examples before running in production.

📜 License

This repository is licensed under the MIT License

About

PowerShell automation scripts

Resources

License

Stars

13 stars

Watchers

2 watching

Forks

Releases

No releases published

Packages

 
 
 

Contributors