Ask the Expert - Group A (Thurs 13:40 to 14:00)

SQL Server 2022 Performance Enhancements

In this session we are going to look at the performance enhancements in SQL Server 2022. We will cover the most important enhancements in the optimizer (intelligent query processing), storage engine, Accelerated Database Recovery, availability groups, Query Store, stack dumps and some more. Which problems are the features solving? How are they doing it? I will share some real-world experiences of the features, from running SQL Server 2022 on mission-critical databases.

Performance Monitoring Using Extended Events, DMVs & Query S

Extended Events, Dynamic Management Views, and Query Store are powerful and lightweight tools. In this session you will learn techniques for combining the data from these tools, to gain great insight, when analyzing performance problems.

Inside Ola Hallengrens Maintenance Solution

In this session I will talk about backup, integrity check, and index and statistics maintenance, and how you can use my maintenance solution (http://ola.hallengren.com) in an enterprise environment.

Inside Ola Hallengrens Maintenance Solution

How do you do database maintenance in an enterprise environment? In this session I will go through how you can do backup, integrity check, index and statistics maintenance using Ola Hallengren's Maintenance Solution.

From DevOps for data to DataOps

In practice, DataOps is not as common for data & analytics as DevOps is for software engineering. For the latter, Development and Operations are jointly responsible for developing a system, deploying it and maintaining the system. With the aim of delivering faster, being more agile and creating maximum business value. This is where DataOps is the same as DevOps: the objective is similar. But ‘How’ we do this, differs considerably.

Thriving with ADHD in Tech: Unleashing the Data Analyst Superpowers Within

Learn how to leverage ADHD as a distinct advantage in the tech domain, specifically as a data analyst. This session dives deep into the inherent strengths of ADHD individuals, offering actionable strategies to amplify productivity and navigate challenges. Topics include optimizing the ADHD attributes of creativity and hyperfocus for data tasks, crafting an ADHD-conducive workspace, mastering time management, enhancing team communication, and emphasizing mindfulness for career longevity. By the conclusion, attendees will have a comprehensive toolkit to harness their unique ADHD attributes and flourish in the tech landscape.

Supercharge Power BI Tooltips

Discover secrets of tooltip design in Power BI. Learn how to upgrade your tooltips with DAX, add dynamic charts to report page tooltips, and add design elements to information/help tooltips.

Beyond Buttons: More Than Meets The Eye

In this presentation you'll see many unique and creative ways to implement both both bookmarks and buttons to supercharge the filter and navigation experience for your users.

Return ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DR

The demo showcases new capabilities of setting up hybrid link from SQL Managed Instance to SQL Server 2022, reverse migrating online, setting up transparent connection routing, and more. You can decide if your primary is either Azure SQL Managed Instance or SQL Server. Use it a Disaster Recovery solution, or for offloading R/O workloads on the secondary. Learn how to take advantage of the best integrated hybrid experience between SQL Server and SQL Managed Instance.

Discover what's new in Azure SQL Managed Instance through an exciting Demo Party!

Let us review the latest and the greatest investment that Microsoft has made into the Azure SQL Managed Instance, the product that serve as the best target for the existing SQL Server migration into Azure PaaS. 

Advancing the DBA's Role in the Cloud: In the Cockpit of Azure SQL Managed Instance

Join us to learn how DBA role has evolved from on-premises SQL Server DBA to Azure SQL DBA and what does it mean to you. You will learn how existing on-premises DBA responsibilities map to new DBA role in Azure, what are the new shared responsibilities in Azure, and opportunities for skill development helping you become Azure SQL DBA superstar.

Modern models of managing database fleets in Azure PaaS.

Discover how Azure PaaS offerings can help you improve the overall management of SaaS applications, virtualize your environment and improve the overall management of the solutions at scale.

Azure SQL MI End-to-end Demo Party for DBAs and Devs

Join us for a pure, demo-driven journey of a dozen incredible features for Azure SQL Managed Instance showing you the greatest and latest innovations enabling Database Administrators and Developers to achieve more. Whether you’re a DBA, Azure Administrator, Developer, Business Intelligence developer, or of course any other data professional, these demos will show how you can achieve more with the exciting features that are available to you. Some of the topics we will cover are hybrid scenarios, performance and scale, application compatibility, workload modernization, compliance, data mobility/migration & business continuity/disaster recovery - and several more - in this fast-paced, demo-only session.

The Ultimate Freedom of Movement with SQL Server 2022 and Azure SQL Managed Instance

In this session we’ll deep-dive into the link feature, a revolutionary new hybrid capability bridging the SQL Server and Managed Instance that provides the ultimate freedom of movement between the two. The feature provides never-before possible hybrid connectivity and near real-time database replication between SQL Servers 2016-2022 and Managed Instance, including industry’s first bidirectional data movement and online failover (Disaster Recovery) between SQL Server 2022 and SQL Managed Instance. You don’t even need to migrate to the cloud to use it – remain running on your existing SQL Server and use the modern Azure services by offloading R/O workloads and analytics to the cloud. When ready to migrate, use it as the best possible minimum downtime migration option in Azure. Need to move back from Azure to SQL Server on-premises, or anywhere else? No problem, use it all in reverse and replicate your online and near real-time from Managed Instance back to SQL Server 2022.

There and back again: SQL Server 2022 <-> Managed Instance

In just 20 minutes you will see a demo of bidirectional database failover between SQL Server 2022 and Managed Instance, using the link feature. The feature provides never-before possible hybrid connectivity and near real-time database replication between SQL Servers 2016-2022 and Managed Instance, including industry’s first bidirectional data movement and online failover (Disaster Recovery) between SQL Server 2022 and SQL Managed Instance Need to move back from Azure to SQL Server on-premises, or anywhere else? No problem, use it all in reverse and replicate your online and near real-time from Managed Instance back to SQL Server 2022.

10 Cool Things about SQL MI

In just 20 minutes We are going to entertain you with 10 cool things about Azure SQL Managed Instance that you might not know, but that can be extremely useful

Accessibility is for everyone, including you!

In this eye-opening and tongue-in-cheek talk, I'll not only show you ways we, the handicapped people actually helped you!

From stone age to data-driven tech for ears: a time travel

Travelling through time for ears and accessibility, and giving better talks for everyone!

Mastering Power BI Design with User-Centric Frameworks

Key to Power BI report success and user adoption is a deep understanding of the consumer. This session will explore essential tools and strategies that enable you to gain valuable insights into your audience's information and experience needs. From this, the presenter will delve into practical techniques for shaping and crafting a compelling data story or data application for your audience.

Contextualizing timeseries data with graphs

Discover the power of graphs in Kusto, the scalable database engine for Azure Data Explorer, and how to create and query them with a simple and intuitive syntax

Scale your business in real-time using ML in Microsoft Fabric Real-time Analytics

Technical deep-dive session on using Machine Learning on real-time data to scale your business operations

Fabric Power Hour

The famous Power BI Power Hour returns, but this time it has expanded to cover the whole of Fabric!

The What and the Why of Microsoft Fabric Real-time Analytics

Join this session to discover possibilities with MIcrosoft Fabric Real-time Analytics.  

The Hitchhiker's Guide to navigating Power BI

Learn to navigate Power BI seamlessly in this concise session. Explore key areas: Internal Report navigation, App transitions, and Web Portal optimization. Elevate user experience with insights on service navigation, integration, and essential tools like Drill Through, Buttons, and Bookmarks.