SQL

This demo shows how to develop a time dimension for analyzing cube data with SQL Server 2008 R2 Analysis Services. A well designed time dimension enables rich time based analysis. A product dimension will also be developed using the dimension wizard, then customized by adding hierarchies and a…

This demo shows how to build a data model for a Microsoft BI solution using the Microsoft Entity Framework that exposes an OData feed to support self-service analytics.  Presenter: Peter Myers, Mentor, Solid Quality Mentors.

 This demo shows how to design a simple SQL Server 2008 R2 Reporting Services report using relational data for analyzing sales information that includes conditional formatting. Presenter: Peter Myers, Mentor, Solid Quality Mentors.  

This demo shows how to add interactivity to a SQL Server 2008 R2 Reporting Services report, including adding a parameter to filter the data, drilldown and drillthrough behavior, and interactive sorting. 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…

SummitCloud is a BizSpark startup that produces analysis and compliance software used by suppliers and retailers. Microsoft Partner Evangelist John McClelland and I sat down with SummitCloud CEO David Leibowitz to talk about SummitCloud, BizSpark, and the Microsoft Partner Network. This…

Margus Veanes and Pavel Grigorenko present a new exciting project: Qex. Pavel did an internship in the Research in Software Engineering team (RiSE) investigating automatic data generation methods for parameterized SQL queries. In this video, he shows the result of his 3-month…

This presentation talks about the various API's available for programming SQL Server 2008 R2 Analysis Services Data Mining.  The presentation also discusses how to embed data mining functionality in an application, and how to extend SQL Server 2008 R2 Analysis Services data mining…

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.

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…