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 and machine learning services with R and Python. We'll then explore the brand-new Data API Builder to instantaneously create both REST and GraphQL endpoints over your database tables, views, and stored procedures – with full support for OAuth2/JWT authentication, role-based authorization, and item-level security.
With that foundation nailed down, we'll move on to the world of analytics, looking at the components most relevant to SQL Server. We'll spend a good deal of time with Microsoft Fabric, and see how we can query the data warehouse, build and explore the data lakehouse and perform real predictive analytics using nothing more than T-SQL. We'll also look at adjacent parts of Fabric, including Power BI, Apache Spark, data pipelines and dataflows. Then, back in the world of SQL Server itself, we'll see how to use batch mode, colummnstore indexes, data virtualization and the T-SQL PREDICT command to do many of the same tasks.
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, machine learning with R and Python, and database endpoints with the new Data API Builder
- The SQL Server-relevant parts of Microsoft Fabric, and the analytics-relevant parts of SQL Server
- How T-SQL makes it predictive analytics easy, both on-premises and in the cloud
- SQL Server's newest security features, including ledger tables, Dynamic Data Masking, Row Level Security, and Always Encrypted with secure enclaves