PowerShell Scripts for SQL

PowerShell Scripts for SQL icon
Download

Publisher description

Eighty-nine 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 (SQL Server 2014 and SQL Server 2016): Get overall utilization. Get size on disk. Get detailed utilization by table. Get checkpoint size. Query Plan (SQL Server 2016): Set Query Plan desired state. Set Query Plan data retention maximum size. Get Query Plan information. Get Query Store status.


Related Programs

PowerShell Plus screenshot

PowerShell Plus 5.0.1130.0

Learn with free PowerShell editor and tools.

37.12 MB
2017-02-24 18:05:19
Freeware
Website-Scripts screenshot

Website-Scripts 1

PHP, CGI, Perl, JavaScript, Java and ASP site

14.06 KB
2007-09-25 00:29:24
Freeware
Scripts Encryptor (ScrEnc) screenshot

Scripts Encryptor (ScrEnc) 3.0.3.6

Obfuscator for ASP/JavaScript/VBScript/C++/C

292.66 KB
2015-10-19 00:46:07
Shareware
You Can Author File Scripts For Users screenshot

You Can Author File Scripts For Users 2.10C

Automate copy, rename, delete and zip files

31.88 MB
2012-10-06 21:22:23
Freeware
AgataSoft Telnet Scripts Runner screenshot

AgataSoft Telnet Scripts Runner 1.5

Auto run telnet scripts at many devices.

601.77 KB
2013-08-10 13:44:16
Shareware