SQLBits 2023
Next Level Availability on SQL Server 2022
Learn all about the availability improvements for the most cloud-enabled SQL Server 2022 release covering improvements that are available by default and new capabilities database administrators can enable giving way to a highly available and performant platform.
Learn how to take your availability strategy to the next level with even more availability and scale in SQL Server 2022. From the beginning, SQL Server has data protection and reliability as a core priority, as a result, Microsoft has a long history of innovation with data protection and availability strategies.
In this session we will focus on many of these improvements such as Distributed Availability Group improvements, the new Link feature in SQL Managed Instance, Availability Group performance and stability enhancements, Peer-to-Peer replication with Last Writer Wins (Write-Write replication), Contained Availability Groups, T-SQL Snapshot backup, and Accelerated Database Recovery (ADR).
Additionally, we will review SQL Server availability history, Disaster Recovery and High Availability concepts, and how to apply these concepts in SQL Server 2022.
In this session we will focus on many of these improvements such as Distributed Availability Group improvements, the new Link feature in SQL Managed Instance, Availability Group performance and stability enhancements, Peer-to-Peer replication with Last Writer Wins (Write-Write replication), Contained Availability Groups, T-SQL Snapshot backup, and Accelerated Database Recovery (ADR).
Additionally, we will review SQL Server availability history, Disaster Recovery and High Availability concepts, and how to apply these concepts in SQL Server 2022.
Speakers
David Pless's previous sessions
HADR on SQL Server on Azure VMs: Everything you Need to Know
Learn about all the options for building highly available SQL Servers in Azure Virtual Machines, including how you can go from zero to highly-available SQL Server in minutes with the SQL IaaS Agent extension!
SQL Server on Azure VM - Configuring for Price-Performance
Learn how you can boost your SQL Server performance in Azure Virtual Machines without breaking the bank. Hint - #DoubleSprinklesVMs
Next Level Scalability on SQL Server 2022
Learn all about the scalability improvements for the most cloud-enabled SQL Server 2022 release covering improvements that are available by default and new capabilities database administrators can enable giving way to a highly available and performant platform.
Next Level Availability on SQL Server 2022
Learn all about the availability improvements for the most cloud-enabled SQL Server 2022 release covering improvements that are available by default and new capabilities database administrators can enable giving way to a highly available and performant platform.
Built-in Intelligence with Azure SQL and SQL Server 2022
"Learn about the Intelligent query processing feature family such as improvements to memory grant feedback, degree of parallelism (DOP) feedback, parameter sensitive plan optimization, and more - that help business-critical workloads run at scale, without changing your application code.
We will cover the intelligent database feature family, the database compatibility levels, and troubleshooting with query store hints."
Platform Innovations with SQL Server 2022 + Intel
Get ready for a journey through the cutting-edge platform advancements in SQL Server 2022! In this must-attend session, our Microsoft and Intel subject matter experts will take you on a tour of the latest platform innovations, demonstrating the new capabilities and solutions that are driving the next generation of database administration. Discover how Intel technologies are powering the SQL Server experience and hear about the latest hardware advancements from Intel that are shaping the future of the platform space. We'll dive into the backup compression improvement enabled by SQL Server 2022 and Intel® QuickAssist Technology (QAT). You'll learn how this integration allows for offloading of compute overhead, reduction of CPU usage, improvement of backup completion times, and reduction of storage consumption. We will also discuss the latest Intel hardware and where we are going next with SQL Server and Intel technologies. We will also cover Intel AVX-512 (Advanced Vector Extensions 512-bit) technology designed to accelerate the performance certain computing tasks, allowing the processor to perform multiple operations in parallel. SQL Server 2022 can leverage AVX-512 instructions to improve the performance of certain query operations by offloading compute-intensive operations to the processor. By utilizing AVX-512, SQL Server can take advantage of the improved parallelism and faster performance offered by modern processors, providing customers with faster query execution times and improved overall performance by offloading some of the work from the CPU to the processor. Don't miss your chance to be at the forefront of the platform revolution and discover the latest advancements in SQL Server and Intel technologies!