Tag Archive For "SSIS"
PSA: Stop Putting Sorts in SSIS Data Flows…
…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 the way. That’s certainly an over simplification but it gives you the general framework from which to build. Note: there …
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 of the common methods for troubleshooting issues in an SSIS data flow: using error output paths that write to flat …
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 it got me thinking about some work I did at my last client and how I would do that work …
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 Solutions with Microsoft SQL Server 2012 Below is an outline of the material I worked through in preparation for these …
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 established a basic understanding of the Facebook social graph from which we wish to extract customer data. Value of Integrating …
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 I used while preparing for this exam along with some comments and afterthoughts. Data Warehouse Design Read The Data Warehouse …
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 absolutely crushed as critics everywhere have come crawling out of the wood work with claims about Facebook’s mobile strategy (or …