Monthly Archives: April 2017

Gaps and Islands – Determining Continuous Hours

T-SQL Master Itzik Ben-Gan covered different solutions in SQL Magazine quite a few years ago, and there are many other articles out there about it. I thought I would give a current example we were solving where this came into...
Continue Reading →

Linked Server Inconsistent Meta Data Error and Synonyms

* Featured image from In most of our more recent tools we have a single layer in the ETL Staging solution that understands all of the connections to other systems / databases that need to be made. This layer is...
Continue Reading →

Microsoft Visual Studio 2017 Launched

Microsoft Launched Visual Studio 2017 a couple weeks ago.  The launch included quite a few videos on new features and solutions people are using to solve problems. Take a look at the descriptions to see if anything speaks to you....
Continue Reading →

Splitting User Stories and Hamburgers

On paper writing a good user story sounds easy. “As a … I want.. So that I can”. While that may convey the basics it does not always actually tell the story. Roman Pichler lays out 10 Tips For Writing...
Continue Reading →

Microsoft Levels Features in SQL 2016

With SQL 2016 SP1 Microsoft has started to level features out across the editions. Many options that were previously enterprise only, can now be used in other editions, such as standard. Each edition still has differences in the amount of...
Continue Reading →