22-25 April 2026 
Enhancements that will make your SQL engine roar #1
2016TL; DR
Do you have an application running with an in-market version of SQL Server, such as 2012 or 2014? Then this session is for you!
We will see more in-depth what enhancements are in the latest SPs and 2016, and why you should install them.
Session Details
Do you have an application running with an in-market version of SQL Server, such as 2012 or 2014? Then this session is for you!
Microsoft is well aware of the number of customers betting their business on current versions of SQL Server, and that we need to add value to your already existing SQL Servers.
Rather than waiting for v.next for critical feature completeness, performance, supportability and hardware adoption improvements, we have been seeking to provide enhancements for in-market releases.
The latest result of these continued effort shines through in SQL Server 2012 SP3, and even more so with the upcoming SQL Server 2014 SP2.
This session will showcase several improvements in the Database Engine for SQL Server 2012 through 2016, that address some of the most common customer pain points involving tempdb, new CE, memory management, partitioning, alter column as well as diagnostics for troubleshooting query plans, memory grants, and backup/restore.
Come see this demo filled session to understand these changes in performance and scale of the database engine, new and improved diagnostics for faster troubleshooting and mitigation.
Learn how you can use these features to entice your customers to upgrade and run SQL Server workloads with screaming performance.
Objectives:
1. Learn about performance, scale and diagnostics enhancements in SQL Server database engine.
2. Evangelize these enhancements to get an out-of-box performance.
3. With this, understand how your experience with SQL Server will improve, and why you should install the latest and greatest Service Packs
Microsoft is well aware of the number of customers betting their business on current versions of SQL Server, and that we need to add value to your already existing SQL Servers.
Rather than waiting for v.next for critical feature completeness, performance, supportability and hardware adoption improvements, we have been seeking to provide enhancements for in-market releases.
The latest result of these continued effort shines through in SQL Server 2012 SP3, and even more so with the upcoming SQL Server 2014 SP2.
This session will showcase several improvements in the Database Engine for SQL Server 2012 through 2016, that address some of the most common customer pain points involving tempdb, new CE, memory management, partitioning, alter column as well as diagnostics for troubleshooting query plans, memory grants, and backup/restore.
Come see this demo filled session to understand these changes in performance and scale of the database engine, new and improved diagnostics for faster troubleshooting and mitigation.
Learn how you can use these features to entice your customers to upgrade and run SQL Server workloads with screaming performance.
Objectives:
1. Learn about performance, scale and diagnostics enhancements in SQL Server database engine.
2. Evangelize these enhancements to get an out-of-box performance.
3. With this, understand how your experience with SQL Server will improve, and why you should install the latest and greatest Service Packs
3 things you'll get out of this session
Speakers
Pedro Lopes's previous sessions
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.
Azure SQL and SQL Server: Path to an Intelligent Database
Come join us in the intelligent database world that started with SQL Server 2017 and takes a leap forward with the upcoming SQL Server 2019 and Azure SQL DB.
Query plans: a map to query performance analysis
This session is designed to guide you through what a query plan is and what information it holds to help you diagnose and understand how the code you write is actually executed by the Database Engine.
Storing strings in SQL Server and Azure SQL DB
in this session you will learn about what Unicode encoding you want to use for your scenario, what are the performance differences, and even debunk a few SQL Server myths along the way.
Modernizing your SQL Server the right way
Upgrades should be approached with the same rigor and processes as a full software or hardware project – a solid methodology is required for success. Microsoft provides you with all the tools you need to achieve a seamless, reliable upgrade experience. In this session we demonstrate some of the free tools that Microsoft provides in order to ensure your SQL Server upgrade is a success.
0 to Hero: Troubleshooting SQL Server Performance Made Easy
Take charge of any performance issue coming your way. "SQL Server is hurting!" Turn feelings to symptoms, and become the hero that saved the day.