Goatly.net

Using a recursive CTE to read the root parent id of a hierarchical table

Dec 8, 2009

Note that this post could be considered the second part in my previously incredibly short series of 1 posts: Good Uses for SQL Server 2005 Common Table Expressions - previous entries being: Part 1 - Determining the top and bottom n pieces of information in a set Part 0 - Introduction -- Ok, so the title of the post is …

How to determine the version of IIS

Mar 9, 2009

It took me far too long to work this out; I needed to know whether or not it was safe to try and set the ManagedPipelineMode property on an AppPool, and I figured the best way to do it would be to check the current IIS version and if it was 7.0 or above. The code to get the current version is straightforward, once you …

Creating MSBuild XSD schemas for your custom tasks

Dec 8, 2008

Update 12/10/2012 - Since the LSS website is no longer active, I’ve moved the download to this site. I’ve just uploaded a little utility onto our website herethe downloads section on this site that should help those developers that write their own MSBuild tasks. One of the nice features that’s a …

Collapsing Visual Studio Solution Explorer to Project Definitions

Jan 23, 2008

Here’s a little macro I’ve just knocked up that will collapse a Visual Studio Solution to just its project definitions - put here so you can use it too and I have access to it everywhere I work! 1 2Sub CollapseToProjects() 3 Dim items As UIHierarchyItems 4 Dim i As Integer 5 6 ' Get the root Solution …

Good Uses for SQL Server 2005 Common Table Expressions (Part 1)

Jan 11, 2008

Previous posts in this series: Part 0 - Introduction Determining the top and bottom n pieces of information in a set This scenario involves a set that has a column with both positive and negative ranges of data. The requirement is to filter it such that the only rows returned are those with the 3 highest positive and 3 …

Good Uses for SQL Server 2005 Common Table Expressions (Part 0)

Jan 10, 2008

A significant portion of my time as a developer is taken up looking into different approaches solving problems with newer technologies. Often it feels like I’m trying to understand the solution to a problem I haven’t yet defined, but I accept this because I look upon it as adding tools to my arsenal that I …

Determining Framework SDK Path

Aug 6, 2007

Something I’ve needed to do a couple of times now is programmatically work out where the the Framework SDK is installed. Each time I have to find an example from an old project, because I can never remember exactly how I did it before, so for posterity (and to save me searching again), I’m posting it up …

Easy way to enter GUIDs for WiX scripts

Jul 20, 2006

One of the pains of using WiX is that every component you create has to have its own unique GUID.Using the Tools/Create GUID... option from Visual Studio is one way to create a new GUID, but you have to copy and paste it into the right place in your script, which, when you have to create in the region of a trillion …

Configuring ADAM to use SSL

Jul 13, 2006

I’ve wasted muchos hours trying to configure ADAM to use SSL in an attempt to use securely it as a membership provider in ASP.NET 2.0, and one of the biggest problems was the documentation I found for it. The procedures I have managed to find on the internet are either wholly inadequate or simply …