Entries Published On 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 changes that we felt would …
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 reading is work-related…I listen to audio …
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 want to discuss a few …
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 …
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 source’ was worthy of its …
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. During my online research, I …