Month: May 2009

The SQL Server Blocked Process Monitor makes monitoring, tracking and troubleshooting SQL Server 2008 and 2005 blocked processes easy. You will no longer have to manually enable and run a trace to capture the blocked process report. In addition, the application will parse the Report XML and use the sqlhandle information contained in the report to capture the actual sqltext from the sys.dmexecsql_text DMV as the blocking occurs. There are 2 versions of the application, one targeted at SQL Server 2008, and one at SQL Server 2005. You can download from CodePlex here.

Nothing earth shatteringly new; just for my reference:

— Get a comma separated list of a table’s column names
SELECT STUFF(
(SELECT
‘,’ + COLUMN_NAME AS [text()]
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME = ‘TableName‘
Order By Ordinal_position
FOR XML PATH(”)
), 1,1, ”)

The lineup for May’s DevJam community event of the Perth .NET User Group (Thursday, 7th May), is as follows:

Tiang Cheng: Developing Software as a Service with the Google API
Graeme Foster: ‘Dude, where’s my memory?’: Finding managed memory leaks using Windbg
Andy Dent: WPF layer-cake: C#, C++/CLI and C
Dave Gardner: NDepend
Rhys Campbell: Introduction to ASP.Net MVC
Adrian McGrath: Measuring .NET Application Performance – Application Instrumentation
Jeremy Thake: ‘What’s this ReSharper all about then?’
Hadley Willan: Partial classes with LINQ-SQL

DATE: Thursday, May 7th, 5:30pm
VENUE: Excom, Ground Floor, 23 Barrack Street, Perth
COST: Free. All welcome

There are prizes for the presenters of the highest, audience voted talks (with the organisers’ decision as final in case of a tie break):

First Prize: Visual Studio 2008 Pro with MSDN Premium, worth approx. $3,500 (courtesy of Microsoft)
Second Prize: a Resharper License (courtesy of JetBrains), plus a copy of C# in a Nutshell (courtesy of Joe Albahari), plus a license for NDepend (courtesy of Patrick Smacchia).
Third Prize: a copy of Code Craft (courtesy of O’Reilly), plus a LINQPad auto-completion license (courtesy of Joe Albahari).
Audience Door Prizes: a Resharper License (courtesy of JetBrains), and a copy of Professional Visual Studio 2008 (courtesy of Dave Gardner).

In addition, the top 3 voted talks will each receive a copy of Professional Visual Studio 2008 (courtesy of Dave Gardner).

There will be pizza and refreshments provided.