1 / 18

Sofia Event Center 14-15 May 2014

Sofia Event Center 14-15 May 2014. Develop your database with Visual Studio. Ivan Donev Solution Designer | HP. Ivan Donev. www.mssqlinsider.com Twitter: ikdonev Linkedin : ivan.donev. The world before. The world before. SQLCMD Powershell Notepad  Excel SQL Express. SSMS. BIDS.

cicily
Download Presentation

Sofia Event Center 14-15 May 2014

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. Sofia Event Center 14-15 May 2014 Develop your database with Visual Studio Ivan Donev Solution Designer | HP

  2. Ivan Donev • www.mssqlinsider.com • Twitter: ikdonev • Linkedin: ivan.donev

  3. The world before

  4. The world before SQLCMD Powershell Notepad  Excel SQL Express SSMS BIDS

  5. SQL Server tooling today

  6. SQL Server Data Tools • Visual Studio based development • Single tool to support developer’s needs • No need for SSMS (almost ) • Free availability via Web Platform Installer • SQL Server Object Explorer • Build and debug with LocalDB • No more server-based installations of SQL Server • Support for SQL Server 2014 added

  7. Development framework Visual Studio + DACFx Project Based Development Connected Development Schema Deployment SQL Server Object Explorer Schema Comparison Source Code Control F5 with LocalDB T-SQL Editing and Debugging Project Publish Script Generation Table Designer Multi-Targeting View/Edit Data Go To Definition/Find All References Packaging and Deployment Errors and Validation SqlPackage.exe Refactoring and Intellisense MSBuild Extensibility Data Comparison

  8. Multi-mode table editor • GUI window • T-SQL window • Property window

  9. Platform Targeting • Target multiple platforms • SQL Server versions • SQL Azure • Project build provides • errors/warnings • Specific to target • No need to create and execute scripts to find issues

  10. SQL Server LocalDB • Created specifically for developers • Uses the same sqlservr.exe process • Lighter SQL Express • Richer functionality than Compact • No installation and management overhead

  11. Schema and data comparison • Key Scenarios • Selective comparison and update of reference/seed data • Preparation of development or testing environments • Support for all data types • SQL Server 2005, 2008/R2, 2012, 2014, Azure DB • Data generation not planned

  12. CLICK TIME

  13. What about Business Intelligence • SSDT – Business Intelligence • Still out-of-the-box • Be careful with SSIS

  14. Integration with Windows Azure Tools SDK • New Windows Azure Node in Server Explorer • Link Server Explorer node to Windows Azure subscriptions • Browse/navigate Windows Azure assets • Launch points for key development/management tasks

  15. SSDT/Visual Studio SKU support

  16. Summary • In-the-box Database Development • Improved Cloud integration • SSDT-BI is still an additional product • SQL Server 2014 support (soon ) • Hekaton and PolyBase support • All your development in a single tool

  17. Questions??? Share your feedback for this particular session and for the overall conference experience at http://aka.ms/intouch for a chance to win our prizes!

  18. Resources • SQL Server 2014 Developer training kit • http://www.microsoft.com/en-us/download/details.aspx?id=41704 • Microsoft SQL Server Data tools • http://msdn.microsoft.com/en-us/data/tools.aspx • VS and SSDT versions • http://blogs.msdn.com/b/ssdt/archive/2014/01/31/ssdt-and-visual-studio-versions.aspx • SQL Server Express vs. Compact vs. LocalDB • http://blogs.msdn.com/b/jerrynixon/archive/2012/02/26/sql-express-v-localdb-v-sql-compact-edition.aspx

More Related