I’ve been working with the Microsoft SQL Server BI stack since late 2000. When I started with SQL Server, my “community” consisted of my co-workers, my clients, and me. As communities go, it was a great community to be in. In 2001, our small boutique consulting company EssPro, founded by Mike Luckevitch, merged with another [...]

This is the fifth and final post for SSAS week at SQL University. If you’re just joining the class, you should review the previous lessons first: Why Do I Need a Cube & How Do I Get Started Dimension Design 101 Cube Construction 101 Cube Enhancements 101 Today, I’ll show you how to secure access [...]

This is the fourth post for SSAS week at SQL University. Here’s the coursework so far: Why Do I Need a Cube & How Do I Get Started Dimension Design 101 Cube Construction 101 In today’s post, I will show how you to correct problems that you discover in dimensions after you deploy the database [...]

This is the third post for SSAS week at SQL University. If you’re just joining the class, refer to Why Do I Need a Cube & How Do I Get Started and Dimension Design 101 to get caught up.  At this point, my expectation is that you have an Analysis Services project with at least [...]

This is the second post for SSAS week at SQL University. If you’re just joining the class, go back to the first post, Why Do I Need a Cube & How Do I Get Started, to get your bearings and get your environment ready, and then join me back here.  Today, I’ll walk you through [...]