NH Blog - Articles on SQL

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

Jun 16, 2020

What? Cosmic rays?

Okay, so the title. What's that about? I mean, good gravy, how are cosmic rays in anyway relevant to a blog about SQL Server? Srsly? Have you ever heard of DBCC? [...]

May 26, 2021

Virtualising SQL Server using Hyper-V 3.0 and SCVMM

In this blog post, I will discuss virtualising Microsoft SQL Server 2012 using Microsoft’s own Hyper-V 3.0 and System Center Virtual Machine Manager (SCVMM). Before [...]

May 07, 2021

Have you ever...?

Have you ever...? These three words at the beginning of a sentence usually mean that the person asking has done something in the past that they're not quite sure [...]

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

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

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

Oct 13, 2020

Enhancements to Transact-SQL for SQL Server 2014

Did you know that Microsoft has released a new version of SQL Server? (Of course you did!) Well, a new version means new stuff! It is a Microsoft product, so there are [...]

Jul 31, 2020

Become an ace in Microsoft Azure SQL Database

In my last post, Crash course in Microsoft Azure SQL Database, I discussed the Azure SQL Database platform, its role and key features. So now that we're across this, [...]

Jul 24, 2020

Crash course in Microsoft Azure SQL Database

Microsoft Azure SQL Database (formerly known as SQL Azure) is an easy to provision and manage cloud-based database management solution based on SQL Server [...]

Jul 04, 2020

4 steps to establish a SQL Server connection

Almost all applications that are developed these days will, at some point, connect to an external data source like SQL Server. When this need arises, you will have to [...]

Jun 26, 2020

Data Quality in SQL Server 2014 for dummies (Part 2)

In my last blog post, we had a mini crash course on data quality and the three elements essential to data quality - knowledge base, domain, and Reference Data Service [...]

Jun 20, 2020

Data Quality in SQL Server 2014 for dummies (Part 1)

Data quality is a major concern for anyone building a data warehousing solution. As organisations consume more data from more data sources, the need for data quality [...]

May 30, 2021

Implementing security in SQL Server 2014

Today, I want to discuss some of the security enhancements in SQL Server 2014, but before I do, have you ever considered how SQL Server compares to other database [...]

May 16, 2021

Implementing Big Data Solutions in SQL Server 2014

Hadoop. Hadoop. Hadoop. Big Data. Big Data. Big Data.  How many times have you heard the above terms in the last six months? How many times do you think one or the [...]

top
Back to top