//
archives

BI

This category contains 9 posts

Customizing SSRS Subscription Schedules

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

    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

What is ETL Mapping Document ?

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

Find All Deployed SSRS Reports That Reference A Particular String

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