Overview
-
Get up to speed with all of the exciting new features available in Microsoft SQL Server 2017, and learn about SQL Server on Linux.
Syllabus
-
Introduction
- Welcome
- Tools and techniques
- New features: SQL Server 2017 overview
- Introduction to SQL Graph
- Querying with SQL Graph
- Tuning SQL Graph queries
- Temporal data enhancements
- String functions in SQL 2017
- Bulk insert using Azure Blob Storage
- Introduction to adaptive query processing
- Batch mode adaptive joins
- Batch mode memory grant feedback
- Interleaved execution
- Parameter sniffing overview
- Automatic tuning
- Introduction to SQL Server on Linux
- Getting started with Docker containers and SQL
- SQL Server on Linux development
- Deploying CLR code with SQL Server on Linux
- Command-line tools on Linux
- SQL Server Agent on Linux
- Getting started with SQL Operations Studio
- Using snippets
- Code deployment using GIT
- Next steps
