Data Development Videos (Pre-Release)

Design Walkthrough: Friendly Feeds Part 1

Mike Flasko, Data Services Program Manager, describes the Friendly Feeds capabilities for the next version of Data Services (4:58)

Level: 200 (design)

Recorded Sept 28, 2008

Design Walkthrough: Introducing $count as an URI query option

Mike Flasko, Data Services PM, discusses some design work we have been doing around providing support for our #1 customer ask, the ability to ask for the count via the Data Services URI syntax. (2:33)

Level: 200 (design)

Recorded Oct 24, 2008

Design Walkthrough: preview of code name "Astoria Offline"

Pablo and one of our hot shot developers Waseem Basheer sit down for a brief discussion about a project that we have spun up for adding sync and offline support to Data Services. (2:43)

Level: 200 (design)

Recorded Oct 30, 2008

Entity Framework Futures

This session was presented at PDC 2008. The next version of the Entity Framework adds scenarios in the areas of model driven development, domain driven development, simplicity, and integration. See a preview of production and prototype code for the next version of the Entity Framework as well as a candid discussion with members of the development team. (93:26)

Level: 200-300 (design and details)

Recorded Oct 2008

Creating a Setup Application with the SQL Server Modeling CTP

This video (14:24) follows through the Getting Started with the SQL Server Modeling CTP tutorial in the MSDN Library. The tutorial and this video describe how to create setup applications using the SQL Server Modeling CTP tools, starting with creating models, defining storage, and populating those models, then using the RepInst.exe tool to create a setup application (.msi) from that data.

Level: 200-300 (general end-to-end example)

This video was recorded using the Nov 09 CTP.

Event Pattern Mesh Sample

This video discusses and demonstrates an end-to-end application designed for detecting event patterns from real-time data feeds. (18:43)

Level: 200-300 (general end-to-end example)

This video was recorded using the Oct 08 CTP but contains few CTP-specific details. The sample works on the Nov 09 CTP.

Download sample

PhotoStore Sample

PhotoStore is an application that allows you to store information about your digital photographs in the Repository database, and to make this information selectively available to others. (23:27)

Level: 300 (general end-to-end example)

This video was recorded using the Oct 08 CTP, so some specific details are outdated. The associated sample is current for the Nov 09 CTP and should be used as a reference.

Download sample

Basic Concepts in "M"

This video shows some of the basic declarations used in "M", and how you can use "M" to model the objects used in an application.

This video was recorded using the Oct 08 CTP.

Getting Started with "M"

This video is an introduction to using the "M" language. It demonstrates how to declare a basic module in "M", compile it, and view the corresponding T-SQL statements generated by the compiler.

This video was recorded using the Oct 08 CTP.

Using Types for Reuse in "M"

This video is an introduction to using types in "M".

This video was recorded using the Oct 08 CTP.

Modeling in Text (Five-Part Series)

This five-part video series by David Langworthy, an Architect on The "M" Modeling Language Specification, leads you through the step-by-step process of modeling a basic domain-specific language.

• Part 1: Modeling a Language (7:27)
• Part 2: Data (4:45)
• Part 3: Transformation (4:57)
• Part 4: Constraints (2:33)
• Part 5: Identity and Relationships (5:40)

Level: 300 (core competency)

This video was recorded using the May 09 CTP.

Transcript

Understanding the Mapping of "M" to SQL Server

An introduction to how constructs in the "M" language map to their equivalents in T-SQL. (4:58)

Level: 200-300 (architectural and core competency)

This video was recorded using the May 09 CTP.

Transcript

Quick Look: Creating a Movie Language

This video follows through the A DSL for Movies tutorial in the Library, demonstrating token, syntax, and interleave rules, output projections, developing a DSL in “Intellipad”, and generating an M file from the input data that can be loaded into the repository. (12:12)

This video was recorded using the May 09 CTP.

Level: 300 (core competency)

A DSL for Movies tutorial

Person Example (MGraphXAMLReader)

This video shows how you can use a dynamically-parsed grammar to instantiate CLR objects using a simple domain-specific language (DSL). (6:10)

Level: 200-300 (usage to details)

This video was recorded using the Oct 08 CTP. The sample works on the Nov 09 CTP.

Download Sample

"Quadrant" Overview

This video introduces the Microsoft code name “Quadrant” tool for viewing and editing SQL Server databases. After a short overview of “Quadrant’s” primary features and functional scenarios, Christina Storm, Group Program Manager for “Quadrant”, demonstrates creating a database within “Quadrant” from an “M” model, exploring and editing data in the newly created database, and modifying "Quadrant’s" table viewer by changing its “M” model. (24:02)

