|
Export Filestream documents to folder
ALZDBA 20110912 This script will export filestream column Document to the desired target location...
|
09-12-2011
|
186
|
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
|
398
|
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
|
307
|
0
|
|
|
Stop-Jobs
Stop all actively running SQL jobs
|
09-22-2010
|
223
|
0
|
|
|
Set-SQL.ps1
This Script Let’s you Modify SQL databases through PowerShell. Read more about it here >>...
|
02-27-2009
|
405
|
0
|
|
|
Get-SQL.ps1
This Script lets you Query an SQL Database and get the information returned in a HashTable Array...
|
02-27-2009
|
464
|
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
|
752
|
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,238
|
0
|
|
|
Get MSSQL Servers using SMO
Get the available SQL Server instances
|
11-08-2008
|
490
|
0
|
|
|
Stop-SQLServerService
Stop SQL Server service for default instance
|
10-06-2008
|
470
|
0
|
|
|
Start-SQLServerService
Start SQL Server service for default instance.
|
10-06-2008
|
428
|
0
|
|
|
List-MSSQL-PropertyInfo
List Properties of a SQL Server instance using WMI.
|
10-06-2008
|
539
|
0
|
|
|
List-MSSQL-FailedJobs
List failed SQL Server jobs using SMO.
|
10-06-2008
|
593
|
0
|
|
|
Get-MSSQL-Views-Csv
Connect to SQL Server and output selected views to CSV.
|
10-06-2008
|
454
|
0
|
|
|
Get-MSSQL-ServerAttrib-Html
Connect to SQL Server and output server attributes to HTML
|
10-06-2008
|
483
|
0
|
|
|
Get-MSSQL-ServerAttrib-Csv
Connect to SQL Server and output server attributes to CSV.
|
10-06-2008
|
471
|
0
|
|
|
Get-MSSQL-Port-UsingWMI
Retrieve SQL Server port configured for use using WMI.
|
10-06-2008
|
501
|
0
|
|
|
Get-MSSQL-Port-UsingDMO
Retrieve SQL Server port configured for use.
|
10-06-2008
|
380
|
0
|
|
|
Get-MSSQL-MaxMemory
Get max memory property from SQL Server
|
10-06-2008
|
466
|
0
|
|
|
Get-MSSQL-DB-UsingSMO
Show all SQL Server databases using SMO for a given server instance.
|
10-06-2008
|
440
|
0
|