…brew your own Business Intelligence

Archive for 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

MDS Update Required After SQL 2012 SP1 Installation

Earlier this month I installed SQL Server 2012 SP1 in my development environment.  But, unfortunately, I had to split before spending any time checking out the changes. Fast forward to this morning.  As I was firing up the MDS gui to try and reproduce an issue on the MSDN forum, […]

Read more

AdventureWorks, User Adoption, and Self-Service BI Projects

User adoption is critical to the overall success of any IT project…but that goes double for self-service BI projects because at the end of the project the users will be expected to actually use the tools to generate their own BI (reports, dashboards, scorecards, analysis) and facilitate fact-based decision making […]

Read more

TSQL Script: Check for Missing DEFAULT Constraints

Here’s a quick script I put together recently while polishing up a data model I’ve been working on.  This script will list every table containing a column named EffectiveDate that is missing a default constraint. The scenario that prompted its creation was for an EffectiveDate column that exists in a […]

Read more

System Upgrade: SSD + Windows 8 Pro

Warning: this post is mainly just fluff to let all five of my readers know that I haven’t forgotten about them. There are a lot of unfinished posts in the drafts folder that I plan on churning out over the coming weeks as we head into the end of the […]

Read more