Level: 100-200 (introductory and usage)

This video was recorded using the Nov 09 CTP.

"Quadrant" UI Overview

This video demonstrates the design principles of “Quadrant’s” user interface and how simple but powerful gestures allow you to create a unique viewing and editing experience over a SQL Server database. (3:55)

Level: 100-200 (introductory and usage)

This video was recorded using the Nov 09 CTP.

Sessions in "Quadrant"

In this video, Program Manager Noaa Avital introduces you to the concept of sessions in “Quadrant”, which allow you to work with multiple databases as well as multiple views of the same database. (5:14)

Level: 200 (usage)

This video was recorded using the Nov 09 CTP.

Editing in "Quadrant"

This video demonstrates how editing works in “Quadrant”, including how “Quadrant” tracks changes to a database session and how “Quadrant” helps you easily resolve conflicts between a session and external changes to the database. (7:39)

Level: 200 (usage)

This video was recorded using the Nov 09 CTP.

Viewer Configuration

In this video, Program Manager Pedro Ardila demonstrates some of the different viewers in “Quadrant”, such as Tree, Table, and Master/Detail, that provide the most common ways of viewing data. He also shows how those viewers can be both composed together for richer views and customized using the code name “M” language. (8:48)

Level: 200-300 (usage and details)

This video was recorded using the Nov 09 CTP.

Error Handling in "Quadrant"

This video shows how “Quadrant” handles different kinds of errors that arise in working with data, such as input validation and query compilation. (4:50)

Level: 200 (usage)

This video was recorded using the Nov 09 CTP.

T-SQL Console

In this video, Program Manager Gersh Payzer introduces you to the T-SQL console, which allows you to execute arbitrary SQL scripts directly within “Quadrant”. (2:09)

Level: 200 (usage)

This video was recorded using the Nov 09 CTP.

Lap Around "Quadrant": Petshop Demonstration

This video demonstrates viewing and editing the PetShop database within “Quadrant” as discussed in the “Quadrant” Petshop Tutorial in the MSDN Library. (15:54)

Level: 200 (usage)

This video was recorded using the Nov 09 CTP.

Introduction to SQL Server Modeling Services

SQL Server Modeling Services focuses on securely storing and sharing models that focus on the application lifecycle. This video discusses Modeling Services features, the common models that ship with the CTP, and the process for creating your own models. (5:45)

Level: 100-200 (introductory and architectural)

This video was recorded using the Nov 09 CTP.

Transcript | Slides

Understanding Repository Folders

This is the first of a two part series exploring folders in the Repository database. This video discusses the purpose and design of folders, then how to create new folders and associate data rows with those folders in "Quadrant". (6:44)

Level: 200-300 (architectural and core competency)

This video was recorded using the May 09 CTP.

Transcript | Slides

Folders and Security in the Repository

This is the second of a two part series exploring folders in the Repository. In this video we will explore how folders are used to secure repository data. (5:30)

Level: 300 (core competency)

This video was recorded using the May 09 CTP.

Transcript | Slides

Introducing Domain-Specific Languages

As Martin Fowler begins to see the light at the end of the tunnel on drafting his DSL book, he's been prone to give more talks introducing DSLs. While he wouldn't consider it appropriate to give such a talk at this august gathering, he did think it would be interesting to do a meta-talk version of his introductory talk. For this he'll walk through the same material, but instead talk about why he thinks the approach he takes to an introduction is a useful way to guide people in their approach to DSLs.

M DSLs: Deep Dive

We will do a deep dive into the "M" parser generator and may even have some new features to talk about as well.

Domain Specific Languages for automated testing of equity order management systems and trading machines

This talk presents a DSL using the SQL Server Modeling CTP toolset that is capable of expressing order generation and responses from a range of market behaviors in terms of FIX messages in a dialect suitable for use by traders and financial engineers.

Perspectives on Domain-Specific Languages

Microsoft Program Manager Chris Sells and DSL expert Martin Fowler discuss the history and future of Domain Specific Languages (DSLs). (21:12)

On the History of DevCon, DSLs and the SQL Server Modeling CTP

Tune in and learn from Chris Sells the story of What, How and Why of DevCon. We of course also talk about the SQL Server Modeling CTP (formerly "Oslo") and what the heck it is. (17:30)