Advanced SQL Azure (October 2011 Update)
[MP4] [0:47:18] [2011/10/14]This presentation provides a high level overview of advanced SQL Azure services including SQL Azure Reporting, SQL Azure DataSync and SQL Azure Federations. It was recorded in October 2011 and…
Introduction to SQL Azure (October 2011 Update)
[MP4] [0:39:09] [2011/10/14]This presentation provides a high level overview of SQL Azure Database from a developer perspective. It was updated in October 2011 and replaces a previous version of this presentation I did for PDC…
Demo: Publishing and Sharing SQL Server 2008 R2 PowerPivot Workbooks with SharePoint 2010 Excel…
[MP4] [0:05:18] [2011/04/26] This demo shows how to deliver browser-based access to SQL Server 2008 R2 PowerPivot workbooks using SharePoint 2010 Excel Services. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Demo: Self-Service Analysis with SQL Server 2008 R2 PowerPivot for Excel 2010
[MP4] [0:10:57] [2011/04/25] This demo shows how a user can create an in-memory cube with SQL Server 2008 R2 PowerPivot and Excel 2010. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Presentation: Self-Service Analysis Fundamentals with SQL Server 2008 R2
[MP4] [0:14:48] [2011/04/21] This presentation introduces the concept of self-service analysis and the business scenarios it addresses, and discussions how SQL Server 2008 R2 can be used to meet these requirements. An…
Demo: Self-Service Reporting with Report Builder 3.0
[MP4] [0:06:31] [2011/04/16] This demo shows how users can create a report with Report Builder 3.0 and SQL Server 2008 R2 Reporting Services using the map wizard that will leverage a shared dataset and report parts. Presenter:…
Presentation: Self-Service Reporting Fundamentals with SQL Server 2008 R2
[MP4] [0:12:19] [2011/04/14] This presentation introduces the concept of self-service reporting and the business scenarios it addresses, and discussions how SQL Server 2008 R2 can be used to meet these requirements. An…
Demo: Embedding SQL Server 2008 R2 Analysis Services Data Mining in a Custom Application
[MP4] [0:05:17] [2011/04/13] This demo shows how to embed a SQL Server 2008 R2 Services data mining model in a custom application to flag possible data anomalies during data entry. Presenter: Peter Myers, Mentor, Solid Quality…
Presentation: Programming SQL Server 2008 R2 Analysis Services Data Mining
[MP4] [0:04:43] [2011/04/12] 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…
Demo: Developing Data Mining Models with SQL Server 2008 R2 Analysis Services
[MP4] [0:11:09] [2011/04/07] This demo shows how to use two different SQL Server 2008 R2 Analysis Services data mining algorithms (Decision Trees and Naïve Bayes) to classify customers for a marketing campaign. The results from…
Presentation: Data Mining Fundamentals with SQL Server 2008 R2 Analysis Services
[MP4] [0:11:18] [2011/04/06] This presentation introduces the concept of data mining and the business scenarios it addresses, and disccuses how SQL Server 2008 R2 Analysis Services can be used to meet these requirements. An…
Demo: Developing Interactive Reports and Dashboards with SharePoint 2010 PerformancePoint Services
[MP4] [0:06:15] [2011/04/05] This demo shows how to develop an interactive report and to assemble a dashboard using a filter, scorecard and report with SharePoint 2010 PerformancePoint Services. Presenter: Peter Myers, Mentor,…
Announcing Metro Early Adoption Program for SQL Server Code Name "Denali"
[MP4] [0:08:30] [2011/04/05] Microsoft is busy preparing the next release of SQL Server, code named "Denali". This is a major new release of SQL Server featuring improvements that will appeal to developers and IT…
Presentation: Developing Reports and Dashboards with SharePoint 2010 PerformancePoint Services
[MP4] [0:12:31] [2011/04/04] This presentation covers how to build a SharePoint 2010 PerformancePoint dashboard that includes a report. Peter Myers, Mentor, Solid Quality Mentors.
Demo: Developing KPIs and Scorecards with SharePoint 2010 PerformancePoint Services
[MP4] [0:06:51] [2011/04/02] This demo covers how to develop KPI's and Scorecards with SharePoint 2010 PerformancePoint Services. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Presentation: Developing KPI's and Scorecards with SharePoint 2010 PerformancePoint Services
[MP4] [0:10:54] [2011/04/01] This presentation covers how to build a SharePoint 2010 PerformancePoint Services scorecard that includes KPI's. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Demo: Delivering an Interactive Performance Management Dashboard with SharePoint 2010…
[MP4] [0:04:48] [2011/03/30] This demo shows an interactive management dashboard built with SharePoint 2010 PerformancePoint Services that is designed to help users monitor and analyze sales performance based on a SQL Server…
Presentation: Performance Management Fundamentals with SharePoint 2010 PerformancePoint Services
[MP4] [0:10:34] [2011/03/30] This presentation introduces the concept of performance management and the business scenarios it addresses, and discusses how SharePoint 2010 PerformancePoint Services can be used to meet these…
Demo: Publishing and Sharing SQL Server 2008 R2 Analysis Services Cube Data with SharePoint 2010…
[MP4] [0:03:20] [2011/03/29] This demo shows how to deliver browser-based access to SQL Server 2008 R2 Analysis Services cube data using SharePoint 2010 Excel Services. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Presentation: Using SharePoint 2010 Excel Services with Analysis Services Data
[MP4] [0:10:34] [2011/03/29] This presentation covers the use of SharePoint 2010 Excel Services to provide users access to Analysis Services data. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Demo: Developing a Simple SQL Server 2008 R2 Reporting Services Report with an Analysis Services Cube
[MP4] [0:05:45] [2011/03/29] This demo shows how to develop a simple SQL Server 2008 R2 Reporting Services report using Analysis Services cube. The demo will show how to develop an MDX query with the graphical designer, and how…
Demo: Creating an Excel 2010 PivotTable Using a SQL Server 2008 R2 Analysis Services Cube
[MP4] [0:10:00] [2011/03/29] This demo shows how to create an Excel 2010 PivotTable using an SQL Server 2008 R2 Analysis Services cube. The PivotTable will support interactive filtering with a slicer and incorporate…
Presentation: Using Excel 2010 as an Analysis Services Client
[MP4] [0:11:08] [2011/03/18] This presentation covers the use of Excel 2010 as an Analysis Services client. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Presentation: Developing SQL Server 2008 R2 Reporting Services Reports for Analysis Services
[MP4] [0:07:07] [2011/03/16] This presentation introduces the SQL Server 2008 R2 Reporting Services query designer for Analysis Services which is used to graphically design MDX queries used in a report data source. Presenter:…
Demo: Enriching a SQL Server 2008 R2 Analysis Services Cube with Calculations
[MP4] [0:09:35] [2011/03/15] This demo shows how to enrich a SQL Server 2008 R2 Analysis Services cube with calculated members, named sets and key performance indicators (KPIs). These calculations make it possible to incoporate…
Presentation: Exploring SQL Server 2008 R2 Analysis Services Cube Calculations
[MP4] [0:09:30] [2011/03/14] This presentation covers calculations and formulas in SQL Server 2008 R2 Analysis Services. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Demo: Introducing SQL Server 2008 R2 Analysis Services MDX Query Development
[MP4] [0:08:03] [2011/03/11] This demonstration introduces simple SQL Server 2008 R2 Analysis Services MDX query statements. MDX, or Multi-Dimensional eXpressions, makes it easy to perform powerful analytic queries and…
Presentation: Exploring SQL Server 2008 R2 Analysis Services MDX Query Techniques
[MP4] [0:19:32] [2011/03/10] 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…
Presentation: Introduction to SQL Server 2008 R2 Analysis Services MDX
[MP4] [0:08:16] [2011/03/09] 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…
Demo: Enhancing the End User Experience of a SQL Server 2008 R2 Analysis Services Cube
[MP4] [0:06:42] [2011/03/08] This demo shows how to develop an enhanced end user experience for SQL Server 2008 R2 Analysis Services cubes by adding actions, perspectives and translations. Presenter: Peter Myers, Mentor, Solid…
Demo: Developing a Time Dimension with SQL Server 2008 R2 Analysis Services
[MP4] [0:12:34] [2011/03/07] 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…
Presentation: Introduction to SQL Server 2008 R2 Analysis Services Programming
[MP4] [0:04:10] [2011/03/06] This presentation covers how to programmatically extend SQL Server 2008 Analysis Services, and how to access and manage cube data from applications. Presenter: Peter Myers, Mentor, Solid Quality…
Demo: Developing a SQL Server 2008 R2 Analysis Services Database
[MP4] [0:07:39] [2011/03/04] This demo covers how to develop a simple cube (UDM) for analyzing sales data using SQL Server 2008 R2 Analysis Services. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Presentation: Understanding the Components of a SQL Server 2008 R2 Analysis Services Database
[MP4] [0:14:03] [2011/03/03] This presentation provides an overview of the various components that make up a SQL Server 2008 R2 Analysis Services database, including data sources, data source views, cubes, dimensions,…
Presentation: Analysis Fundamentals with SQL Server 2008 R2 Analysis Services
[MP4] [0:08:28] [2011/03/03] SQL Server 2008 R2 Analysis Services makes it possible to create powerful and sophisticated analytical models that enable fast ad-hoc queries of pre-aggregated data in a Microsoft BI solution. This…
Demo: Developing Embedded SQL Server 2008 R2 Reporting Services Applications
[MP4] [0:06:24] [2011/02/28] This demo shows how to develop applications that leverage the full functionality of SQL Server 2008 R2 Reporting Services, including leveraging the web services API and embedding the Visual Studio…
Presentation: Accessing SQL Server 2008 R2 Reporting Services Reports Programmatically
[MP4] [0:08:00] [2011/02/26] This presentation describes how to access SQL Server 2008 R2 Reporting Services reports programmatically using the Report Services web service. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Demo: Enabling Self-Service Reporting by Publishing SQL Server 2008 R2 Reporting Services Shared…
[MP4] [0:04:25] [2011/02/25] This demo shows how to enable self-service reporting with SQL Server 2008 R2 Reporting Services by publishing a shared dataset and report parts. Presenter: Peter Myers, Mentor, Solid Quality Mentors.…
Presentation: Enabling Self-Service Reporting with SQL Server 2008 R2 Shared Components
[MP4] [0:06:17] [2011/02/25] Users often request the ability to design their own reports. SQL Server 2008 R2 Reporting Services makes self-service reporting easy using report galleries. Instead of building reports from scratch,…
Demo: Publishing SQL Server 2008 R2 Reporting Services Reports
[MP4] [0:03:30] [2011/02/23] This demo shows how to deploy SQL Server 2008 R2 Reporting Services reports so they can be accessed by a user, and how to explore, view and manage Report Server content using Report Manager.…
Presentation: Publishing SQL Server 2008 R2 Reporting Services Reports
[MP4] [0:06:39] [2011/02/23] This presentation covers the various deployment options for publishing SQL Server 2008 R2 Reporting Services Reports. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Presentation: Extending SQL Server 2008 R2 Reporting Services Reports with Custom Logic
[MP4] [0:04:03] [2011/02/22] This presentation shows how developers can extend SQL Server 2008 R2 Reporting Services reports with custom .NET Framework logic. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Demo: Adding interactivity to a SQL Server 2008 R2 Reporting Services Report
[MP4] [0:05:30] [2011/02/18] 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…
Presentation: Adding interactivity to a SQL Server 2008 R2 Reporting Services Report
[MP4] [0:09:01] [2011/02/18] 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. …
Demo: Developing a Simple SQL Server 2008 R2 Reporting Services Report with a Relational Data Source
[MP4] [0:07:00] [2011/02/18] 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…
Presentation: SQL Server 2008 R2 Reporting Services Report Design Basics
[MP4] [0:14:21] [2011/02/18] This presentation covers the basics of SQL Server 2008 R2 Reporting Services report design, including how to create a report project and define data sources. Presenter: Peter Myers, Mentor, Solid…
Presentation: Reporting Fundamentals with SQL Server 2008 R2 Reporting Services
[MP4] [0:16:23] [2011/02/18] 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…
Demo: Implementing Data Flow in a SQL Server 2008 R2 Integration Services Package
[MP4] [0:07:01] [2011/02/18] This demo introduces the concept of data flow in a SQL Server 2008 R2 Integration Services package. Data flows can be developed to extract data from multiple sources, and then integrate and…
Presentation: Loading Fact and Dimension Tables in a SQL Server 2008 R2 Integration Services Package
[MP4] [0:10:15] [2011/02/18] Dimensional data models have unique traits that must be considered when implementing an ETL process to load them. This presentation describes how to load fact and dimension tables in a SQL Server…
Presentation: Implementing Data Flow Tasks in a SQL Server 2008 R2 Integration Services Package
[MP4] [0:14:27] [2011/02/18] SQL Server 2008 R2 Integration Services includes a powerful data flow engine optimized for ETL processing. This presentation covers how to build data flow tasks which are a fundamental part of any…
Demo: Implementing Control Flow in a SQL Server 2008 R2 Integration Services Package
[MP4] [0:08:03] [2011/02/18] This demo introduces the concept of control flow in a SQL Server 2008 R2 Integration Services package. Control flow governs the order and precedence of how tasks are executed. Presenter: Peter…
Presentation: Implementing Control Flow in a SQL Server 2008 R2 Integration Services Package
[MP4] [0:11:37] [2011/02/18] This presentation introduces how SQL Server 2008 R2 Integration Services uses control flow to govern the order and precedence of how tasks are executed. Presenter: Peter Myers, Mentor, Solid Quality…
Presentation: Introducing ETL Processing with SQL Server 2008 R2 Integration Services
[MP4] [0:05:26] [2011/02/18] ETL processing (extract, transform, load) is a fundamental component of many Microsoft BI solutions. ETL enables the transformation of raw data into meaningful and actionable information. SQL…
Demo: Creating a Data Model with the Microsoft Entity Framework
[MP4] [0:04:57] [2011/02/18] 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,…
Presentation: Designing Semantic Models for Microsoft BI Solutions
[MP4] [0:05:15] [2011/02/18] This presentation introduces developers to semantic modeling techniques. Semantic data models make it easy for developers and users alike to query and analyze data in a Microsoft BI solution. …
Demo: Exploring a Sample Dimensional Data Model
[MP4] [0:04:20] [2011/02/18] This demo introduces the dimensional modeling techniques used in the AdventureWorksDW2008R2 sample database. This sample is helpful for learning how to build a star schema. Presenter: Peter Myers,…
Presentation: Designing Data Models for Microsoft BI Solutions
[MP4] [0:13:54] [2011/02/18] 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…
Demo: Introducing the Microsoft BI Development Toolset
[MP4] [0:02:59] [2011/02/18] This demo introduces the primary development tools used to build Microsoft BI solutions, including Visual Studio / Business Intelligence Development Studio, SQL Server Management Studio. Presenter:…
Presentation: Introducing Microsoft BI Solution Development
[MP4] [0:12:50] [2011/02/18] This presentation introduces Microsoft BI solution development and its primary value proposition. Microsoft BI expands the reach of your investments in the Microsoft productivity platform, data…
Demo: Delivering Information to Decision Makers with a Microsoft BI Solution
[MP4] [0:15:22] [2011/02/18] This demo shows a complete BI solution end-to-end that delivers information to decision makers using SQL Server 2008 R2 and Office 2010. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Presentation: Understanding Business Intelligence
[MP4] [0:16:19] [2011/02/18] This presentation defines business intelligence and discusses how to apply business intelligence to address common business problems. It also discusses several different BI solution scenarios and…
Introduction to SQL Azure
[MP4] [0:39:51] [2011/02/18] Microsoft SQL Azure Database is a cloud-based relational database service built on SQL Server® technologies. It provides a highly available, scalable, multi-tenant database service hosted by…