What out what links to a given table

What out what links to a given table

I needed to find out what tables referenced a given table by foreign key.  I needed to know this as...

Ascom Gps

Ascom Gps

Ascom GPS is a new program that I’ve created.  It’s taken me a while to get this into production, mainly...

ASCOM Driver for Meade LX-90

ASCOM Driver for Meade LX-90

ASCOM is a software platform that allows software applications to interact with hardware devices like telescopes, filter wheels, cameras and...

Sql Server Paging – part 2

Sql Server Paging – part 2

I left off the last post by saying that this is the code pattern that I was going to follow...

SQL Server Paging

SQL Server Paging

Paging is a technique where instead of returning the entire result of a query in one go, you return a...

The truth about CTE’s?

The truth about CTE’s?

I had an interesting conversation where a couple of colleagues were saying that CTE’s really work properly.  What do I...

Getting current memory usage

Getting current memory usage

I’ve started gathering the information that I need in order to be able to create the user interface that I...

Building a Lamp box using debian linux

Building a Lamp box using debian linux

LAMP – Linux, Apache, MySql & PHP.  These software packages installed together make for an extremely powerful way of hosting...

Nested Templates

Nested Templates

I’m still pulling content across from my current website into the new layout.  After messing about with dreamweaver for most...

New face of Astronomy.cjdawson.com

New face of Astronomy.cjdawson.com

Having spend a little time looking around the web, checking out sites, seeing suggestions of layouts and generally having a...