All courses
Resource hub
Featured resource
Tech Upskilling Playbook 2025
Tech Upskilling Playbook

Build future-ready tech teams and hit key business milestones with seven proven plays from industry leaders.

Learn more
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

Exploring SQL Server Tools and Language Enhancements

An introduction to SQL Server Data Tools (SSDT) and T-SQL enhancements.

Leonard Lobel - Pluralsight course - Exploring SQL Server Tools and Language Enhancements
by Leonard Lobel
Get started

What you'll learn

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.

Table of contents

About the author

Leonard Lobel - Pluralsight course - Exploring SQL Server Tools and Language Enhancements
Leonard Lobel

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 Courses by Leonard