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 [...]
Nov 03, 2020
SQL Server in Microsoft Azure virtual machines
You know that virtual machine you’re using that’s hosted on Windows Server 2012 R2 or System Center 2012 R2? Well, that same virtualisation technology is now available [...]
Aug 15, 2020
An epiphany about the cloud
I’m going to take you on a short journey, back a couple of years where we’ll find a younger version of myself, bright-eyed, enthusiastic…nah, really not a lot different. [...]
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 [...]
Apr 08, 2021
Scripting in SQL Server 2014
Today, I'm going to go into a little more detail with a topic I've previously covered, that is, scripting. There have been a few blog posts about PowerShell and I very [...]
Mar 20, 2021
SQL Server 2014: In-Memory Database Capabilities
Do you remember my blog about 'Hekaton'? You don't? Well, you can click here to have a look. What I want to do now, though, is update you on that. 'Hekaton' was a [...]
Mar 13, 2021
What's new in SQL Server 2014 Database Development
Are you excited yet? SQL Server 2014 is just around the corner. The actual release date is vague, but it's generally believed to be in the first half of this year, and [...]
Oct 16, 2020
Hello, my name is Hekaton - it's nice to meet you!
Alrighty then, so, you've had a bit of a look at SQL Server 2012, you may even have taken one or two of their superb MOC courses, and you’re probably asking yourself, [...]
