Hi folks, I’m the CTO for Vamosa, a software company headquartered in Glasgow, with an rapidly expanding office in Boston (across the pond). We’re a 30-man strong company with a small development team in Glasgow that needs expansion. Our software allows clients to migrate and transform huge websites, from one content management system to another. The software is built on both J2EE and .NET, using the usual suspects in componentry: Spring, xUnit, Hibernate, etc. etc. Woven through all of this is a big helping of both Jython and IronPython. I’m looking for an opinionated,...

I’ve been playing around with SQL Server 2008 CTP, exploring the benefits of the new HIERARCHYID datatype, which has been designed to efficiently store depth-first tree structures in SQL Server 2008. My requirements were to store URI paths such as ones you might find in URLs, whereby each path component is held as a separate record in a table. Each path component refers to a folder in file system, e.g. URL: http://www.vamosa.com/index/information_solutions/technology_and_products/vamosa_content_migrator.htm URI: path:...