I like the new debugging capabilities of SQL Server 2008. It brings in features such as stepping in, stepping out, and stepping over. This can come handy when we are trying to track the actual issue. I found this feature interesting because it empowers developers to track issues at the most granular level. Now, we can step inside system functions, and stored procedures to figure out the values of internal variables and sets. See the video below for a quick guide on how to debug in SQL Server 2008 management studio.
Thursday, December 17, 2009
Wednesday, December 16, 2009
MS Wiki Site
I happened to run into a WIKIPEDIA like site called MSWIKI. They are not affiliated with MS in anyway. However, it is dedicated to be a site containing factual information on any microsoft products. Here is the link http://www.mswiki.com.
I kept clicking the random pages just like I do with WIKIPEDIA most of the time. It came to my notice that one of their entry was related to GMAT... Not sure why that was there.
My visit was not totally worthless. At least they had a link to Halo Wiki - http://halowiki.net. It may come in handy in future. :)
Powershell in SQL 2008 - playing with ArrayList
As most of us know already, that powershell is the new shell around SQL 2008 to automate database related routines. It reminds me of the manpages in unix itlabs at the UofM. Anyways, I'll start posting few entries related to it. The example below, shows you how to manipulate .NET collection classes.
PS SQLSERVER:\> $c = New-Object "System.Collections.ArrayList"
PS SQLSERVER:\> $c.Add("test")
0
PS SQLSERVER:\>
PS SQLSERVER:\> $c.Add("your")
1
PS SQLSERVER:\>
PS SQLSERVER:\> $c.Add("mind")
2
PS SQLSERVER:\>
PS SQLSERVER:\> $c
test
your
mind
PS SQLSERVER:\>
PS SQLSERVER:\> $c | Select-Object -first 2
test
your
PS SQLSERVER:\> $c | Select-Object -last 2
your
mind
PS SQLSERVER:\>
PS SQLSERVER:\> $c = New-Object "System.Collections.ArrayList"
PS SQLSERVER:\> $c.Add("test")
0
PS SQLSERVER:\>
PS SQLSERVER:\> $c.Add("your")
1
PS SQLSERVER:\>
PS SQLSERVER:\> $c.Add("mind")
2
PS SQLSERVER:\>
PS SQLSERVER:\> $c
test
your
mind
PS SQLSERVER:\>
PS SQLSERVER:\> $c | Select-Object -first 2
test
your
PS SQLSERVER:\> $c | Select-Object -last 2
your
mind
PS SQLSERVER:\>
Saturday, January 3, 2009
Sunday, November 30, 2008
Sunday, November 2, 2008
Subscribe to:
Posts (Atom)
Latest SQL
Posts
