Microsoft’s release of SQL 2014 might seem like it was an April fool’s joke, but they were quite serious with their general release of SQL 2014 on April 1st 2014. While there are many high-availability enhancements, and OLTP changes for in-memory operations (all of which are interesting), I would like to highlight some of the […]
Tag Archives: Data Warehouse
Want To Upgrade?
Introduction I have seen several posts lately asking about ROI/Justifications etc about upgrades. There are LOTS of posts on this topic, and some really great documentation from Microsoft that covers this topic at great length. This post does not really add anything to those, other than distilling some of the key points from the Microsoft […]
SSIS – Load Audit
Audits in SSIS create reusable packages that are easy to maintain, and provide valuable information about the data they are affecting.
Database Driven Aggregations
Introduction Have you ever had a series of aggregate (tsql) queries to run? Do you want to be sure they all run in the right order? Do you want to make the changes “dynamic” (no code changes required)? Certainly you can build an SSIS package that calls sql with the control-flow and control dependencies, however, […]
StefBauer's Blog - @StefBauer 