Exploring SQL Server Tools and Language Enhancements

An introduction to SQL Server Data Tools (SSDT) and T-SQL enhancements.
Course info
Rating
(131)
Level
Intermediate
Updated
Dec 19, 2012
Duration
4h 13m
Table of contents
Course Introduction and Overview
Introducing SQL Server Data Tools (SSDT)
Advanced SSDT Features
Table-Valued Parameters (TVPs)
MERGE and INSERT OVER DML
Windowing and the OVER Clause
Additional T-SQL Language Enhancements
Description
Course info
Rating
(131)
Level
Intermediate
Updated
Dec 19, 2012
Duration
4h 13m
Description

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.

About the author
About the author

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.

More from the author
Learning Azure Cosmos DB
Intermediate
6h 6m
27 Apr 2018
SQL Server 2016 New Features for Developers
Intermediate
3h 42m
14 Oct 2016
Introduction to Azure DocumentDB
Beginner
5h 5m
23 Sep 2015
Section Introduction Transcripts
Section Introduction Transcripts

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 )