SQL Server Performance Tuning and Optimization - FULL DAY PRE CON
Do your users complain about slow reports? Are your database servers overwhelmed during times of high usage? Every SQL Server environment can benefit from performance tuning whether your environment has one server or thousands. In this full-day session you will learn about how identify problems using a wide variety of tools and scripts and how to implement best practices across your environment. Additionally, you will learn how to begin reading execution plans and how to tune queries to improve your performance within SQL Server. You will walk away with a list of items to evaluate in your environments and ways to resolve common issues. This session will guide you through real-life performance problems which can be solved by best practices and practical skills. Taught on a level anyone can understand, this session will focus on Microsoft SQL Server 2016 and forward.
You will also learn about maintenance activities and how they affect your server’s overall performance, and how to identify when your infrastructure is affecting your performance. Lastly, we will cover the newest performance enhancements coming with the latest release, SQL Server 2022. You’ll leave this demo-filled session better prepared to tackle many issues that can plague SQL Server performance along with the knowledge of how to resolve them.DijlezaalMon 09:00 - 17:00
Power BI Report Design and Development workshop
This one-day collaborative workshop will cover the various Power BI design stages learned from years of consulting and working with some of the largest enterprises. The workshop, divided into five modules, enables you to bring your end user's data to life with Power BI.
1 The Basics of Data Visualization
In this first module, you will get an introduction to data visualization and discover why telling the right story to the right audience is so important.
2 Aligning people and data
This module will teach you how to conduct workshops and gather requirements from stakeholders and end users. Then you will learn techniques to explore data and identify meaningful patterns. In the hands-on workshops, we will use sample templates to ask the right questions and convert captured requirements to use cases. By the end of this section, you will be able to determine the 5W's and How (who, what, why, where, and how) to create an optimal Power BI model.
3 Drive use cases and data patterns to drive visualizations
In this section, you will learn concepts and techniques that will assist you in identifying the right visual based on data and use cases. You will understand the most used visual categories like Key Metrics, charts, Maps etc. and then learn how to use them in Power BI to create stand-out visuals.
4 How to find the right visuals
In this section, you will learn tips and techniques to identify the right visual for the right audience and their use cases. The section also includes an exercise to find the right visuals based on your previously identified use cases.
5 Putting the story together
In this module, we will tie it all together using my top 10 techniques to create a stunning Power BI report. We will cover everything, from a blank canvas to an actionable report, and ensure it is accessible to all users. We will end the day with a final workshop to create reports based on different audiences. A ready-to-use Power BI model, personas and use cases will be provided.ScalaMon 09:00 - 17:00
Analytics superhero in a day with Microsoft Fabric
Are you ready to become analytics superhero?
Hesitate no more! Microsoft Fabric is out and building analytics solution cannot get any easier! If you believe that the best way to learn is to learn by example, join us!
We will build a new green field analytical solution using new all-in-one Microsoft Fabric that covers everything from data movement to data science, Real-Time Analytics, and business intelligence. You will enjoy a highly integrated, end-to-end, and easy-to-use product that is designed to simplify your analytics needs.
We will start off the day with an overview of Microsoft Fabric, set up the environment and explain the scenario for the day.
There is no use of analytics solution if there is no data. So, we will show how data is stored in Fabric, how you can integrate existing data, or ingest data from different sources. Here we will create landing zone and integrate existing data without making another copy!
Once data is in Microsoft Fabric OneLake, we will process it efficiently while demonstrating best practices. Data engineers are used to Spark so it will be our tool of choice in creating different layers while tackling all the things you need to know. During this part, you will learn how to incrementally load data and make sure your cleansing is done right and in an effective and dynamic way! Rest assured, SQL folks are not forgotten! We will show how you can access the same data using SQL!
Of course, there is no using loading data without a serving layer for your business needs. We will show you how you can use Lakehouse & Warehouse in Microsoft Fabric focusing on performance!
Finally, we will show you how to build Power BI report using new consumption method reading data directly from the lake, called DirectLake, skipping data engines.
If you do not know where to start, don’t worry, during this day we will explain every step and how Fabric helps you get the job done. Also, we will share the best practices seen at most customers!
After this day you will have a clear understanding of how Fabric works and what components you must use for you own top notch analytical solution!
Fabric is brand new, so instead of throwing terminology here, we are inviting you to join us and become the analytics superhero!AuditoriumMon 09:00 - 17:00
So much hybrid SQL goodness
Over the last years, Microsoft announced and released multiple services under their Azure Arc umbrella.
But what's in it for you? Join me on a journey through the different offerings in Azure Arc and how they can benefit you as a data professional!
While there are countless offerings, we'll mostly focus on those with a clear data focus: Azure Arc-enabled SQL Server, Azure Arc-enabled Data Services and Azure Arc-enabled Machine Learning.
But Arc isn't the only hybrid puzzle piece: SQL Server 2022 also comes with a bunch of new hybrid features like Synapse Link or MI Link, so we'll take a look at those, too!
You'll walk away from this demo loaded day with a good understanding on what Microsoft's hybrid offerings are and how they can benefit you as well as with pointers to more deep dive materials on the specific offerings!Herten AasMon 09:00 - 17:00
Power BI Source Control & CI/CD
This training day takes you from zero to hero with respect to using source control and CI/CD with Power BI projects.
Learn directly from Mathias who has many years of experience with defining, implementing and evolving Power BI source control practices and tools. His open-source tool pbi-tools has pioneered source control capabilities for Power BI, and has directly and indirectly influenced many investments and releases in the Power BI ecosystem by Microsoft.
With many new tools and features available in 2023, this session is your opportunity to learn, hands-on, how to get started with source control, which tools are available, and what it takes to implement them successfully for your team/project.
The session covers source control basics and explains the use of git, Visual Studio Code and Azure DevOps in conjunction with Power BI. All the latest Power BI source control and collaboration features are covered, including Power BI Deployment Pipelines as well as advanced CI/CD pipelines via external tools.
1. Hands-on source control tutorial
2. Setting up CI/CD in your organization
3. Advanced workflows and branching strategiesAlcazarMon 09:00 - 17:00
Introduction to Building Scalable Machine Learning Models
Machine learning is a forever-evolving space. In the early days, the focus was on implementing the historic algorithms using the computing power that was previously unavailable. Currently, ML has expanded across multiple avenues of interest: Being able to scale models with the ever-increasing quantities of data, the ability to package models up so that they can fit into an MLOps framework, how well tracked and logged the models are, how explainable they are, not to mention techniques to squeeze the best performance out of the models. All these aspects are rarely covered all at once. This pre-con aims to take all these key topics and deliver them over the Databricks platform, one of the leading tools in the industry for data manipulation, machine learning and distributed computing. It utilises a powerful Spark engine under the hood whilst presenting an easy-to-use bespoke notebook for the front end.
This session calls upon experience gained over the years by experienced machine learning practitioners to deliver a condensed, concise course to help fast-track any machine learning novice towards mastery.
The pre-con will cover building real-world models in Azure, further techniques for robust model building, the latest craze in ML known as feature stores, advanced model tracking and key considerations when scoring models. The pre-con will contain talks, coupled with follow-along labs giving an element of hand-holding with some more tricky tasks thrown in. The sessions will also explore real-world use cases that are rife in the business world.BegijnenzolderMon 09:00 - 17:00