Emil’s Blog

Programming Windows, .Net, EPiServer and whatnot…

[Powered by WordPress.]

January 26, 2010

by Emil Åström @ 9:45. Filed under SQL Server

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

[Comments (0)] [link]

January 21, 2010

by Emil Åström @ 14:32. Filed under PowerShell

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

[Comments (0)] [link]

jour·nal n. A personal record of occurrences, experiences, and reflections kept on a regular basis; a diary.

January 26, 2010