SQL Server

Export Filestream documents to folder

Johan Bijnens - ALZDBA — Mon, 12 Sep 2011 17:46:49 GMT

ALZDBA 20110912

This script will export filestream column Document to the desired target location
and name the file using the data content of column FileName

Send SQL to databases and get back results

Tobias — Wed, 02 Mar 2011 09:34:42 GMT

Invoke-SQL sends an SQL statement to any database and gets back the results to you as PowerShell objects. You need to submit a valid connectionstring to select and access the database. Check out New-ConnectionString elsewhere in this repository to create such a database connection string automatically.

Create Database Connection String with Wizard

Tobias — Wed, 02 Mar 2011 09:11:55 GMT

New-ConnectionString creates automatically a connection string that you then can use to access the database you picked. The function invokes the system wizard which will guide you through accessing a database, configuring parameters such as logon credentials, and testing the data source. Once the wizard dialog appears, choose the option to use a connection string, and press the button to create one. Now you can select the driver type, choose the database and configure parameters. Once you finish the wizard, New-ConnectionString returns the connection string you just created. NOTE THAT MANY DATABASE DRIVERS CURRENTLY EXIST ONLY IN 32BIT VERSIONS so on 64bit machines, you may want to run this function in a 32bit PowerShell console.

Stop-Jobs

rbhatia — Wed, 22 Sep 2010 15:20:25 GMT

Stop all actively running SQL jobs

Set-SQL.ps1

Niklas Goude — Fri, 27 Feb 2009 15:49:20 GMT

This Script Let’s you Modify SQL databases through PowerShell.

Read more about it here >>

goude@powershell.nu

www.powershell.nu

Get-SQL.ps1

Niklas Goude — Fri, 27 Feb 2009 15:47:52 GMT

This Script lets you Query an SQL Database and get the information returned in a HashTable Array.

Read more about it here >>

goude@powershell.nu

www.powersehll.nu

Get Database Status in HTML, status are shows in differents colors

ESL — Fri, 06 Feb 2009 11:32:19 GMT

GEt the status of databases for a named instance, colors are function of databases status ex:

Normal = Blue

Offline = Grey

Using SMO Library, script based from an idera script [ CreateDB-MSSQL-UsingSMO]

Execute MSSQL Query that returns a table

George — Sat, 08 Nov 2008 19:41:16 GMT

This script will execute a query based on the contents of an sql/txt file provided as the first parameter. If the file is not found, the parameter is treated as a sql query. Optional parameters are available for specifying the server/database/username/password.

The result is expected to be in a table format and will be returned as a formatted-table.

Get MSSQL Servers using SMO

George — Sat, 08 Nov 2008 15:34:16 GMT

Get the available SQL Server instances

Stop-SQLServerService

Richard Giles — Mon, 06 Oct 2008 14:46:47 GMT

Stop SQL Server service for default instance

Start-SQLServerService

Richard Giles — Mon, 06 Oct 2008 14:45:51 GMT

Start SQL Server service for default instance.

List-MSSQL-PropertyInfo

Richard Giles — Mon, 06 Oct 2008 14:41:59 GMT

List Properties of a SQL Server instance using WMI.

List-MSSQL-FailedJobs

Richard Giles — Mon, 06 Oct 2008 14:40:36 GMT

List failed SQL Server jobs using SMO.

Get-MSSQL-Views-Csv

Richard Giles — Mon, 06 Oct 2008 14:38:33 GMT

Connect to SQL Server and output selected views to CSV.

Get-MSSQL-ServerAttrib-Html

Richard Giles — Mon, 06 Oct 2008 14:33:38 GMT

Connect to SQL Server and output server attributes to HTML