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 … Continue reading MDS Update Required After SQL 2012 SP1 Installation
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 … Continue reading AdventureWorks, User Adoption, and Self-Service BI Projects
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. … Continue reading TSQL Script: Check for Missing DEFAULT Constraints
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 … Continue reading System Upgrade: SSD + Windows 8 Pro
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 … Continue reading SQL Server 2012 Certification Path Update