Configuring Integration Services in a SQL Server 2016 Cluster

In this post I will show a procedure to configure Integration Services in a SQL Server 2016 Cluster.Clustering Integration Services is...

PowerShell to Test a Query

So you want to do some tuning, but you’re not sure how to test a query on it’s performance. Not...

It greatly pleases me to announce, HAL0003!

I while back as part of a T-SQL Tuesday post I created HAL0001, then later HAL0002 with a long-term goal...

Restoring a SQL Server backup on Linux

Last Wednesday I got very excited by Microsoft’s announcements about the addition of features to standard edition and the public preview...

SQL Server & Containers – Part Two

This post follows on from SQL Server & Containers – Part 1 and will go through how to build custom container images.
Since...

Getting Team City working with BitBucket

As a part of building a CI/CD home lab, I set up TeamCity in the past. I plan on using...

PASS Summit Announcements: PolyBase enhancements

Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception.  I’m writing a set...

SQL Server on Linux: Boring

As a concept, SQL Server on Linux is thrilling. Due to this, the OS doesn’t stand in the way of...

Comparing and synchronizing Oracle databases

Applies to: xSQL Oracle Data Compare v1.0 - 2.0

As you may have noticed, most of the articles in this blog focus around scenarios and solutions for databases in Microsoft's...

Comparing and synchronizing Oracle databases

Applies to: xSQL Oracle Data Compare v1.0 - 2.0

As you may have noticed, most of the articles in this blog focus...