Component Workshop Ltd

SQL Server’s support for ANSI SQL includes the WITH keyword. With a little effort, this little gem lets you remove awkward sub-queries from the body of a SELECT statement, turning them in to tables that can be joined like any other.

This tip explains how you can easily clear your Temp folder of all files (that are not currently locked).

It is possible, with a little effort, to get SharePoint 2007 to search inside PDF documents that are added to your libraries. This article explains the configuration changes you need to make on your server to enable this feature.

Subversion is the perfect tool for versioning .NET projects. Here I take you through the steps you must follow if you want to use Subversion for your .NET Project.

When you try and run rake solr:start or rake solr:stop it uses Kernel.fork to spawn of a child process. However in JRuby this is disabled by default due to concurrency issues. And this prevents your solr rake tasks from running under a JRuby environment...

if you are a developer used to working with Microsoft SQL Server, your first experience with Oracle is likely to be a bit frustrating. The two systems are more different than you would imagine, and there is no nice point-and-click learn-by-trial-and-error interface in Oracle. This article will hopefully provide a helpful push in the right direction if you find yourself needing to learn how to develop on Oracle.