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