Ask the Expert - Group A (Sat, 9:00 to 9:50)

How to be awesome at getting your next job

Finding that job you desire and want can be hard work. First, writing that CV that gets your name on the interview list. Then, making the first good impression at the interview, handling those tough questions easily. These skills are something you can learn This session, is based on many years real life hard won experience. What will be shared is tips and techniques that have got me jobs I wanted. This session is full of practical advice that you to can take away and use in your life. I will share some of the tips and techniques I have used to get roles over our career. * Creating a CV that gets noticed. * How to work with recruitment agents. * What to say when you speak with recruitment agents. * Ways to get your name to the top of the recruiter's list. * How to prepare for an interview * Get some insider tips on how to deal with those difficult interview questions. * What to say and what not say at an interview. * First hand advice from someone who has been on both sides of the job interview. When you leave this session, you have techniques and tips you can use as soon as you leave the session to help you in your search for that role you want.

Mastering SQL Server Performance & Optimization Strategies

Everyone wants their database to go faster, whether it's reducing ETL process hours, shortening report runtimes, or optimizing critical OLTP queries. Learn how to master tuning techniques, regardless of the scale, in this full length training day.

Soaring to New Heights with Accelerated Database Recovery

In this deep technical session, we will uncover the mechanisms of accelerated database recovery that allow for a much smoother flight in the journey of database recovery.

Azure Infrastructure - What Not to Do

This session will high light things I've seen in Azure SQL implementations that have caused issues. Attendees will learn from the mistakes of others to ensure a smooth Azure flight of their own.

Advanced DAX

Unleash the full power of evaluation context manipulation, learn about expanded tables, control the data lineage, avoid circular dependencies, and manage relationships at different granularities.

Aggregations in Power BI

Introduce Power BI aggregations with practical examples, evaluate pros and cons, and learn how to use alternative approaches by using DAX to control the aggregation used.

Using ALLEXCEPT or ALL/VALUES?

Learn when to use ALL / VALUES instead of ALLEXCEPT in DAX calculations.

Understanding window functions in DAX

Introduction to DAX window functions and apply semantics through several examples to understand their capabilities and performance.

Mastering SQL Server Performance & Optimization Strategies

Everyone wants their database to go faster, whether it's reducing ETL process hours, shortening report runtimes, or optimizing critical OLTP queries. Learn how to master tuning techniques, regardless of the scale, in this full length training day.

Mastering TempDB

Have you experienced performance problems caused by contention in TempDB? Have you ever wondered why your TempDB is suddenly 3 TB? In this session, you will learn about all the various components of SQL Server that use TempDB. Whether it be AlwaysOn Availability Groups, Read Committed Snapshot version stores, spills, or simply temporary tables, learn about how to identify what SQL Server or your applications are doing in TempDB. Once you understand all the ways SQL Server uses this critical resource, and how to proper configure it, you'll be better prepared for your workloads whether it be an Azure VM, a physical server, or a container.

Your Performance Tuning Check List

Everyone needs a list of what to double check in your environment to ensure your servers and databases are optimized in order to make SQL Server run faster, better and more efficiently. In this session you will learn about what you need to review and implement to get a performance and configuration improvements. You will learn about best practice configuration, SQL Server surface area, memory optimizations, isolation levels, Tempdb and transaction log configuration.

Azure SQL MI & Fabric Fusion: A speed-session

We'll take the flight showcasing how data housed in Azure SQL Managed Instance can be dynamically exposed and utilized through Microsoft Fabric. This session will demonstrate the seamless altitude transition from the operational data platform of Azure SQL MI to the analytical skies of Microsoft Fabric, ensuring a smooth integration that leverages the best of both worlds for your business needs. Pilots of data – ready your instruments for this quick cruise that will equip you with the navigational know-how to soar above the rest, utilizing Azure SQL MI and Microsoft Fabric in tandem. Fasten your seatbelts; we're cleared for takeoff into the realm where data agility meets cloud efficiency.

Fly at Mach-speed with Azure SQL Managed Instance

Discover the future of SQL Managed Instance in our session! Learn about best-in-class storage tech and new capabilities for the unmatched price/performance and scalability.

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.

What to look out for when migrating your data to the cloud; is it REALLY the right choice?

Do you want to migrate your data in the cloud? Are you sure? I'll make you think about what to consider for a successful move

DataOps: How to Deliver Data Faster and Better with Microsoft Cloud

Explore the practical methods of implementing a DataOps-driven modern data platform in the Microsoft Cloud, mastering the art of delivering high-quality data products.

How To Actually Make Decisions When Architecting a Data Platform

Are you drowning in a sea of architectural options for your new data platform? Are there people in your organisation with strong opinions on which tools should be used, and for what? Are you unsure how to prove/evidence your gut feeling as to how things should be built? Well - this session's for you! If you're in charge of architecting a new data platform, it can be difficult to make concrete decisions that pushes you closer to your end goal - building a successful solution. This session will introduce a tried-and-tested suite of strategies and tools that will help you efficiently navigate the unforgiving task of architecting a modern data platform. We'll take a look at artifacts such as ADRs (Architectural Decision Records), NFR (Non-functional requirements) documents, and discuss strategies inspired from the Agile methodology (such as failing fast) that can help you in your endeavour.

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.