PowerShell - Restart Services

A PowerShell script which restarts any service running on a server.

usp_TransposeNRows v2.0

Transpose N rows of a table (v2.0 allows user to specify the table's schema)

Simple Crosstab Procedure with Power

Create crosstab queries as easily as MS Access with a lot more power.

Virtual tally table function

An inline table-valued function (iTVF) that will produce a virtual tally table on-the-fly. The function creates a tally table of any size with user-defined lower and upper bounds.

Calculate gregorian easter sunday using a table valued function

Calculate gregorian easter sunday using a table valued function.

PowerShell script to check last backup date for Databases

PowerShell script to check last full backup, transaction log backup date for SQL Server databases.

Generate All Table Script By Using SMO C#

Generate Script All Table and Specific Table By Using SMO C#

Database size trending with powershell

a script to import all database sizes from a list of servers into a table using powershell for trending purposes

YOU MUST DOWNLOAD CODEPLEX SQL SERVER MODULE FOR THIS TO WORK.

Powershell - Export Stored Proc results to CSV file

This Powershell script calls a stored procedure and exports the results to a CSV file

PowerShell to SlipStream SQL 2008

PowerShell script to SlipStream SQL Server 2008 installer with SPx patch.