Bill Gibson Principal PM Architect Microsoft DEV207 Mark WilsonThomas Program Manager Microsoft Developing Databases is Hard Need to preserve data puts focus on ALTER scripts Dependencies make even simple tasks complex ID: 717109
Download Presentation The PPT/PDF document "Database Development with SQL Server Dev..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Database Development with SQL Server Developer Tools codename “Juneau”
Bill GibsonPrincipal PM ArchitectMicrosoft
DEV207
Mark Wilson-Thomas
Program Manager
MicrosoftSlide2
Developing Databases is Hard!Need to preserve data puts focus on ALTER scripts
Dependencies make even simple tasks complexErrors detected lateDrift has to be accommodatedHard to synchronize app and database versionsTarget different editions, cloudSlide3
There is a Better Way…Declarative not scripted
Model-based design and validationSame tools when connected or offlineUse schema differencing forIncremental import and deployment Drift detection and reconciliation
Schema and app under source code controlTest locally, deploy to SQL Server or SQL AzureSlide4
SQL Server Developer Tools code-named “Juneau”
SSDT
Database
Services
Analysis
Services
Reporting Services
Integration ServicesSlide5
SSDT Database Services
Database
Services
Analysis
Services
T-SQL
Language
Services
T-SQL
Debugging
SQL Server
Explorer
Database
Publish
Table
Designer
Buffered Declarative Editing
SQL/CLR
Schema
Compare
Static
Analysis
Local
Database Runtime
Reporting Services
Integration Services
SSDTSlide6
Demos…Connected Development
Offline DevelopmentPublish to SQL AzureDrift Detection and SnapshotsSlide7
demoConnected Development Slide8
Connected DevelopmentSSMS-like explorer, query window
Buffered declarative approachModel-based with error detectionCode-backed designerModern TSQL coding experience Slide9
demoOffline Development
Working with Visual Studio Database ProjectsSlide10
Offline Development
Database definition managed in Visual StudioAdvanced language services (Go To Definition, Find All References, Refactoring…)
F5 debugging with new Local Database Runtime Visualize and migrate schema changesSlide11
demoPublish to SQL Azure Slide12
Publish to SQL Azure
Target-aware (SQL Azure)Publish direct, via script, or DACOffline and connected development for SQL AzureSlide13
demoDrift Detection and SnapshotsSlide14
Drift Detection and Snapshots
Synchronize project to database driftUsing snapshots for lifecycle managementSlide15
SSDT Availability
With SQL Server “Denali”On the webWith Visual Studio vNextSlide16
Post-“Denali” DirectionsSQL Azure features supported as they emerge
Application/database development integrationOn the horizonReference data supportDatabase diagrams Query designerSlide17
There is a better way…SSDT Database Services
Declarative, model basedIntegrated tools with modern language services Connected, and offline with local testingTarget SQL Server and SQL AzureSlide18
Resources
MSDN: http://msdn.microsoft.com/en-us/data/tools.aspx Forum:
http://social.msdn.microsoft.com/Forums/en-US/ssdt/threadsTeam Blog:
http://blogs.msdn.com/b/ssdt/
Contact
us
billgib@microsoft.com
mwthomas@microsoft.com
SQL Server Developer Tools
Codename “Juneau”Slide19
DEV Track Resources
http://www.microsoft.com/visualstudio http://www.microsoft.com/visualstudio/en-us/lightswitch http://www.microsoft.com/expression/
http://blogs.msdn.com/b/somasegar/http://blogs.msdn.com/b/bharry/
http://www.microsoft.com/sqlserver/en/us/default.aspx
http://www.facebook.com/visualstudio
Slide20
Resources
www.microsoft.com/teched
Sessions On-Demand & Community
Microsoft Certification & Training Resources
Resources for IT Professionals
Resources for Developers
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn
Learning
http://northamerica.msteched.com
Connect. Share. Discuss.Slide21
Complete an evaluation on
CommNet
and
enter to win!Slide22Slide23
©
2011 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.Slide24