This course explores the new developer-centric SQL Server Data Tools introduced with SQL Server 2012, including advanced SSDT topics such as snapshots, schema compares, and database deployment to both on-premise and cloud-based servers. In addition to a deep exploration of SSDT, several enhancements to the T-SQL language in SQL Server 2008 and SQL Server 2012 are explored, including table-valued parameters (TVPs), MERGE, windowing, sequence objects, error handling and host of new built-in functions.
Leonard Lobel (Microsoft MVP, SQL Server) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner. Lenni is also a consultant, trainer, and frequent speaker at major industry conferences.
Advanced SSDT Features In Module 2, we resume our CustomerRanking scenario from Module 1. If you are to follow along, you'll need to have first completed Module 1 which means you've already connected through a SQL Server instance and created the SampleDb database. We organized a task list in Module 1 to implement some new requirements handed down by the Marketing Department. We also completed the first task on that list removing an unwanted column from a table while connected directly to the production database. In this module, we'll complete the remaining tasks on the list by first creating a Database Project in Visual Studio. Then, you'll see how to work with the LocalDb version of SQL Server for development in a disconnected offline fashion. How to debug stored procedures, run schema compares, and deploy to SQL Server instances running on-premises or in the cloud. ( Pause )