Idera – Free Tool – PowerShell Scripts for SQL Server

30Sep 2017 by richard@baronsoftware.com

Idera – Free Tool – PowerShell Scripts for SQL Server

Idera

Idera is offering a free tool of Powershell scripts for Microsoft SQL server.  You can simply your SQL Server Administration with 89 free Powershell scripts by simply providing some information and it is an amazing assortment of scripts.  The scripts will allow you to work on your server providing you with some outstanding quick pieces that will enhance what you do on a daily basis.

  • 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

Powershell script break down

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