This wasn’t a SQL Saturday, but Live from New York….It’s Brian Knight! Here, I will also discuss the theme of this jam-packed NYC SQL User group that brought dozens of SQL Server professionals out on a Thursday evening. I will define most of the technical terms in this article, as a matter of course. Instead I will give a high-level overview, and direct you to some useful and insightful resources to find out more. Although I will discuss some of technical content that was presented, I will not drill down in great detail. In this article, I will cover the topics and materials used in Brian’s exclusive SSAS overview, and the general nature of the user group experience. With some great live demos, he walks us through creating a cube, building a user interface for developers, as well as how to browse the cube in Excel. An introduction to SQL Server Analysis Service (SSAS), Brian gives us the benefits of using SSAS, explains dimensions and hierarchies, cube design and measures, as well as usage based optimization (UBO). We’ve read much on the topic since it was introduced in SQL Server 2005 (read my article Analysis Services, The Year of BI), but nobody delivers the goods quite like Brian. Back in July, 2009, it was a usual hot summer day in the Big Apple, but inside the NYC Microsoft Headquarters, was a very cool and awesome presentation going on, brought to us by SQL MVP, Principal of Pragmatic Works, co-founder of SSC.com (and in his own words, amateur surgeon), Brian Knight.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |