89 Free SQL Server PowerShell Scripts
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