Archive

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…

/Emil

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)
{
  'salesforceservice'
  {
    $deploy_service = $true
  }

  'web'
  {
    $deploy_web = $true
  }

  default
  {
    "Bad parameter: " + $_
    ShowHelp
    exit
  }
}

Pretty neat, huh?

/Emil

Categories: PowerShell Tags:

Switch to our mobile site

Web Analytics