132 Free SQL Server PowerShell Scripts

PowerShell Scripts for SQL Server – Free Download

  • 132 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
  • 30 New scripts for Center for Internet Security (CIS) benchmarks

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 NEW

  • 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
PSscripts

IDERA Community

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

Join the Discussion