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

2539 days ago, 1076 views
PowerPoint PPT Presentation
Motivation behind Talk. Acquaint imparted modelsUnderstandHow to utilize themWhen to utilize themShare the demonstrating guide. SQL Server Modeling Services. declaring. . SQL Server Modeling Services Database. Displaying Tools. Biological system. Organizer, Security, Lifecycle, Containment, Referencing, Relationships, Views, Globalization/Localization.

Presentation Transcript

Slide 1

SVR19 Microsoft SQL Server Modeling Services Using Metadata to Drive Application Design, Development, and Management Shoshanna Budzianowski Partner Group Program Manager Microsoft Corporation

Slide 2

Purpose of Talk Introduce shared models Understand How to utilize them When to utilize them Share the demonstrating guide

Slide 3

SQL Server Modeling Services reporting

Slide 4

SQL Server Modeling Services Database Modeling Tools System. Runtime System. Personality System. Administration Microsoft .Uml2 Your Models Ecosystem Folder , Security, Lifecycle, Containment, Referencing, Relationships, Views, Globalization/Localization

Slide 5

Data around an Application is similarly as Important as the Application Data is created all through the application lifecycle Business necessities Application outline Conceptual engineering plan Developer Tasks Assignments Source code Assemblies Bugs Test information Deployment scripts Config records Registry settings Health and administration data IT arrangement strategies Log documents Symbol documents Debugger follows ...

Slide 6

With Coordinated Data, What Questions Could You Ask? Dev Manager Developer Testers Do I comprehend what we've assembled? Will I wager on utilizing this mutual segment? What's changed since I last tried this application?

Slide 7

Models In Everyday Life System.Runtime What: Assemblies, modules, strategies, sorts, … Why: U nderstand changes between shared segments over different renditions Microsoft.UML2 What: UML 2.1.1 Diagrams Why: Import and share outlines crosswise over arrangements, items, and merchants

Slide 8

Stock Trader Application Understanding demo James Baker Senior SDE BPD

Slide 9

Demo Summary Folders compose fabricate scenes Understand change between constructs Signatures, new/erased techniques, … Metadata traverses arrangements Uncover segment conditions UML graphs spans sellers and advancements Identify plan conditions

Slide 10

Our Goal Making Modeling Mainstream Partners System Integrators ISVs Standards Personas UX Designer Developer Business Analyst Architect IT Pro Information Worker Platform

Slide 11

Getting Started DMG Developer Center and Forum Download the SQL Server Modeling CTP from the website Microsoft SQL Server Home Page

Slide 12

Related PDC Sessions Cameron Skinner FT08 Code Visualization, UML and DSLs Don Box, Jeff Pinkston FT34 Microsoft Project Code Name "M": The Data and Modeling Language Gert Drapers, Kim Cameron SVC28 The "M"- Based System.Identity Model for Accessing Directory Services

Slide 13


Slide 14

YOUR FEEDBACK IS IMPORTANT TO US! If you don't mind round out session assessment frames online at

Slide 15

Learn More On Channel 9 Expand your PDC encounter through Channel 9 Explore recordings, hands-on labs, test code and demos through the new Channel 9 instructional classes Built by Developers for Developers… .