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.
IDERA Community
Check out the latest blog posts for product tips & tricks from other users.

PowerShell Scripts for SQL Server and Azure SQL Database
