…or any fully-blocking transforms for that matter. SSIS 101 The primary function of SSIS is to move data from location A to location B with the option of performing transformations to the data along … Continue reading PSA: Stop Putting Sorts in SSIS Data Flows…
SSIS Data Viewer Objects are Static
Recently, while debugging the logic involving a derived column component in an SSIS data flow, I learned something new and thought I’d share 🙂 Before we dive into the details, let’s quickly review a few … Continue reading SSIS Data Viewer Objects are Static
Reporting Against the SSIS 2012 Catalog
This weekend, on the way home from a nice few days at the beach with family, I was listening to a SQLBitsX session (A Lap Around the SSIS Catalog) by Jamie Thomson (b | t)Â and … Continue reading Reporting Against the SSIS 2012 Catalog
Passed 70-466 and 70-467 Exams + Study Guides
Earlier this month, I passed the following two exams putting me 1 away (70-462) from the MCSE Business Intelligence certification. 70-466 – Implementing Data Models and Reports with Microsoft SQL Server 2012 70-467 – Designing Business Intelligence … Continue reading Passed 70-466 and 70-467 Exams + Study Guides
Extracting Facebook Data With SSIS
This is the 3rd post in this quasi-series on Facebook data from a business intelligence perspective. Â First, we discussed the value of customer analysis and how integrating Facebook data can enrich such analysis. Â Next we … Continue reading Extracting Facebook Data With SSIS
SQL Server 2012 Certification Path Update
Yesterday morning, I passed the 70-463: Implementing Data Warehouses with Microsoft SQL Server 2012! This completes the second step on my SQL Server 2012 certification path. What follows is a quick outline of the materials … Continue reading SQL Server 2012 Certification Path Update
Value of Integrating Facebook Data For Customer Analysis
Unless you recently awoke from a coma, you probably noticed that Facebook filed for IPO earlier this year. Â The stock opened at $38/share valuing the company at ~$104 billion. Â Since then, the stock has gotten … Continue reading Value of Integrating Facebook Data For Customer Analysis