SQLBits 2024
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!
Configuring high availability and disaster recovery solutions can be complicated, especially with all the options available in Azure. If you're having trouble navigating all the different options for building a business continuity solution for your SQL Server in Azure, this is the session for you! In this session we will review the various technologies and services that you can leverage to build your highly available SQL Server, including things like Availability Groups, clusters, and even good old log shipping. Last but not least, we'll show off some of the great features in the SQL IaaS agent extension that can help you go from zero to highly-available SQL Server in minutes!
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!