NH Blog - Articles on database

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

top
Back to top