There are many techniques for doing quick, full loads of data with Microsoft SQL Server Integration Services (SSIS) for a reporting environment. This one is the quick change artist of the bunch. Our goal is to create a mechanism for doing a full data table load with little to no interruption to production reports that may rely on that table’s data. We’re going to quick load 30,000 or more records of data in the blink of an eye using a very simple, if commonly overlooked, technique. (continue reading…)
Tag: Concepts
Designing a Reporting Database Environment
As your production data grows, you will ultimately discover a need for a reporting database environment – that is, a database separate from production that allows ad hoc queries and reports to be generated from production data. The benefits of such a database are numerous and should not be overlooked. If your reports are currently sourced directly from a production database, then you should seriously consider this information. This article explores the need for such databases and design considerations for such an environment.
