SQLServer Tag

Data Warehouse Automation Guide > Posts tagged "SQLServer"

Change log DateChanges 21 February, 2017Due to a very useful discussion on LinkedIn with Dan Linstedt, I have made some changes in this article to emphasize that a PSA does not have a permanent place in any EDW (with exception, as Dan suggests, being the Hadoop NoSQL platform used for slower storage mechanisms). Today I want to discuss the Persistent Staging Area in an Enterprise Data Warehouse, or PSA...

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