Will Gillen

Missing Debug/Release Configuration Manager in VS2005

willgillen@swirlhost.com — Wed, 06 Feb 2008 06:00:00 GMT

Occaisionally when setting up a new development PC, we find that the VS2005 Debug/Release configuration manager menu is missing when working with modules. Find out how we fix the problem.

MSSQL Reindex and Defrag - Performance boost

willgillen@swirlhost.com — Mon, 19 Mar 2007 06:00:00 GMT

Ever notice your MSSQL database starting to slow down after a few months of operation? This could be due to a fragmented datafile or bloated indexes. Learn how to give your SQL a performance boost by scheduling regular reindexing and degramentation of your database.

DNN 4.4.1 Upgrade Woes

willgillen@swirlhost.com — Fri, 02 Mar 2007 06:00:00 GMT

Although DotNetNuke 4.4.1 offers some very good performance updates, it also leaves some upgraders sitting a few hours in front of the PC trying to figure out what went wrong.

Using RAND() in an MSSQL UDF (User Defined Function)

willgillen@swirlhost.com — Thu, 16 Nov 2006 06:00:00 GMT

Some say it is impossible to use the RAND() function in an MSSQL User Defined Function. Learn how to do it here.