Posts by Colin

What’s new?

What’s new?

For anyone that looks at my website, over the last couple of weeks you will have noticed some changes.  blog.cjdawson.com...

Where’s the photography stuff?

Where’s the photography stuff?

Why is my photography page so empty?   This is a work in progress.  My 2018 project is to build myself...

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...

Installing Apache, PHP and MySQL on a Raspberry PI

Installing Apache, PHP and MySQL on a Raspberry PI

Why Apache? I like to go into projects with my eye’s open.  There are choices about which server software to...

User interface for my mega server

User interface for my mega server

A couple of years ago I started a series of posts about setting up a Lamp configuration on a Debian...

All in one server (DHCP, DNS, NTP and VPN)

All in one server (DHCP, DNS, NTP and VPN)

In the previous posts, I’d decided to split up some of the services onto more than one PI.  Currently I...

Adding a DHCP server

Adding a DHCP server

Next step in this master plan is to add a DHCP server to the PI that is running my DNS...