…brew your own Business Intelligence

Archive for December 2012

2012 Year End Review

2012 was a banner year for me and my family…health, wealth, and plenty of happiness.   Below is a review of event/accomplishments from 2012 and goals for 2013. 2012 Life-Related Me and the wifey made a pact at the end of 2011…in 2012 we were going to focus and invest in lifestyle […]

Read more

All Your *Books* Are Belong To Us…

This year I plowed through a ton of books…more so than in all prior years.  This is primarily due to the amount of work-travel…way too much…which left me with a lot of time to read (on planes, in airports, in hotels, etc).  At this point in my life, all of my […]

Read more

So you think you’re ready to integrate Facebook data? Not so fast!

If you’ve been following the mini-series on integrating Facebook data, welcome back.  If not, then I recommend you take a moment and bring yourself up to speed: Value of Integrating Facebook Data For Customer Analysis Facebook as a Data Source Extracting Facebook Data with SSIS In this next post, I […]

Read more

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 […]

Read more

Facebook as a Data Source

Earlier this month year, I discussed the value of integrating Facebook data for customer analysis.  Originally, I planned to follow up with a post covering the process of extracting data from Facebook using SSIS… but as I started working through the material, I quickly realized the background information on ‘Facebook as a data […]

Read more

Defensive Database Programming with SQL Server

A couple of weeks ago, I spent some time reviewing a few trigger-based constraints recently put in place to enforce business-rules in a database I’m working on for a client.  Specifically, I was looking for any potential side-effects that could arise with a database that is configured for READ-COMMITTED SNAPSHOT ISOLATION. […]

Read more