Level: Introductory to Intermediate
This three-hour workshop will get you up to speed on powerful new features in SQL Server 2019. Lenni will pull no punches as he rips through the most important SQL Server features for developers in this intensive demo-packed tour.
We'll kick things off with the broad multi-platform support across Windows, Linux, and Docker. Learn how SQL Server’s ability to run inside Docker containers on both Windows and Mac will revolutionize the way you work with Microsoft’s venerable database engine.
Then you'll explore all the latest Intelligent Query Processing (IQP) enhancements added in SQL Server 2019, which delivers groundbreaking performance improvements to the query engine. Next we’ll explore Always Encrypted, significantly enhanced in SQL Server 2019 with support for secure enclaves, to enable rich querying of encrypted data in use. We’ll wrap up with the latest PolyBase enhancements to query external data in Azure Blob Storage, Cosmos DB, Oracle, and other remote data sources.
You’ll learn a ton of new SQL Server features in this information-packed day!
- How to run SQL Server inside containers using Docker
- Intelligent Query Processing features and performance improvements
- Discover the newest security features in Always Encrypted with secure enclaves, and the latest data virtualization capabilities with PolyBase