1 / 21

Microsoft SQL Server Data Tools: Database Development from Zero to Sixty

DBI311. Microsoft SQL Server Data Tools: Database Development from Zero to Sixty . Gert Drapers (@ DataDude ) Principal Group Program Manager Microsoft Corporation Sarah McDevitt Program Manager II Microsoft Corporation. Introducing SQL Server Data Tools. CONNECTED DEVELOPMENT.

abel
Download Presentation

Microsoft SQL Server Data Tools: Database Development from Zero to Sixty

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DBI311 Microsoft SQL Server Data Tools: Database Development from Zero to Sixty Gert Drapers (@DataDude) Principal Group Program Manager Microsoft Corporation Sarah McDevitt Program Manager II Microsoft Corporation

  2. Introducing SQL Server Data Tools CONNECTED DEVELOPMENT PROJECT BASED DEVELOPMENT SCHEMA DEPLOYMENT

  3. Connected Development Familiar User Experience Optimized Productivity Schema EditingTools Difference Detection SQL Server Object Explorer T-SQL IntelliSense Drift Detection Table Designer Schema Comparison T-SQL Debugging View Code T-SQL Editor View/Edit Data Error Information

  4. demo Connected Development Sarah McDevitt Program Manager II Microsoft Corporation

  5. Connected Development Familiar User Experience Optimized Productivity Schema EditingTools Difference Detection SQL Server Object Explorer T-SQL IntelliSense Drift Detection Table Designer Schema Comparison T-SQL Debugging View Code T-SQL Editor View/Edit Data Error Information

  6. Project Based Development 1st class T-SQL Support Isolated Integrated Schema Insight Go To Definition Source Code Based Source Code Control Point-in-time Snapshots Find All References F5 Debugging & Testing with LocalDB MSBuild Visualize Schema Differences Refactoring Headless Command Line Tools T-SQL Static Code Analysis

  7. demo Project Based Development Sarah McDevitt Program Manager II Microsoft Corporation

  8. Project Based Development 1st class T-SQL Support Isolated Integrated Schema Insight Go To Definition Source Code Based Source Code Control Point-in-time Snapshots Find All References F5 Debugging & Testing with LocalDB MSBuild Visualize Schema Differences Refactoring Headless Command Line Tools T-SQL Static Code Analysis

  9. Schema Deployment Multi-Targeting Standard Formats DAC Declarative Model Based SQL Server 2005 SQL Server 2008 SQL Server 2012 SQL Azure DACPAC Format Incremental Schema Deployment Connected Engine Retargeting Support SQL Script API & REDIST

  10. demo Schema Deployment Sarah McDevitt Program Manager II Microsoft Corporation

  11. Schema Deployment Multi-Targeting Standard Formats DAC Declarative Model Based SQL Server 2005 SQL Server 2008 SQL Server 2012 SQL Azure DACPAC Format Incremental Schema Deployment Connected Engine Retargeting Support SQL Script API & REDIST

  12. SQL Azure Management Portal Import Export Register Unregister Publish Compare Sync DAC SQL Server Management Studio SQL Server Data Tools

  13. demo Command Line Operations Sarah McDevitt Program Manager II Microsoft Corporation

  14. CONNECTED DEVELOPMENT Familiar User Experience Optimized Productivity Schema EditingTools Difference Detection 1st class T-SQL Support Isolated Integrated Schema Insight Multi-Targeting Standard Formats DAC Declarative PROJECT BASED DEVELOPMENT SCHEMA DEPLOYMENT

  15. Resources • SQL Server Data Tools Online Installation • http://msdn.microsoft.com/data/toolsGet It • Team Blog • http://blogs.msdn.com/b/ssdt/ • MSDN Forum • http://social.msdn.microsoft.com/Forums/en-US/ssdt/threads • Articles • MSDN Magazine Sept 2011 The "Juneau" Database Project

  16. Related Content • DBI309 - Exploring SQL Server Data Tier Applications DBI31-HOL - Getting Started with SQL Server Data Tools in SQL Server 2012 DBI07-TLC - SQL Server: Cloud on Your Terms - Optimized Productivity Find Me Later in the: Technical Learning Center (TLC) Find Me Later in the: Ask the Experts (ATE)

  17. DBI Track Resources @sqlserver @teched_europe #msTechEd SQL Server 2012 Eval Copy Hands-On Labs Get Certified! mva • Microsoft Virtual Academy

  18. Resources Learning TechNet • Connect. Share. Discuss. • Microsoft Certification & Training Resources http://europe.msteched.com www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers • http://microsoft.com/technet http://microsoft.com/msdn

  19. Evaluations Submit your evals online http://europe.msteched.com/sessions

  20. © 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, 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.

More Related