• Home
  • Popular Downloads
  • Contact Us
  • Submit

Softpile

Free Downloads

Main Navigation
  • Home
  • Windows
  • Mac OS X
  • Business
  • Desktop
  • Development
  • Education
  • Games
  • Internet
  • Multimedia
  • Utilities
Home » Windows » Business » Applications » PowerShell Scripts for SQL Server

PowerShell Scripts for SQL Server

July 12, 2018
147 example scripts for managing SQL Server objects. Initialize PowerShell modules and work with databases. Scripts for Analysis, Integration, and Reporting services. Support for SQL Server 2016 & 2017, Azure SQL Database, and Windows Server 2016.
PowerShell Scripts for SQL Server
PowerShell Scripts for SQL Server Screenshot
Version: 6.0
License: Free
Operating System: Windows
Homepage: www.idera.com
Developed by: IDERA, Inc.
147 free SQL Server PowerShell scripts: 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. Maintain 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.

In-Memory Databases: Get overall utilization. Get size on disk. Get detailed utilization by table. Get checkpoint size.

Query Plan: Set Query Plan desired state. Set Query Plan data retention maximum size. Get Query Plan information. Get Query Store status.

Center for Internet Security (CIS) benchmarks: Surface area reduction, authentication and authorization, password policies, auditing and logging, application development, and start and stop SQL Server browser service.

Azure SQL Database: 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.
What's New

Version 6.0: This is a major product update

database administration database management microsoft azure sql database microsoft powershell microsoft sql server powershell scripts sql server
Free Download 257K
0
  • Share on:

Sponsored

Categories

  • Applications
  • Business
  • Windows

Related Downloads

SQL Integrity Check
Find potentially sensitive data. Search an entire instance or a particular ...
SQL Fragmentation Analyzer
An easy to view graphical representation of fragmentation levels across your ...
SQL Check
Monitor 20 key performance metrics. See throughput of varying types. See ...
SQL Backup Status Reporter
Quickly identify databases that have not had backups. View backup history ...
PowerShell Plus
Learn PowerShell quickly from the interactive learning center. Execute ...
Copyright © 1999-2017 Softpile Free Downloads
  • Contact Us
  • Submit
  • Privacy Policy
  • Disclaimer
  • Terms of Use