PowerShell Scripts for SQL Server – Free Download

• 89 example scripts for managing SQL Server objects
• Initialize PowerShell SQLPS module and work with databases
• Scripts for Analysis, Integration, and Reporting services
• Experimental support for SQL Server 2016
• New scripts for exploring In-Memory databases and query store features

Database Engine

• Connect to a server instance, manage databases and publish scripts
• Work with policies and SQL Server logs
• Manage security and backups
• Create and manage SQL Server jobs
• Get extended event information

Analysis Services

• Connect to an Analysis Services instance
• Get connection information
• Get a list of databases
• Backup databases and remove old backups
• Restore a database

Integration Services

• Start and stop services
• Get package information
• Provision a catalog
• Publish a project
• Modify catalog settings

Reporting Services

• Start or stop services
• Get instance information
• Backup and restore encryption keys
• Get configuration information
• Get event log information

***NEW Scripts***
In-Memory Databases (SQL2014 and SQL2016)

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

Query Plan (SQL2016)

• Set Query Plan desired state
• Set Query Plan data retention maximum size
• Get Query Plan information
• Get Query Store status