What are PowerShell scripts?
Our PowerShell scripts will help you manage and administer SQL Server, Active Directory and Exchange 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 SQL Server 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
Load-MSSQL-SMO:
Load SMO assemblies
Start-SQLServerService:
Start and stop a SQL Service
Stop-SQLServerService:
Stop SQL Server service
