DATACON, a Microsoft Data Platform conference, brings together top experts, industry leaders, and data professionals for an immersive five-day experience. Focused on cutting-edge Microsoft data technologies—including Azure SQL Databases, Microsoft Fabric, SQL Server, and Real-Time Intelligence—DATACON delivers deep technical insights and practical solutions to help individuals and organizations unlock the full potential of their data.
With two days of intensive preconference workshops followed by three days of expert-led sessions, attendees gain hands-on experience and in-depth knowledge across a range of specialized tracks, including,&nbsp;Azure Data Services,&nbsp;SQL Server Optimization &amp; Best Practices,&nbsp;SQL Server Data Solutions for Enterprise,&nbsp;Data Warehousing,&nbsp;Data Integration &amp; Transformation,&nbsp;Power BI &amp; Data Visualization,&nbsp;Microsoft Fabric, and&nbsp;Data Security &amp; Governance.
At DATACON, learning comes from the best in the industry. Our speakers include Microsoft MVPs, Microsoft Certified Masters (MCMs), Microsoft Program Managers, Engineers, MCTs, and Regional Directors—each bringing expert-level insights into Azure SQL Databases, SQL Server, Purview, Power BI, Fabric, and more.
Choose a complete learning track to deepen your expertise or mix and match sessions to fit your organization’s specific needs. Whether you’re focused on building data pipelines, designing dashboards, integrating AI into your workflows, or mastering data governance,&nbsp;DATACON&nbsp;is your destination for actionable insights and transformative learning.

DATACON

Join us for a workshop designed specifically for Pro Data Modellers. This comprehensive session will guide you through all the critical elements needed to build, tune, and maintain a Direct Lake Model in Microsoft Fabric.

Throughout the workshop, you will delve into essential topics such as:
-Understanding the prerequisites for setting up your model.
-Exploring the anatomy of Parquet files and their role in data storage.
-Mastering transcoding and framing techniques to optimize data processing.
-Implementing SQL fallback strategies for enhanced reliability.
-Discovering new features and how they can benefit your projects.
-Ensuring robust security measures to protect your data.
-Fine-tuning performance to achieve optimal efficiency.
-Navigating the migration process with ease.
-Tackling advanced topics to elevate your modelling skills.

By the end of this workshop, you will have gained the knowledge and skills necessary to effectively manage a Direct Lake Model, ensuring your projects are both efficient and secure.

A Comprehensive Guide to Direct Lake for the Pro Data Modeller 

In this all day session on Microsoft SQL Server we will be learning about how Microsoft SQL Server works, both in Azure and on-premises, and what needs to be done to keep it up and running smoothly when you don't have a full-time database administrator on staff to help you keep it running.

In this session, we will cover a variety of topics, including backups, upgrade paths, indexing, database maintenance, database corruption, patching, virtualization, disk configurations, high availability, database security, database mail, anti-viruses, scheduled jobs, and much, much more.

From a product perspective, we'll examine SQL Server in an Azure VM, Azure SQL DB, and Azure SQL DB Managed Instance, as well as the on-prem options, including SQL Server on-premises options, including Azure Arc hosted deployments.

After taking this full-day session on SQL Server you'll be prepared to take the information that we go over and get back to the office, get the SQL Server's patched and properly configured so that they run without giving you problems for years to come.


Database Administration for the Non Database Administrator

Transform your data solutions with a streamlined Medallion Architecture using Microsoft Fabric. This session is tailored for professionals familiar with Power BI and basic dataflows, providing a step-by-step guide to implementing Bronze, Silver, and Gold layers for a scalable and maintainable pipeline. Learn how to evolve an unstructured dataflow and semantic model into a comprehensive architecture. Familiarity with Python or SQL is a bonus but not required.

Modules:
• Overview of Medallion Architecture: Gain a clear understanding of Warehouses and Lakehouses, their role within Microsoft Fabric, and how they enable Medallion Architecture.
• Understanding OneLake: Dive into OneLake and explore its foundational storage structure, including Delta tables and Parquet. Understand key features like columnar storage, Delta optimizations, and performance enhancements through simple, no-code explanations.
• Feature Showdown: Compare and contrast key tools in Microsoft Fabric, such as SQL vs. Spark, Notebooks vs. Dataflows vs. Pipelines, and Warehouses vs. Lakehouses, to determine the best fit for your scenarios.
• Well-Designed Architecture & Best Practices:
Learn about GIT integration, monitoring techniques, and actionable best practices for designing scalable and maintainable data architectures.

Labs:
• Build a Lakehouse and create a Medallion Architecture pipeline.
• Extract raw data using Pipelines (Bronze).
• Clean and transform data with Spark Notebooks (Silver).
• Add business logic with T-SQL (Gold).
• Create orchestration and monitor pipelines for optimal performance.
• Bonus Lab: Create and manage a semantic model and integrate it with GIT for version control.

Design a Well-Architected Fabric Solution: A Medallion First Approach

You probably have some tricks up your sleeve for dealing with slow queries. Index the columns in the join and where. Rewrite the WHERE clause to enable index usage. Tinker with the join order, or perhaps even break up the query in smaller parts. Those tricks work. Sometimes. Not always. And when they don't, your job suddenly gets frustrating!

Sometimes, you wish you knew WHY a query is slow. So that you can target your changes exactly right, at precisely the root cause of the slowness. And the good news is, there already exists a way to find the root cause of bad performance. You "only" need to learn to work with execution plans

In this full-day workshop, you will learn everything you need. You will learn what execution plans are, and where you can find them. You will learn the basics of how to read execution plans. And you will learn all you need about all of the commonly encountered operators in execution plans: what their function is, how they operate, and what effect that has on performance.

In short: After attending this workshop, you will know how to obtain an execution plan for a slow running query, and you will know how to look at that plan and find the spot where it hurts, so that you know what to do to fix the performance issue.

Regardless of whether you have never seen an execution plan before, or whether you already have experience working with execution plans, this workshop will teach you how to look at an execution plan and then KNOW why your query is slow ... and what you can do to fix that!

Execution plans explained

In an era where data breaches, fraud, and lack of transparency plague traditional databases, blockchain emerges as a revolutionary solution for secure and trusted data management. This session explores how blockchain technology is transforming the way we store, access, and verify data—eliminating single points of failure, enhancing security, and ensuring transparency like never before.

I'll dive into the core principles of blockchain that make it a superior alternative to traditional databases, from immutability and cryptographic security to decentralized trust mechanisms. Attendees will gain insights into real-world applications across industries such as finance, healthcare, and supply chain, showcasing how blockchain is redefining data integrity and ownership.

Whether you’re a developer, business leader, or tech enthusiast, this session will equip you with the knowledge to understand why blockchain is the future of secure and transparent databases—and how your organization can leverage it for a more trusted digital ecosystem.

Details

Address

Date / Time

Paid Event

Registration

Social / Web

X / Twitter

Hashtag

Website

Community Days | DATACON