Feb 14, 2021
Is it really that hard to edit a Hosts file?
I have run quite a number of infrastructure courses, including basic networking subjects for many years now, and it still amazes me how often students get stuck trying [...]
Jul 21, 2020
Visual creation of a Microsoft Azure SQL Database.
Hi Kids, welcome back for another thrilling, and hopefully edifying, blog post. You may recall that I wrote a blog a little while ago about creating a database using [...]
Apr 16, 2021
Odds are you are going to want to know something about this.
Have you ever watched the NRL Grand Final or perhaps the finale of The Block? How about the great race, Bathurst? Some amazing results with such matches and shows. Well, [...]
Mar 16, 2021
How to read and write XML
We create applications on a daily basis to meet our customers’ requirements; often the case will be to create a solution that can retrieve some information out of a data [...]
Feb 13, 2021
Two DBAs walk into a NoSQL bar
Two DBAs walk into a NoSQL bar and leave rather hurriedly when they can't find a table. Insert geek laugh here. Weak, isn't it? Well at least it gives me an opening [...]
Feb 09, 2021
Normalising your database: Third Normal Form (3NF) – Part 3
In our final part of the three part series about normalising databses (for part 1, click here and for part 2, click here), we satisfy all requirements for 3NF, or the [...]
Jan 12, 2021
Normalising your database: Second Normal Form (2NF) - Part 2
In the first part of the series, we looked at normalising into first normal form (1NF). In this article, the second part of the 3-part series, we focus on second normal [...]
Jan 06, 2021
Compact and repair an Access database
Databases can get big. Very big. This can be because they contain a large amount of data, but it can also be because of wasted space taken up by deleted data. When [...]
Dec 08, 2020
Normalising your database: First Normal Form (1NF) - Part 1
In this first part (of a 3-part series), we'll look at normalising our database design! The First Normal Form (1NF) sets the very basic rules for an organised [...]
Dec 01, 2020
'CONNECT ANY DATABASE' in SQL Server 2014
Today, I'd like to have a look at a new permission added to SQL Server 2014 that gives us a couple of interesting possibilities. So, hang in there while we have a quick [...]
