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

Data Services: What's new with the RESTful data services framework

This code-heavy PDC09 session with Data Services architect Pablo Castro discusses the upcoming version of WCF (ADO.NET) Data Services, a simple, standards-based RESTful service interface for data access. (58:47)

Level: 200-300 (design and details)

Recorded Nov 18, 2009

Developing REST Applications with the .NET Framework

In this PDC09 session, Henrik Nielsen presents an overview of the REST principles and why REST is becoming popular beyond traditional Web applications. Learn how to write applications that produce and consume RESTful services using the .NET Framework 4 and the improvements we have planned for future versions of the .NET Framework. (57:40)

Level: 200-300 (design and details)

Recorded Nov 18, 2009

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

Evolving ADO.NET Entity Framework in .NET 4 and Beyond

See how the Entity Framework enables new capabilities to leverage multiple development approaches, for example the use of code-first, model-first, and database-first. In this PDC09 lightning round of new features by Shyam Pather and Chris Anderson, hear how, regardless of the development approach, developers will benefit from the Entity Framework and the deep integration with the rest of the Microsoft .NET Framework 4, such as the Microsoft ASP.NET MVC, Dynamic Data, and Windows Presentation Foundation. (55:19)

Level: 200-300 (design and details)

Recorded Nov 17, 2009

What's New in the Entity Data Model Designer in Visual Studio 2010 (Julie Lerman's Blog)

Julie Lerman, author of Programming Entity Framework (O'Reilly, 2009), demonstrates the best new features of the Entity Data Model Designer in Visual Studio 2010 Beta 2. Areas include how the EDM wizard names entities with proper plural and singular names, the impact that foreign keys have on association mappings, creating complex types, mapping stored procedures to entities, and creating functions from stored procedures. SHe also takes a quick look at model-first design. (18:41)

Level: 300 (details)

Recorded Oct 23, 2009

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.

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

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

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.

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

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

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)