|
|
Set-SQL.ps1
This Script Let’s you Modify SQL databases through PowerShell. Read more about it here >>...
|
02-27-2009
|
310
|
0
|
|
|
Get-SQL.ps1
This Script lets you Query an SQL Database and get the information returned in a HashTable Array...
|
02-27-2009
|
347
|
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
|
469
|
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
|
675
|
0
|
|
|
Get MSSQL Servers using SMO
Get the available SQL Server instances
|
11-08-2008
|
330
|
0
|
|
|
Stop-SQLServerService
Stop SQL Server service for default instance
|
10-06-2008
|
276
|
0
|
|
|
Start-SQLServerService
Start SQL Server service for default instance.
|
10-06-2008
|
274
|
0
|
|
|
List-MSSQL-PropertyInfo
List Properties of a SQL Server instance using WMI.
|
10-06-2008
|
301
|
0
|
|
|
List-MSSQL-FailedJobs
List failed SQL Server jobs using SMO.
|
10-06-2008
|
369
|
0
|
|
|
Get-MSSQL-Views-Csv
Connect to SQL Server and output selected views to CSV.
|
10-06-2008
|
256
|
0
|
|
|
Get-MSSQL-ServerAttrib-Html
Connect to SQL Server and output server attributes to HTML
|
10-06-2008
|
262
|
0
|
|
|
Get-MSSQL-ServerAttrib-Csv
Connect to SQL Server and output server attributes to CSV.
|
10-06-2008
|
246
|
0
|
|
|
Get-MSSQL-Port-UsingWMI
Retrieve SQL Server port configured for use using WMI.
|
10-06-2008
|
263
|
0
|
|
|
Get-MSSQL-Port-UsingDMO
Retrieve SQL Server port configured for use.
|
10-06-2008
|
214
|
0
|
|
|
Get-MSSQL-MaxMemory
Get max memory property from SQL Server
|
10-06-2008
|
247
|
0
|
|
|
Get-MSSQL-DB-UsingSMO
Show all SQL Server databases using SMO for a given server instance.
|
10-06-2008
|
256
|
0
|
|
|
Get-MSSQL-DB-UsingADO
Show all SQL Server databases for a given server instance.
|
10-06-2008
|
272
|
0
|
|
|
CreateTable-MSSQL-UsingSMO
Create a SQL Server table using SMO.
|
10-06-2008
|
256
|
0
|
|
|
Create-MSSQLJob-UsingSMO
Create a SQL Server job to call a PowerShell script
|
10-06-2008
|
275
|
0
|
|
|
CreateDB-MSSQL-UsingSMO
Create a SQL Server empty database.
|
10-06-2008
|
261
|
0
|