SQL SERVER DATA TOOLS Gert Drapers Data Dude

SQL SERVER DATA TOOLS Gert Drapers (@Data. Dude) Principal Group Program Manager SQL Server Data Platform This document has been prepared for limited distribution within Microsoft. This document contains materials and information that Microsoft considers confidential, proprietary, and significant for the protection of its business. The distribution of this document is limited to those solely involved with the program described within. Confidential and Proprietary © 2011 Microsoft Last Updated:

AGENDA • Why? • How! • What and when…

SQL DATABASE DEVELOPMENT IS HARD! • SQL database development challenges: • Databases are stateful entities in their very nature • Dependencies make managing and preserving the state even more challenging • Errors in SQL code are often found only when the code is executed • Synchronizing application and database versioning adds more layers of complexity • Targeting more than one version of SQL Server is very difficult to manage

IS THERE IS A BETTER WAY? • To overcome these challenges we must work smarter • Develop the database declaratively (CREATE), not imperatively (IF EXISTS (…) / ALTER ) • Bring validation and verification into design time • Use consistent tools when working connected or disconnected (Tools work on top of design time model) • Have Schema Model differencing capabilities at our disposal (Compare and Update Models) • Develop locally in a sandbox (isolated); publish changes off box (shared) • Bring application and database development into the same environment and source repository

INTRODUCING SQL SERVER DATA TOOLS Database Development Tools SQL Server Database Project SQL Server Object Explorer SQL Static Code Analysis Database Publishing SQL Language Services Buffered Declarative Editing Table Designer Schema Comparison Isolated Local Database Runtime SQL/CLR SQL Debugging

FOUNDATIONS OF SQL SERVER DATA TOOLS • Declarative, model based database development • Integrated tools with modern language services • Connected and offline with local testing • Target SQL Server and SQL Azure • Detecting and managing database drift

DEMO SQL Server Data Tools Connected / Online Development This document has been prepared for limited distribution within Microsoft. This document contains materials and information that Microsoft considers confidential, proprietary, and significant for the protection of its business. The distribution of this document is limited to those solely involved with the program described within. Confidential and Proprietary © 2011 Microsoft Last Updated:

CONNECTED DATABASE DEVELOPMENT • SQL Server Object Explorer • Rich SQL editing & debugging experience • T-SQL Intelli. Sense • Buffered Declarative Editing • Model-based with Error Detection • Code-behind based Table Designer • View/Edit/Script Data (incl. copy/paste)

DEMO SQL Server Data Tools Disconnected / Offline Development This document has been prepared for limited distribution within Microsoft. This document contains materials and information that Microsoft considers confidential, proprietary, and significant for the protection of its business. The distribution of this document is limited to those solely involved with the program described within. Confidential and Proprietary © 2011 Microsoft Last Updated:

DISCONNECTED DATABASE DEVELOPMENT • Database definitions managed in Visual Studio as source code artifacts • Advanced language services: • Go To Definition • Find All References • Refactoring • F 5 debugging with Local Database Runtime • Visualize schema differences & migrate schema changes • Synchronize project to database drift

DEMO SQL Server Data Tools Publishing your Database Changes This document has been prepared for limited distribution within Microsoft. This document contains materials and information that Microsoft considers confidential, proprietary, and significant for the protection of its business. The distribution of this document is limited to those solely involved with the program described within. Confidential and Proprietary © 2011 Microsoft Last Updated:

PUBLISHING YOUR DATABASE CHANGES • Target version aware: • SQL Server 2005 • SQL Server 2008 & SQL Server 2008 R 2 • SQL Server 2012 • SQL Azure • Publish • Direct, via SQL script, or DACPAC • Support for “Snapshots” • Persist point-in-time representation of the schema

SQL SERVER DATA TOOLS – SUMMARY • The standard SQL Server database development environment to: author, debug and publish complete database solutions • Ships with SQL Server 2012 o Hosted inside Visual Studio 2010 (Integrated shell+) • Supports SQL Server 2005 and higher & SQL Azure • Updated at the same cadence as SQL Azure • Online / offline install and update • Available for free as part of the SQL Server platform

SQL SERVER DATA TOOLS RESOURCES • MSDN • http: //social. msdn. microsoft. com/Forums/en-US/ssdt/threads • Team blog • http: //blogs. msdn. com/b/ssdt/ • Download the latest SSDT version • http: //msdn. microsoft. com/en-us/data/tools. aspx • MSDN Magazine Sept 2011 • The "Juneau" Database Project • Tech. Ed 2011 videos: • Build SQL Server databases using Juneau without leaving Visual Studio • Juneau Database Project integration with existing. NET applications via Entity Framework

FURTHER. FORWARD. FASTER. • Learn more Visit the Microsoft Virtual Academy Free technical SQL Server training courses • Get more Download SQL Server 2012 Trial Software 180 -day evaluation of SQL Server 2012 • Do more Participate in virtual launch activities and collect points for prizes The more points you earn, the bigger your prize could be

© 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U. S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.