This presentation explores query techniques used in SQL Server 2008 R2 Analysis Services MDX, including defining an axis, creating a set, set manipulation, using functions and keywords, asymmetrical queries and cell properties. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
EdgeOct 21, 2011 at 8:00 AM0
Avg Rating: 0
News: Welcome to the first TechNet Edge show! Symon and David start Episode 1 by reviewing the news, then they introduce Ananthanarayan Sundaram, a Senior Product Manager in System Center. News Highlights Highlights from the 2011 SQL Pass ConferenceWindows Intune General Availability…
The Data-Tier Application Framework (DAC Fx) is a powerful new way to deploy and upgrade database projects for both your on-premise and cloud applications. Prior releases of DAC Fx only supported side-by-side upgrades. SQL Server 2012 includes DAC Fx 3.0, which supports the ability to perform…
This presentation provides an overview of common business reporting scenarios and challenges, and discusses how SQL Server 2008 R2 Reporting Services can address them. A brief overview of the architecture of Reporting Services is also covered. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Microsoft SQL Data Services (SDS) offers highly scalable and Internet-facing distributed database services in the cloud for storing and processing relational queries. In this geekSpeak webcast, James Johnson provides an overview of working with SQL Data
Services—what it is, how it works, why you…
This presentation covers how to add interactivity to a SQL Server 2008 R2 Reporting Services report such as parameters, toggling visibility, links, drill through, document maps and sorting. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
High Performance and Scalability improvements in SQL Server 2012: Lubor Kollar Session Objectives and Takeaways: SQL Server Engine Team More Online Operations in SQL 2012 Support 15 000 Partitions Full Text Search Columnstore Index Windows 8 Server and SQL 2012 A presentation of the top engine…
This presentation provides an introduction to SQL Server 2008 R2 Analysis Services MDX. MDX stands for "multi-dimensional expressions", and is used to write queries, formulas and calcuations for performing multi-dimensional analysis and reporting. Presenter: Peter Myers, Mentor, Solid…
This presentation introduces developers to dimensional data modeling techniques. Dimensional data models make it easy for developers and users alike to query and analyze data in a Microsoft BI solution. Presenter: Peter Myers, Mentor, Solid Quality Mentors.