|
|
Set-SQL.ps1
This Script Let’s you Modify SQL databases through PowerShell. Read more about it here >>...
|
02-27-2009
|
240
|
0
|
|
|
Get-SQL.ps1
This Script lets you Query an SQL Database and get the information returned in a HashTable Array...
|
02-27-2009
|
269
|
0
|
|
Get Database Status in HTML, status are shows in differents...
GEt the status of databases for a named instance, colors are function of databases status ex: Normal...
|
02-06-2009
|
333
|
0
|
|
|
Execute MSSQL Query that returns a table
This script will execute a query based on the contents of an sql/txt file provided as the first...
|
11-08-2008
|
506
|
0
|
|
|
Get MSSQL Servers using SMO
Get the available SQL Server instances
|
11-08-2008
|
257
|
0
|
|
|
Stop-SQLServerService
Stop SQL Server service for default instance
|
10-06-2008
|
210
|
0
|
|
|
Start-SQLServerService
Start SQL Server service for default instance.
|
10-06-2008
|
202
|
0
|
|
|
List-MSSQL-PropertyInfo
List Properties of a SQL Server instance using WMI.
|
10-06-2008
|
229
|
0
|
|
|
List-MSSQL-FailedJobs
List failed SQL Server jobs using SMO.
|
10-06-2008
|
269
|
0
|
|
|
Get-MSSQL-Views-Csv
Connect to SQL Server and output selected views to CSV.
|
10-06-2008
|
189
|
0
|
|
|
Get-MSSQL-ServerAttrib-Html
Connect to SQL Server and output server attributes to HTML
|
10-06-2008
|
201
|
0
|
|
|
Get-MSSQL-ServerAttrib-Csv
Connect to SQL Server and output server attributes to CSV.
|
10-06-2008
|
204
|
0
|
|
|
Get-MSSQL-Port-UsingWMI
Retrieve SQL Server port configured for use using WMI.
|
10-06-2008
|
188
|
0
|
|
|
Get-MSSQL-Port-UsingDMO
Retrieve SQL Server port configured for use.
|
10-06-2008
|
160
|
0
|
|
|
Get-MSSQL-MaxMemory
Get max memory property from SQL Server
|
10-06-2008
|
194
|
0
|
|
|
Get-MSSQL-DB-UsingSMO
Show all SQL Server databases using SMO for a given server instance.
|
10-06-2008
|
190
|
0
|
|
|
Get-MSSQL-DB-UsingADO
Show all SQL Server databases for a given server instance.
|
10-06-2008
|
198
|
0
|
|
|
CreateTable-MSSQL-UsingSMO
Create a SQL Server table using SMO.
|
10-06-2008
|
195
|
0
|
|
|
Create-MSSQLJob-UsingSMO
Create a SQL Server job to call a PowerShell script
|
10-06-2008
|
197
|
0
|
|
|
CreateDB-MSSQL-UsingSMO
Create a SQL Server empty database.
|
10-06-2008
|
212
|
0
|