Episode
SQL Server 2022: Security, scalability, availability (Ep. 4) | Data Exposed
with Anna Hoffman, Bob Ward
SQL Server 2022 brings more security to the database rated as least vulnerable over the last ten years with always encrypted enhancements and SQL Ledger, an immutable ledger to track evidence of tampering. Additional Azure-enabled features including Microsoft Defender for Cloud Integration, Microsoft Purview, and Azure Active Directory authentication add even more layers of protection and access control. Learn all this and more on this episode of Data Exposed with Anna Hoffman and Bob Ward.
Chapters
- 00:00 - Introduction
- 01:17 - Industry-proven database engine
- 02:00 - Industry-proven database engine innovations
- 02:24 - Ledger for SQL Server
- 04:12 - "Hands-free" tempdb
- 04:58 - Demo
- 10:50 - Summary
Recommended resources
- Improve scalability with Buffer Pool Parallel Scan in SQL Server 2022
- Improve scalability with system page latch concurrency enhancements in SQL Server 2022
- Ledger now generally available in Azure SQL Database
- Learn more about SQL Server 2022
- Download SQL Server 2022
- Get our decks
- What's new for SQL Server 2022
- Read the book
- Try out the workshop
- Try our demos
- Watch Microsoft Mechanics
- Read the SQL Server 2022 Blog Series
- Take the Microsoft Learning Path
Related episodes
SQL Server 2022 brings more security to the database rated as least vulnerable over the last ten years with always encrypted enhancements and SQL Ledger, an immutable ledger to track evidence of tampering. Additional Azure-enabled features including Microsoft Defender for Cloud Integration, Microsoft Purview, and Azure Active Directory authentication add even more layers of protection and access control. Learn all this and more on this episode of Data Exposed with Anna Hoffman and Bob Ward.
Chapters
- 00:00 - Introduction
- 01:17 - Industry-proven database engine
- 02:00 - Industry-proven database engine innovations
- 02:24 - Ledger for SQL Server
- 04:12 - "Hands-free" tempdb
- 04:58 - Demo
- 10:50 - Summary
Recommended resources
- Improve scalability with Buffer Pool Parallel Scan in SQL Server 2022
- Improve scalability with system page latch concurrency enhancements in SQL Server 2022
- Ledger now generally available in Azure SQL Database
- Learn more about SQL Server 2022
- Download SQL Server 2022
- Get our decks
- What's new for SQL Server 2022
- Read the book
- Try out the workshop
- Try our demos
- Watch Microsoft Mechanics
- Read the SQL Server 2022 Blog Series
- Take the Microsoft Learning Path
Related episodes
Have feedback? Submit an issue here.