How frustrating is it when setting up an SSRS report subscription to be stuck with the standard run times Daily, Hourly etc. With no options for adjusting or customizing the schedule to lets say just running during core business hours or exclude weekends etc. I have always found this to be a major shortcoming of … Continue reading
Top 10 Best Practices for Building a Large Scale Relational Data Warehouse Building a large scale relational data warehouse is a complex task. This blog post describes some design techniques that can help in architecting an efficient large scale relational data warehouse with SQL Server. Most large scale data warehouses use table and … Continue reading
In my travels I get questioned a lot regarding the importance of the ETL mapping document and do I have any good examples. Throughout my career I have developed many ETL mapping documents of various formats. I have taken a few minutes to outline the basics here. What is ETL Mapping Document :The ETL mapping … Continue reading
As all too often occurs you have a need to change the data type of a field used in the data model. For example lets say that the field in question is an integer in the source database but represents an account number. The users now have a requirement to support alphanumeric account numbers. Making … Continue reading
