SQLBits 2023
SQL Server 2022 hidden gems
SQL Server 2022 has many new capabilities for the database engine across security, performance, and availability. In this demo-heavy session learn about new enhancements that you may not be familiar with that have real practical value. You will learn how these new features work and understand how they can solve real-world problems.
SQL Server 2022 has many new capabilities for the database engine across security, performance, and availability. In this demo-heavy session learn about new enhancements that you may not be familiar with that have real practical value. You will learn how these new features work and understand how they can solve real-world problems.
Speakers
Bob Ward's other proposed sessions for 2026
Inside SQL Server 2025 Part 1 - 2026
Inside SQL Server 2025 Part 2 - 2026
SQL Server Versioning Explained - 2026
Bob Ward's previous sessions
Welcome to the world of SQL Copilots
Microsoft is building a new experience of an AI companions called Copilot that are transforming how people work, write code, and solve problems faster. In this session come learn the latest innovations in SQL Copilot technology including GitHub Copilots for developing code and assisting with the T-SQL language. In addition you will get the latest look at Copilot technology to assist you in using and managing SQL in Azure. We will have plenty of demos in this session so come in and get ready to learn the new world of AI companions with SQL.
Come see your SQL Perfmon in the cloud
Come learn the latest innovations for monitoring technologies for SQL Server and Azure SQL
The Microsoft Data Leadership Panel
TBD
SQL Server and Windows Server Better together on Azure
Join us to learn how you can reap more technical and business benefits by running Windows Server and SQL Server on Azure. In this session you will get a first look at Windows Server vNext and innovative technologies for SQL Server including new monitoring and AI experiences.
Debugging SQL Server
Have you ever thought about how Microsoft uses the Windows Debugger with SQL Server? In this session I'll show you some advanced scenarios and how we debug SQL Server using a combination of the debugger along with instrumentation in the engine and other tools. This is an extremely deep level session and not for the feint of heart. You will get the best out of this session if you already have a solid understanding of the SQL Server engine.
The SQL Leadership Panel
Bring all your questions about the strategy and future of Microsoft SQL to the leadership team of Microsoft in a panel hosted by Bob Ward, Principal Architect at Microsoft
SQL Server 2022 and the Wheel of Power
Come learn about the latest major release of SQL Server and the "wheel of power" with capabilities across hybrid, built-in query intelligence, core database engine, data virtualization, and T-SQL. This is one of the most power-packed set of new capabilities in a SQL Server major version ever and this session is the one you will want to attend to learn about all of them.
SQL Server 2022 hidden gems
SQL Server 2022 has many new capabilities for the database engine across security, performance, and availability. In this demo-heavy session learn about new enhancements that you may not be familiar with that have real practical value. You will learn how these new features work and understand how they can solve real-world problems.
The Kingdom of AdventureWorks Calls for Aid
The Kingdom of Adventure works has been besieged by Monsters from the Cave of Despair – Can the able Party of Engineers save the Kingdom from the horrors of security attacks, degraded performance, stability and resiliency using the power of the Microsoft Intelligent Data Platform? Come to see how they battle the foe with data and analytics, and what the Campaign holds for our trustworthy band of heroes!
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!
Introducing SQL Server 2022
SQL Server 2022 is here! In this session, I’ll go over all the new capabilities in SQL Server 2022 including how to connect with Azure for disaster recovery, near real-time analytics, and security. I will show you innovations in the database engine for security, performance, and availability including SQL Server Ledger and Intelligent Query Processing.
How to Build Secure, Scalable, and Highly Available Applications with Azure SQL Database
This session will show you how to develop your code with .Net and C# using the latest Microsoft tools to launch quickly in the cloud while ensuring you meet the requirements of security, performance, and availability of your application. You will learn how to ensure your application is optimized with Azure SQL Database including Serverless and Hyperscale tiers, Azure Active Directory, retry and error handling, connection abstraction, automated indexing, and Intelligent Query Processing.
SQL Server 2022: The hybrid data platform
SQL Server has included capabilities to connect to the cloud for years. SQL Server 2022 moves hybrid to the next level with features to connect you to Azure for disaster recovery, near real-time analytics, and security. Come take a deep dive in this session for all the existing and new hybrid capabilities of SQL Server. See how to easily setup a managed disaster recovery site in the cloud with Azure SQL Managed Instance.
AMA with the Microsoft Engineering team hosted by Bob Ward
Come get your questions answered live on stage by members of the Microsoft engineering team. This will be a fun and interactive session hosted by Bob Ward. We will take questions live from the audience plus those who are connected virtually.
SQL Server 2019: The Modern Data Platform
SQL Server 2019 represents the next evolution of the leading database platform in the industry. In this session, we will cover the complete set of features and capabilities in SQL Server 2019.
Inside SQL Server on Kubernetes
In this session, we will dive deep into the Kubernetes platform and how SQL Server containers can be deployed, managed, and configured. This session assumes a fundamental knowledge of both SQL Server and containers.
SQL Server to Azure SQL: Performance and Availability
Translate your existing SQL Server performance and availability skills and apply them to Azure SQL.
Inside SQL Server 2019
Come learn all the new capabilities of SQL Server 2019 directly from the Microsoft engineering team. This session will provide the strategy behind SQL Server 2019 as well as a deep dive into all the new features and how they can help you modernize your data estate with SQL Server.
Inside SQL Server Containers
Containers are the new virtual machines. They present a new way to deploy, manage, and run SQL Server never possible before. This session will present an internal view of how Docker containers work, how SQL Server runs in them, and how they work in environments such as Kubernetes
Inside SQL Server 2019 Polybase
SQL Server 2019 expands on the Polybase feature from SQL Server 2019 by providing a robust data virtualization solution to reduce the need for ETL and data movement. Come learn how new data connectors work with sources like Oracle, MongoDB, CosmosDB, Terradata, and HDFS.
Experience SQL Server on Linux and Containers
SQL Server 2017 is all about choice. Choice for developers to run on Windows, Linux, or Containers. In this session we will show you the experience of running SQL Server on Linux and Containers including a behind the scenes of how we built it.
Experience SQL Server 2017: The Modern Database Platform
Looking to upgrade your SQL Server? This session will discuss all the new features and capabilities of SQL Server 2017 including SQL Server on Linux, Docker Containers, Graph Database, Python, Adaptive Query Processing, Automatic Tuning, and HADR.
Adaptive query processing in SQL databases
Come learn about the new adaptive query processor in SQL Server 2017 and Azure SQL Database. We will discuss how this feature works, how it can benefit your application and queries, and the future of intelligent query processing.
SQL Server 2016 It Just Runs Faster
Come take a deep dive and behind the scenes look at why SQL Server 2016 "Just Runs Faster" with little or no application changes.
Keep Your Environment Always On with SQL Server 2016
The Microsoft Tiger team will showcase the environments that help you keep your environment Always On
Deploying SQL Server with Microsoft Azure Virtual Machine
Many customers are looking toward Cloud technologies to reduce operational and capital expenditures. A popular choices today for SQL Server customers is to deploy in the Microsoft Azure Virtual Machine environment. Come to this session and learn how
Windows Azure SQL Database Troubleshooting
While knowledge of SQL Server troubleshooting still applies to the Windows Azure SQL Database service, there are new and different features, methods, and tools that are unique to cloud database computing. Come learn about these new techniques.