dev207. ssdt database services database services analysis services reporting services integration...
TRANSCRIPT
![Page 1: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/1.jpg)
Database Development with SQL Server Developer Tools codename “Juneau”
Bill GibsonPrincipal PM ArchitectMicrosoft
DEV207
Mark Wilson-ThomasProgram ManagerMicrosoft
![Page 2: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/2.jpg)
Developing Databases is Hard!
Need to preserve data puts focus on ALTER scriptsDependencies make even simple tasks complexErrors detected lateDrift has to be accommodatedHard to synchronize app and database versionsTarget different editions, cloud
![Page 3: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/3.jpg)
There is a Better Way…
Declarative not scriptedModel-based design and validationSame tools when connected or offlineUse schema differencing for
Incremental import and deployment Drift detection and reconciliation
Schema and app under source code controlTest locally, deploy to SQL Server or SQL Azure
![Page 4: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/4.jpg)
SQL Server Developer Tools code-named “Juneau”
SSDT
DatabaseServices
Analysis Services
Reporting Services
Integration Services
![Page 5: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/5.jpg)
SSDT Database Services
DatabaseServices
Analysis Services
T-SQLLanguageServices
T-SQLDebugging
SQL ServerExplorer
DatabasePublish
TableDesigner
Buffered Declarative
Editing
SQL/CLRSchema Compare
StaticAnalysis
LocalDatabase Runtime
Reporting Services
Integration Services
SSDT
![Page 6: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/6.jpg)
Demos…
Connected DevelopmentOffline DevelopmentPublish to SQL AzureDrift Detection and Snapshots
![Page 7: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/7.jpg)
demo
Connected Development
![Page 8: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/8.jpg)
Connected Development
SSMS-like explorer, query windowBuffered declarative approachModel-based with error detectionCode-backed designerModern TSQL coding experience
![Page 9: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/9.jpg)
demo
Offline Development Working with Visual Studio Database Projects
![Page 10: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/10.jpg)
Offline Development
Database definition managed in Visual Studio
Advanced language services (Go To Definition, Find All References, Refactoring…)
F5 debugging with new Local Database Runtime
Visualize and migrate schema changes
![Page 11: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/11.jpg)
demo
Publish to SQL Azure
![Page 12: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/12.jpg)
Publish to SQL Azure
Target-aware (SQL Azure)
Publish direct, via script, or DAC
Offline and connected development for SQL Azure
![Page 13: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/13.jpg)
demo
Drift Detection and Snapshots
![Page 14: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/14.jpg)
Drift Detection and Snapshots
Synchronize project to database drift
Using snapshots for lifecycle management
![Page 15: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/15.jpg)
SSDT Availability
With SQL Server “Denali”
On the web
With Visual Studio vNext
![Page 16: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/16.jpg)
Post-“Denali” Directions
SQL Azure features supported as they emergeApplication/database development integrationOn the horizon
Reference data supportDatabase diagrams Query designer
![Page 17: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/17.jpg)
There is a better way…
SSDT Database ServicesDeclarative, model basedIntegrated tools with modern language services Connected, and offline with local testingTarget SQL Server and SQL Azure
![Page 18: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/18.jpg)
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 [email protected]@microsoft.com
SQL Server Developer ToolsCodename “Juneau”
![Page 19: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/19.jpg)
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.aspxhttp://www.facebook.com/visualstudio
![Page 20: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/20.jpg)
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.
![Page 21: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/21.jpg)
Complete an evaluation on CommNet and enter to win!
![Page 22: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/22.jpg)
Scan the Tag to evaluate this session now on myTech•Ed Mobile
![Page 23: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/23.jpg)
© 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.
![Page 24: DEV207. SSDT Database Services Database Services Analysis Services Reporting Services Integration Services](https://reader036.vdocuments.us/reader036/viewer/2022062321/56649da25503460f94a8fa76/html5/thumbnails/24.jpg)