SQLBits 2023

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!
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!