microsoft Tag

Data Warehouse Automation Guide > Posts tagged "microsoft"

Introduction As you might know, I started a survey on the usage and opinion about Data Warehouse Automation (DWA) Tools. Today I am presenting the results. I sincerely want to thank all the participants for sharing your thoughts. The participants First some insight into the persons that filled in the survey. You were not with so many (62 completed surveys). In statistics there is a formula to compute the minimum sample...

Read More

Introduction I must admit I have a weakness for British humour. When I had to cope with leading zeros in business keys some time ago, I spontaneously came up with the title of this post, not knowing that it would serve as such. For those who do not know, "Meetings, bloody meetings" is a British comedy training film in which John Cleese plays a main role. It was...

Read More

Introduction This weeks post is about the LoadDate and LoadEndDate. Actually there are two things to be nerdy on: End dating without gaps Getting the best value for bytes on DATETIME2 precision By the way, these topics apply to SQL Server, the examples are made using SQL Server 2014. 1. End dating without gaps How end dating works In a Data Vault Satellite, different subsequent versions of a row in the source...

Read More

Updates Change log DateChanges 31 January, 2017Really good news! The 8k limitation on HASHBYTES has been removed in SQL Server 2016! Today I would like to discuss Hash Diff calculation using SQL Server 2014, from my own experience. My purpose is NOT to be complete and/or to replicate book "Building a scalable data warehouse with Data Vault 2.0". For full details please read the book. However I will give a short...

Read More