1 / 17

Juneau: Empowering Developers with SQL Server Developer Tools

Join William Brander for a Level 300 session introducing Project Codename “Juneau,” focusing on its capabilities, deployment, and database projects. Explore the tools and features, with demos and insights developer-focused. Learn about connected and offline development, schema-based files, and more in SQL Server Developer Tools. Discover how Juneau addresses database development challenges and improves productivity.

meadow
Download Presentation

Juneau: Empowering Developers with SQL Server Developer Tools

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. 17-20 OCTOBER 2011 DURBAN ICC

  2. What code-database gap? Introducing Project Codename “Juneau” William Brander @WilliamBZA http://WilliamB.Net william@williamb.net

  3. What to expect • Level 300 session • Not explaining the concepts • Overview • Looking at capabilities • Demo centric • Developer focused

  4. What we’re covering • Juneau overview • Database Projects • Deployment

  5. What we’re NOT covering • Just about everything else • Juneau is pretty big! • Licensing • Comparison with previous/other tools

  6. SQL Server Developer Tools SSDT Database Services Analysis Services Reporting Services Integration Services SQL Server Explorer SQL Server Explorer Static Analysis Static Analysis Database Publish Database Publish T-SQL Language Services T-SQL Language Services Buffered Declarative Editing Buffered Declarative Editing Table Designer Table Designer Schema Compare Schema Compare Local Database Runtime Local Database Runtime T-SQL Debugging T-SQL Debugging SQL/CLR SQL/CLR

  7. Why is DB dev hard? AZURE • Versioning • Dependencies • Errors discovered late • Production Drift • Triggers? • Views? • Stored procs? • UDFs? App V2 App V3 2008 App 2005?

  8. Demo • Connected Development

  9. Connected Development • SSMS-like experience • Dependency checking • Model-based designer • F5 Debugging

  10. Demo • Offline Development

  11. Offline Development • Schema-based Files • VS Tool Integration • Local Database Runtime

  12. Demo • Publishing

  13. Publishing • Target aware • Publish Options • Direct • Script • DAC • Offline and connected SQL Azure development

  14. Demo • Drift Detection

  15. Drift Detection • Flexible Compare • Projects • Databases • Snapshots

  16. </Slides> 18:30 – 20:30 William Brander @WilliamBZA http://WilliamB.Net william@williamb.net

  17. http://microsoftvirtualacademy.com Submit your session evaluation for a chance to win! Sponsored by MVA

More Related