Creating a Generic SSRS Report

Creating useful reports is part art and part science. On one end of the spectrum, you have visually appealing and highly customized reports and dashboards that are truly works of art. These often illicit “oohs” and “aahs” at first glance, and can help to creatively tell the story of the underlying data. On the other end of the spectrum is…

Read More

ETL Antipattern: Failure to Test and Validate

“If it compiles, it works.” – An unemployed developer Building ETL processes is quite easy. Building ETL processes that deliver accurate results as quickly as possible is substantially more difficult. Modern ETL tools (including my personal favorite, SQL Server Integration Services) make it deceptively easy to create simple load process. That’s a good thing, because an easy-to-understand front end shortens…