|
Sql Server Security Audit
Sorry about using Quest's Active Directory library, but I am not a guru and figured there is...
|
03-02-2012
|
102
|
0
|
|
|
Find All Domain Servers that have MS SQL Server Instances
Get a listing of all servers in a domain, test the connection then check the registry for MS SQL...
|
02-09-2012
|
205
|
0
|
|
|
Export Filestream documents to folder
ALZDBA 20110912 This script will export filestream column Document to the desired target location...
|
09-12-2011
|
222
|
0
|
|
|
Send SQL to databases and get back results
Invoke-SQL sends an SQL statement to any database and gets back the results to you as PowerShell...
|
03-02-2011
|
480
|
0
|
|
|
Create Database Connection String with Wizard
New-ConnectionString creates automatically a connection string that you then can use to access the...
|
03-02-2011
|
357
|
0
|
|
|
Stop-Jobs
Stop all actively running SQL jobs
|
09-22-2010
|
257
|
0
|
|
|
Set-SQL.ps1
This Script Let’s you Modify SQL databases through PowerShell. Read more about it here >>...
|
02-27-2009
|
415
|
0
|
|
|
Get-SQL.ps1
This Script lets you Query an SQL Database and get the information returned in a HashTable Array...
|
02-27-2009
|
490
|
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
|
784
|
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
|
1,329
|
0
|
|
|
Get MSSQL Servers using SMO
Get the available SQL Server instances
|
11-08-2008
|
513
|
0
|
|
|
Stop-SQLServerService
Stop SQL Server service for default instance
|
10-06-2008
|
495
|
0
|
|
|
Start-SQLServerService
Start SQL Server service for default instance.
|
10-06-2008
|
453
|
0
|
|
|
List-MSSQL-PropertyInfo
List Properties of a SQL Server instance using WMI.
|
10-06-2008
|
563
|
0
|
|
|
List-MSSQL-FailedJobs
List failed SQL Server jobs using SMO.
|
10-06-2008
|
625
|
0
|
|
|
Get-MSSQL-Views-Csv
Connect to SQL Server and output selected views to CSV.
|
10-06-2008
|
481
|
0
|
|
|
Get-MSSQL-ServerAttrib-Html
Connect to SQL Server and output server attributes to HTML
|
10-06-2008
|
515
|
0
|
|
|
Get-MSSQL-ServerAttrib-Csv
Connect to SQL Server and output server attributes to CSV.
|
10-06-2008
|
496
|
0
|
|
|
Get-MSSQL-Port-UsingWMI
Retrieve SQL Server port configured for use using WMI.
|
10-06-2008
|
535
|
0
|
|
|
Get-MSSQL-Port-UsingDMO
Retrieve SQL Server port configured for use.
|
10-06-2008
|
404
|
0
|