Learning SQL Server Development on Linux

Get up to speed with all of the exciting new features available in Microsoft SQL Server 2017, and learn about SQL Server on Linux.

Introduction

• Welcome
• Tools and techniques

1. New Features Overview

• 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

2. Adaptive Query Processing

• Introduction to adaptive query processing
• Batch mode adaptive joins
• Batch mode memory grant feedback
• Interleaved execution
• Parameter sniffing overview
• Automatic tuning

3. SQL Server on Linux

• 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

4. SQL Server Operations Studio

• Getting started with SQL Operations Studio
• Using snippets
• Code deployment using GIT

Conclusion

• Next steps