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