Monthly Archives: November 2014

SQL Server Data Files on Azure

Azure | SQL Server 2014 With SQL Server 2014 it’s easy to move database files to the Azure Blog storage even if the SQL Server runs on premise. Azure Blob storage offers reliable, cheap and high available storage, which could … Continue reading

Posted in Allgemein | Leave a comment

Combining multiple tables with valid from/to date ranges into a single dimension

Dimensional modeling Tracking historical changes within a dimension is a common task in data warehousing and well covered by Ralph Kimball’s slowly changing dimension (SCD) methods. In short, the SCD methods proposed by Ralph Kimball assume, that the source system … Continue reading

Posted in Allgemein | Leave a comment