Archive for January, 2010

Templates for SQL Server Management Studio

January 26th, 2010 No comments

Templates for SQL Server Management Studio 2008 are stored in this folder on WIndows XP:

C:\Documents and Settings\[user]\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates\Sql

On my new WIndows 7 machine, the location is:

C:\Users\[user]\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates\Sql

Create sub-folders and SQL files there and they show up in the Template Explorer. Really useful…


Categories: SQL Server Tags:

Script parameter parsing in PowerShell

January 21st, 2010 No comments

This is an example of how to do script parameter parsing in PowerShell:

switch ($args)
    $deploy_service = $true

    $deploy_web = $true

    "Bad parameter: " + $_

Pretty neat, huh?


Categories: PowerShell Tags:
Web Analytics