PowerShell Scripts for SQL Server – Free Download

• 132 sample PowerShell scripts to manage SQL Server objects
• Scripts to initialize SQL Server’s PowerShell module
• Scripts for Database Engine, and for Analysis, Integration and Reporting Services
• Support for SQL Server 2016 and 2017, and Windows Server 2016
• 30 New scripts for Center for Internet Security (CIS) benchmarks

Database Engine

• Start and stop services
• Connect to an instance, and get connection information
• Manage databases, and script out databases
• Set adaptive query processing
• Manage policies and error logs
• Manage firewall rules, logins, assemblies, backups, and agent jobs
• Get extended event information

Center for Internet Security (CIS) Benchmarks NEW

• Surface area reduction
• Authentication and authorization
• Password policies
• Auditing and logging
• Application development
• Start and stop SQL Server browser service

In-memory Databases

• Get overall memory utilization
• Get size on disk
• Get detailed utilization by table
• Get checkpoint size

Query Store

• Enable and disable Query Store
• Get information about query plans in Query Store
• Get activity status
• Set maximum data retention size
• Set automatic tuning of queries via Query Store

General Utilities

• Get list of registered instances
• Ping instances and get their status
• Set aliases for instances
• Get advanced properties by service
• Add service account to local security privilege
• Get and set power plans

Analysis Services

• Connect to an instance, and get connection information
• Get a list of databases
• Backup databases, manage backup retention, and restore databases

Integration Services

• Start and stop services
• Connect to an instance, and get connection information
• Manage packages and catalogs
• Publish projects

Reporting Services

• Start and stop services
• Connect to an instance, and get connection information
• Backup and restore encryption keys
• Get configuration information
• Get event log information