Technical Article: Report Model (SMDL) Alternatives in SQL Server 2012

28 August, 2013 (10:00) | Articles, Power Pivot, SSAS, SSRS, Tabular | By: Mark V

It is with tremendous joy that I announce the release of my very first Technical Article! Click the image below to get a copy of your very own.


When I first started in the SQL Server business with Digineer about 6.5 years ago, one of my earliest projects was implementing a SQL Server 2005 Report Model for a client. Lara Rubbelke (Blog|Twitter), who led Digineer’s Information Management (SQL Server) Team at the time, set me up with that project along with some top cover from the mighty Jason Strate (Blog|Twitter). With two great mentors like I was lucky enough to have, that project set the stage for my career in SQL Server. It was during that project that I came to firmly believe in empowering end users in a managed environment. In the next few years, I ended up working on several Report Models for clients and giving well attended Intro To Report Model presentations.

Upon discovering that SQL Server 2012 meant the beginning of the end for Report Models, I was concerned for the folks that had been investing in them since their release. I saw forum posts that expressed frustration at their demise since many organizations had come to rely on them. It was clear that there were some technologies available that were superior to Report Models that could make great replacements in different scenarios. I looked for a source that combined all that information into a single location to help ease the transition of Report Models to other alternatives in the Microsoft BI stack. Since I could not find one, I decided I should go ahead and make one. Behold!

I want to thank Lara and Jason for their mentorship at the beginning of my career and through today. I also want to thank my great Technical Reviewers for this article:

Jin Cho (LinkedIn) – Microsoft

Mike Donnelly (Blog|Twitter) – Digineer

Aaron Drinkwine – Digineer

Chris Fish (Twitter) – Digineer

I need to thank Digineer for their continued support and being an awesome place to call home.


Comment from becky nichols
Time June 9, 2016 at 7:42 am

Where is the link to this white page? This is exactly the information I need.

Comment from Mark V
Time June 9, 2016 at 11:57 am

Hi, Becky. Just click on the image showing the title of the paper. That leads you to its location. Thanks.

Comment from andy
Time July 26, 2016 at 2:44 pm

Hi, I’m getting “Oops, page not found” when I click on the image?

Comment from Mark V
Time July 26, 2016 at 5:40 pm

Hi, Andy. Sorry about that. That link went to a location Digineer controls. I have reached out to them asking about a new location. I will update this post when things have been rectified. Thanks for letting me know. Much appreciated.

Comment from Mark V
Time September 7, 2016 at 7:23 pm

Hi, Andy. The link has been fixed and you can download the article now. Thanks for your patience.

Comment from Tom
Time February 10, 2017 at 3:20 pm

Thanks – this is great info.

Comment from Mark V
Time February 14, 2017 at 3:20 pm

Thanks, Tom. Much appreciate. Please note that this was before Power BI, which changes the equation a bit for sure. :)

Write a comment