147 Free PowerShell Scripts for SQL Server and Azure SQL Database

PowerShell Scripts for SQL Server – Free Download

  • 147 sample PowerShell scripts to manage SQL Server and Azure SQL Database
  • Scripts to initialize PowerShell modules
  • Scripts for Database Engine, and for Analysis, Integration and Reporting Services
  • Support for SQL Server 2016 and 2017, and Windows Server 2016
  • 15 New scripts for Azure SQL Database

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

  • 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

Azure SQL Database (NEW)

  • Initialize PowerShell module
  • Set scaling level, and set auditing and threat detection
  • Get database properties
  • Get alert definitions, and set and get alert rules
  • Get query results, and get query metric data
PSscripts

IDERA Community

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

Join the Discussion