…brew your own Business Intelligence

Archive for November 2012

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

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

Read more