102 Free SQL Server PowerShell Scripts

PowerShell Scripts for SQL Server – Free Download

  • 102 sample PowerShell scripts to manage SQL Server objects
  • Scripts to initialize SQL Server’s PowerShell module
  • Scripts for Database Engine, and for Analysis, Integration and Reporting Services
  • Support for SQL Server 2016 and 2017, and Windows Server 2016
  • 13 New scripts: 4 for SQL Server 2017, 8 for security, and 1 for aliases
  • 7 Updated scripts to support SQL Server 2017

Database Engine

  • Start and stop services
  • Connect to an instance, and get connection information
  • Manage databases, and script out databases
  • Set adaptive query processing NEW
  • Manage policies and error logs
  • Manage firewall rules NEW, logins, assemblies NEW, backups, and agent jobs
  • Get extended event information

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 NEW

General Utilities

  • Get list of registered instances
  • Ping instances and get their status
  • Set aliases for instances NEW
  • 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
PSscripts

IDERA Community

Check out the latest blog posts for product tips & tricks from other users.

Join the Discussion