PowerShell Scripts for SQL Server and Azure SQL Database

Manage SQL Server and Azure SQL Database with 147 sample PowerShell scripts

• 147 sample PowerShell scripts to manage SQL Server and Azure SQL Database
• Scripts to initialize PowerShell modules
• Scripts for Database Engine, and for Analysis, Integration and Reporting Services
• Support for SQL Server 2016 and 2017, and Windows Server 2016
• 15 New scripts for Azure SQL Database

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

• 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

Azure SQL Database (NEW)

• Initialize PowerShell module
• Set scaling level, and set auditing and threat detection
• Get database properties
• Get alert definitions, and set and get alert rules
• Get query results, and get query metric data

* Run scripts on SQL Server on-premises and in the cloud.