This past weekend, I passed the 70-462 exam which completes the requirements for achieving the MCSE Business Intelligence certification. This exam had been lingering for quite some time and I continued to put it off because, to be … Continue reading SQL Server 2012 Certification Path Completed
PowerShell: Checking For Large SSAS String-Store Files
In a recent blog post, Why You Need to Routinely ProcessFull, I discussed an issue where we’d run into the 4GB file size limit on SSAS string store files. In an ideal world, we’d fully … Continue reading PowerShell: Checking For Large SSAS String-Store Files
Dimensional Modeling: Junk vs Degenerate
Two commonly misunderstood dimensional modeling techniques are Junk Dimensions and Degenerate Dimensions. This post is aimed at clearing up the confusion and providing some context and use-cases for each. Junk Dimensions There are certain scenarios … Continue reading Dimensional Modeling: Junk vs Degenerate
Steering the Car Back on the Road
In my last post (Go Work for a Consulting Firm), I discussed a difficult situation faced earlier in my career…back when I lacked the knowledge and expertise to solve the problems facing the team and … Continue reading Steering the Car Back on the Road