Speaker

Ajay Jagannathan

Ajay Jagannathan

Principal Group Program Manager

Actions

Ajay Jagannathan is a Principal Group Program Manager for SQL Server and hybrid data services, based in Redmond. He has an MS in Computer Science and over 25 years of industry experience. He is currently responsible for driving product strategy and roadmap for SQL Server and Arc Data Services to deliver breakthrough innovations and product experiences from inception to engaged customer usage that modernize database to handle the speed, variety and scale of today's data. He partners closely with several customers to understand product usage and feedback to drive improvements in the product. He has deep experience in various features of SQL database engine spanning over several versions of SQL Server starting with 6.5 as well as Azure SQL.

Making the SQL Query Processor Work for you

In this session we will do a deep dive into hot topics such as: how to see and leverage maximum benefit from the Intelligent Query Processing suite of features, a demonstration of these features working with query store,  how to configure and set up query store to work well for you (even on secondary replicas), and finally “What does DB Combability really mean?"

Data tiering using data Virtualization in SQL

Do you have a need to either connect to or export data outside SQL Server or Azure SQL? In this session, you will learn how you can connect SQL Server 2022 and Azure SQL to external data, work with CSV, Parquet, Delta, leverage SQL metadata functions and procedures to help with schema discovery and search capabilities. Understand how Create External Tables (CET) and Create External Table as Select (CETAS) can be used to create your very own data tiering solution following best practices to offload your read-only data and reduce database maintenance time.

Achieve peak performance and availability for your SQL Server and Azure SQL workloads with core engi

"Learn how the mission-critical capabilities in SQL’s core database engine powers SQL Server and Azure SQL to help your workloads achieve unparalleled availability, scalability and leading performance, addressing some of the most common challenges for data professionals.
In this session we will focus on many of the core engine improvements with enhancements to SQL’s scalability for systems with large memory and processing power as well as contained availability groups, accelerated database recovery, T-SQL snapshot backup, Intel QuickAssist Technology (QAT) backup compression "

Hidden Gems in SQL Server 2022 Database Engine

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 - the most Azure-enabled SQL Server yet

SQL Server 2022 is the most Azure-enabled release of SQL Server yet, and is a core element of the Microsoft Intelligent Data Platform. The platform seamlessly integrates operational databases, analytics, and data governance. You will learn how to integrate various Azure services right from your SQL Server whether to achieve managed disaster recovery using Managed Instance, protect and govern your SQL Server estate using Microsoft Purview and Defender, use Azure AAD for modern authentication as well as near real-time analytics using Synapse Link.

Next Level Scalability on SQL Server 2022

Learn how the mission-critical capabilities in SQL Server 2022 can help your workloads achieve unparalleled scalability and leading performance, addressing some of the most common challenges for data professionals.
In this session we will focus on many of the storage improvements with advances in capacity management and maintenance, and enhancements to SQL Server scalability for systems with large memory and processing power. The storage engine features and capabilities we will highlight are tempdb improvements, buffer pool parallel scan, columnstore indexing, and other engine improvements."

Analytics in SQL Server and Azure SQL Database

You already know that SQL Server and Azure SQL Database are great relational databases for backing your applications, but did you know that there are a wide array of features to enable analytical, HTAP and Translytical workloads?  We’ll go into the virtualization capabilities, indexing options, and multi-model support – as well as how to leverage your HA/DR implementation to offload analytics queries.  And who knows, we might even touch on the new Synapse Link functionality!

Ajay Jagannathan

Principal Group Program Manager

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top