PowerShell Scripts for SQL

PowerShell Scripts for SQL 2

Simplify SQL Server administration with 20 free scripts

Simplify SQL Server administration with 20 free scripts

A handy collection of PowerShell scripts for SQL Server, AD, Exchange and SharePoint that can be used directly in PowerShell or using PowerShell Plus. In the powerful PowerShell Scripts collection you will find 20+ Handy PowerShell SQL Server Scripts, 30+ Handy PowerShell Active Directory Scripts, 20+ Handy PowerShell Exchange Scripts, 15+ Handy PowerShell SharePoint Scripts.

Create and Connect

- Create a SQL Server database

- Create a job, job step and schedule it

- Create a SQL Server table

- Connect to SQL Server with IP address and SQL Authentication

- Connect to SQL Server with IP address and Windows Authentication

Perform Daily Tasks

- Get last backup

- Get a list of failed jobs

- Run a DBCC CheckDB

- Script out a database or table

- Create job to recycle error logs

Get Information and Settings

- Get available SQL Servers

- Get/Set default data or log file locations

- Get server version and attributes

- Get database file sizes

- Get query results using a T-SQL script in a file

Work with Services:

- Start or stop Services

- Get Analysis Services catalogs and databases

- Restore an Analysis Services database

- Get Integration Services package information

- Get a list of running Integration Services packages

PowerShell Scripts for SQL

Download

PowerShell Scripts for SQL 2