This all-day workshop on SQL Server on-prem and cloud platforms will provide coverage of a wide range of capabilities, including operational and analytical, on-premises and in the cloud. We’ll start by covering important development platform features, including T-SQL enhancements added in SQL Server 2022, machine learning services with R and Python, and temporal tables.

We’ll then move over to the world of analytics and data warehousing. We’ll start with a primer on foundational concepts, including columnar storage, massively parallel processing (MPP) and vector processing. Then we’ll get practical, starting with SQL Server analytics technologies, including columnstore indexes, batch mode and PolyBase. From there, we’ll transition smoothly over to Azure Synapse Analytics, the cloud data warehouse and data lake platform based on SQL Server, T-SQL and Apache Spark. And since Synapse integrates with Azure Data Factory, Azure Data Explorer and Power BI, we’ll have a look at those services – within Synapse Analytics – as well.

Next, we’ll hop back to the operational side and explore security features, starting with ledger tables. With ledger, SQL Server 2022 utilizes blockchain technology that hashes every transaction, and guarantees that none of your data has been tampered with. We’ll continue by examining dynamic data masking and row-level security. We’ll then dig into Always Encrypted and demonstrate how to leverage secure enclaves, enabling rich query over encrypted data in use.

You will learn:

• Coding tricks and tips, including T-SQL enhancements, and modern development platform for machine learning with R and Python
• All about operational analytics and data warehousing, on-premises and in the cloud
• Numerous ways to query your data lake, including PolyBase in SQL Server, as well as Serverless SQL Pools and Apache Spark in Azure Synapse Analytics
• SQL Server’s newest security features, including ledger tables, Dynamic Data Masking, Row Level Security, and Always Encrypted with secure enclaves