Data Development Videos (Pre-Release)

PDC 2009 Data Development Highlights

Since you're a busy developer and might nothave ten hours to watch all the data development videos from PDC 2009, we've assembled this 38-minute "lightning-round" video of highlights. Watch at double-speed for an every quicker overview! (38:19)

Level: 100-400

Recorded Nov 17-19, 2009

Data Programming and Modeling for the Microsoft .NET Developer

Don Box and Chris Anderson give the big picture of data programming and modeling at PDC09. This code-centric talk focuses on the advances being made in tools, languages, and frameworks that simplify how to model, consume, or produce data. Hear about the future of data programming and modeling using Microsoft products and services. (59:02)

Level: 200-300 (architecture and details)

Recorded Nov 17, 2009

Services Powering Experiences

In this video from the keynote at MIX 2010, Doug Purdy shows how the move towards providing Web APIs enables the creation of richer experiences, not only within browsers but across a wider spectrum of applications and devices. This signals a potentially profound shift in how we think about applications and web properties. (37:12)

Level: 100-300

Recorded Mar 16, 2010

Exploring SQL Server Modeling through MCsla (3 Part Series)

This three-part video series, Rockford Lhotka of Magenic discusses the benefits and usage of the SQL Server Modeling technologies in the context of MCsla, a model-driven prototype of his Csla.NET development framework.

• Part 1: Introduction (11:00)
• Part 2: Benefits of Modeling and MCsla Structure (12:38)
• Part 3: Code and Demo (19:10)

Recorded Jan 29, 2010

Building Data-Driven Applications Using Code Name "Quadrant" and Code Name "M"

In this PDC09 session, Chris Sells and Douglas Purdy show how to use "Quadrant" and "M" to interact with Microsoft SQL Server databases in rich new ways, including dynamic views and multi-user editing. See how to rapidly create the data-tier of your Microsoft .NET-connected application, speeding overall development time. Also learn how to customize both "Quadrant" and "M" to provide domain-specific experiences over your application data. (63:26)

Level: 200-300 (design and details)

Recorded Nov 17, 2009

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.

Simplifying MVC Web Applications with SQL Server Modeling

In this video, Jon Flanders of MCW Technologies demonstrates how the SQL Server Modeling technologies can simplify the development of ASP.NET applications. He creates a simple domain-specific language for describing routes, then uses the output of that language to drive the application both from an in-memory data source and from a SQL Server database. In the process he also shows how one can work either textually, in the code name “M” language, or visually, in the code name “Quadrant” tool, to create and manage the data. (35:40)

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

This video was recorded using the Nov 09 CTP.

Microsoft Code Name "M": The Data and Modeling Language

In this PDC09 session with Don Box and Jeff Pinkston, review how to use “M” to build a DSL and author data schema, then hear how we're going to make “M” more relevant to you, the Microsoft .NET developer. Explore the future of “M” where DSL, schema, and lots of other great ideas come together as a single Web-centric data processing language. (42:59)

Level: 200-300 (design and details)

Recorded Nov 18, 2009

Modeling in Text (Five-Part Series)

This five-part video series by Miguel Llopis, a member of the “M” language team, leads you through the step-by-step process of modeling a basic domain-specific language.

• Part 1: Modeling a Language (7:57)
• Part 2: Data (6:25)
• Part 3: Transformation (5:36)
• Part 4: Constraints (3:03)
• Part 5: Identity and Relationships (6:21)

Level: 300 (core competency)

This video was recorded using the Nov 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. (5:25)

Level: 200-300 (architectural and core competency)

This video was recorded using the Nov 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

Building Data-Driven Applications Using Code Name "Quadrant" and Code Name "M"

In this PDC09 session, Chris Sells and Douglas Purdy give a thorough overview and demonstration of "Quadrant" and why the tool is such a powerful way to interact with relational data. (63:26)

Level: 200-300 (design and details)

Recorded Nov 17, 2009

"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 Folders

This is the first of a two part series exploring folders in SQL Server Modeling Sercices. 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:55)

Level: 200-300 (architectural and core competency)

This video was recorded using the Nov 09 CTP.

Transcript | Slides

Folders and Security

This is the second of a two part series exploring folders in SQL Server Modeling Services. In this video we will explore how folders are used to secure data. (6:43)

Level: 300 (core competency)

This video was recorded using the Nov 09 CTP.

Transcript | Slides

SQL Server Modeling Services: Using Metadata to Drive Application Design, Development and Management

In this PDC09 session with James Baker and Shoshanna Budzianowski, see how to use SQL Server Modeling Services to increase speed and accuracy of development, deployment, maintenance, and management of your enterprise applications. Learn how to perform impact analysis, architecture validation, and manage application configuration/deployment using the UML, CLR, Identity, and deployment models. (61:30)

Level: 200-300 (design and details)

Recorded Nov 19, 2009

The 'M'-Based System.Identity Model for Accessing Directory Services

This PDC09 session covers Microsoft's investigation into modeling directory services data using an "M"-based logical model called System.Identity, which is included in SQL Server Modeling Services. See how to benefit immediately from this model by syncing data from Active Directory into the repository and then manipulating it with SQL and tools such as "Quadrant". (62:35)

Level: 200-300 (design and details)

Recorded Nov 17, 2009

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)