Software Know How Logo
Skin Border Image

Software Know How Blog

Skin Border Image

 

Skin Border Image Skin Border Image
Author: Dave Created: Friday, February 12, 2010 5:41 PM RssIcon
Welcome to my blog! My name is Dave Clayton and I am the lead developer of the Software Know How web site. I have worked in the IT industry since the year 2000 where I have gained knowledge of various development technologies ranging from MS-DOS applications right through to modern web applications.

My specialist subject and main area of interest is database development. Having started out as a Microsoft Access developer for a software house I gained a good understanding of database concepts and a good foundation of database design and architecture. I quickly became familiar with Microsoft SQL Server which I now consider to be my strong point.

In more recent years I have been using a web content management system known as DotNetNuke. This framework provides a mechanism for building anything from a quick hobbyist web site right up to a professional enterprise web site. For me, the fact that the framework runs on SQL Server is also a bonus!

Loopless recursion with SQL Server

By Dave on Tuesday, March 23, 2010 5:45 PM

When it comes to writing T-SQL, one of my pet hates is the unnecessary use of loops and cursors. As we all know, SQL is a set based language and has been designed to work using sets of data. Far too often do I see people looping unnecessarily in their back-end code resulting in a slow user interface.

Comments (3)

What is DotNetNuke?

By Dave on Tuesday, February 16, 2010 12:34 PM

DotNetNuke (DNN) is a multi-portal web content management system. The softwareknowhow.info web site is a working example of what can be achieved using the DNN framework. DNN started out as an application from Microsoft designed to demonstrate the functionality available in their new ASP.NET 1.0 platform. This application was named the IBuySpy Portal.

Comments (2)
Skin Border Image Skin Border Image