Monday, 24. February 2025
PreCon Workshops
Valerie Junk | Elena Drakulevska | Lonneke Opsteegh
Creating Reports that Matter: User requirements, DataViz, Storytelling & Accessibility
Abstract
Join this full-day workshop to learn how to transform raw data into reports that help your audience to work data-driven and take action based on data instead of gut feeling. This hands-on session covers everything from effectively gathering user requirements to translating these into a design (did you know there are 3 layers of report design?). We will show you how to create visuals that lead to actions while telling a compelling story, always prioritizing accessibility and the end user.
This end-to-end workshop emphasizes that report design is far more than just dragging and dropping data onto a report—it’s about creating meaningful, actionable insights that everyone can use.
Learning Objectives
- How to gather and understand user requirements
- Dashboard Design (3 layers of design and UI/UX principles)
- Visualizations that drive action (using DAX)
- Storytelling with data
- Accessible report design
- Developing a way of working to make these changes last
ROOM TBD
Mo 10:00 am – 05:00 pm
English
Jess Pomfret | Rob Sewell
dbatools and dbachecks – Going Beyond the Book
Abstract
Let us show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community-developed modules dbatools and dbachecks. We will take you beyond ‘dbatools in a Month of Lunches’, into more advanced scenarios and show you how effective and efficient PowerShell can make you. Join Jess Pomfret and Rob Sewell, two of the ‘dbatools in a Month of Lunches’ authors, and take your dbatools and dbachecks skills to the next level. We will show you the skills, scripts, and tricks that we have learned with dbatools and dbachecks and tell you how they have rocketed our careers.
Learning Objectives
There will be many practical examples of how dbatools and dbachecks can help to save time in DBA administration duties such as:
- Finding SQL Instances on your estate
- High Availability and Disaster Recovery scenarios
- Working with Replication
- Backup Testing
- Instance migrations
- Validating your estate with dbachecks
- dbatools and dbachecks in DevOps processes
- Using PowerShell in the cloud (i.e. working with Azure SQL Database, Azure SQL Managed Instance)
- PowerShell coding for performance
- Using dbatools and dbachecks in Azure Functions and Azure Runbooks Take your dbatools and dbachecks skills to the next level and become more effective in your role. Register now to reserve your spot!
ROOM TBD
Mo 10:00 am – 05:00 pm
English
Frank Geisler | Johan Ludvig Brattås
Build A Fabric Real-time Intelligence Solution in One Day
Abstract
Real-Time Intelligence in Fabric is designed to enable organisations to bring their streaming, high-granularity, time-sensitive event data into Fabric and build various analytical, visual and action oriented data applications and experiences with it. In this session, you will learn about what Fabric Real-time Intelligence is meant for and will then build an end-to-end solution using streaming data.
This session will get you hands-on with Real-Time Hub, Eventstream, Eventhouse, Data Activator, Real-time Dashboards, Power BI, and Copilot with a combination of Microsoft MVPs and Fabric product group members to guide you along the way.
Learning Objectives
ROOM TBD
The end-to-end solution we build together will encompass:
- Discovering and cataloging your data streams using Real-Time Hub
- Connecting to streaming data from various sources around the world
- Cleaning, normalizing, preparing data for superior query time experiences
- Leveraging Copilot to discover streaming data
- Low-code/no-code experiences for data exploration
- Developing dashboards
Mo 10:00 am – 05:00 pm
English
Hands-On
Uwe Ricken
Performanceoptimierung durch Identifikation und Behebung von schlechtem SQL-Code
Abstract
In diesem interaktiven Workshop werden realitätsnahe Beispiele für schlechte SQL-Programmierung vorgestellt, die in der Praxis häufig zu Performance-Problemen führen. Ziel der Session ist es, den Teilnehmern zu zeigen, wie man ineffiziente SQL-Abfragen/SQL Code erkennt, analysiert und optimiert, um signifikante Leistungssteigerungen zu erzielen.
Der Workshop konzentriert sich auf fünf bis zehn konkrete, schlecht implementierte SQL-Coding-Szenarien. Für jedes dieser Szenarien werden die zugrunde liegenden Probleme detailliert erläutert und anschließend Optimierungsansätze präsentiert. Dabei werden unterschiedliche Techniken und Best Practices vorgestellt, die für die Verbesserung der Abfragegeschwindigkeit und Systemeffizienz unerlässlich sind.
Mit Hilfe praktischer Lab-Übungen werden Lasttests erzeugt, um die Performance vor und nach der Optimierung messbar zu vergleichen. So können die Teilnehmer direkt nachvollziehen, welche Maßnahmen zu einer erheblichen Reduzierung der Antwortzeiten führen und welche Auswirkungen sie auf die gesamte Systemlast haben.
Am Ende der Session werden die Teilnehmer ein besseres Verständnis für die häufigsten Fallstricke in SQL-Programmierpraktiken haben und in der Lage sein, fundierte Performance-Analysen durchzuführen und Optimierungen vorzunehmen.
Learning Objectives
- Erkennen und Verstehen von häufigen SQL-Performance-Problemen
- Anwendung von Best Practices zur Abfrageoptimierung
- Durchführung von Lasttests zur Performance-Messung und -Verifikation
- Verbesserung der Effizienz von Datenbankanfragen in realen Szenarien
Who Should Attend
Datenbank-Administratoren, Softwareentwickler, IT-Architekten und alle, die regelmäßig mit SQL-Abfragen arbeiten und ihre Kenntnisse in der Performanceoptimierung vertiefen möchten.
Prerequisites
- Eigener Laptop mit Microsoft SQL Server >= 2016 mit Demo-Datenbank ERP_Demo https://www.db-berater.de/downloads/ERP_DEMO_2012.BAK
- RML-Utilities / SQLQueryStress
- Windows Admin Server oder PerfMon / RessourcenMonitor
ROOM TBD
Mo 10:00 am – 05:00 pm
German
Hands-On
Sasa Popovic | Des Fitzgerald | Pieter Vanhove | Niko Neugebauer
Become an Azure SQL Datamonster
Abstract
Join Microsoft Product Group to learn how our Azure SQL offerings work, how they are architected, how they differ and what their advantages and shortcomings are.
Unleash the power of provisioning, navigating the twists and turns of HA, DR, and backup-restore with ease. Tame the connectivity brute by determining how it is blocking your connections to your database. Once your systems are up and roaring, make regular maintenance your powerful ally standing by your side instead of in your way.
We’ll talk about database migration projects and how we approached and migrated complex workloads to Azure SQL. You’ll understand various options and tooling available to you for moving your data and critical databases to Azure SQL smoothly, leaving downtime fears and nasty gotchas cowering in the shadows.
We will take a monster deep dive into monitoring and observability and unleash performance weapons against the treacherous slowness beast and achieve the top speed of your workloads with the help of proven how-to guidance gained directly from the battle trenches.
Want to protect your data from other monsters and potential threats? We will show you how to keep your data safe. We shall cover brave security features such as Transparent Data Encryption (TDE), SQL Auditing, Microsoft Entra Authentication & Always Encrypted.
Learn with us how to manage who can access your data, protect your data whether it’s stored or being sent over the network, and make sure your data stays private and secure.
Become a true Azure SQL Datamonster by the help from M.W.A straight out of Redmond.
ROOM TBD
Mo 10:00 am – 05:00 pm
English
