PowerShell scripts

Free PowerShell Scripts for SQL Server DBAs

What are PowerShell scripts?

Over 20 cool PowerShell scripts to help you manage and administer your SQL Servers using Windows PowerShell. Try them directly in PowerShell or using Idera's PowerShellPlus, a powerful interactive console, script editor, debugger and comprehensive PowerShell learning center.

20+ Handy PowerShell Scripts

Backup-SSAS	Backup Analysis Services databases
CheckDB-MSSQL-UsingADO	Run a DBCC CheckDB with an estimate only on a database
Connect-MSSQL-IPSQLAuth	Connect to SQL Server with IP address and SQL Authentication
Connect-MSSQL-IPWindowsAuth	Connect to SQL Server with IP address and Windows Authentication
CreateDB-MSSQL-UsingSMO	Create a SQL Server database
Create-MSSQLJob-UsingSMO	Create a job, job step and schedule it
CreateTable-MSSQL-UsingSMO	Create a SQL Server table
Get-MSSQL-DB-UsingADO	Run an ADO query to output all databases
Get-MSSQL-DB-UsingSMO	Enumerate SQL Server database objects using SMO
Get-MSSQL-MaxMemory	Retrieve max memory setting
Get-MSSQL-Port-UsingDMO	Get SQL Server port configured using DMO
Get-MSSQL-Port-UsingWMI	Get SQL Server port configured using WMI
Get-MSSQL-ServerAttrib-Csv	Enumerate SQL Server attributes using SMO
Get-MSSQL-ServerAttrib-Html	Enumerate SQL Server attributes using SMO
Get-MSSQL-ServerRegistrations	Exports current groups and servers
Get-MSSQL-Views-Csv	List views for a given SQL Server database
Insert-MSSQL-SampleData-Csv	Insert data from a CSV file into a SQL Server table
List-MSSQL-FailedJobs	Retrieve failed jobs from SQL Server
List-MSSQL-PropertyInfo	Display server instance properties using WMI
LoadSMO	load SMO assemblies
Start-SQLServerService	Start and stop a SQL Service
Stop-SQLServerService	Stop SQL Server service