Entries Published On 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, I was greeted with the …
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 in a rapidly evolving business …
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 lot of the tables in …
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 year…so stay tuned! A few …
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 …