
Torsten Strauß
Sessions for 2026
Learn how to use KQL with Azure Monitor and Log Analytics to analyze Azure SQL workloads. Identify performance bottlenecks, high-impact queries, and usage patterns, and turn telemetry into actionable insights for tuning and cost optimization.
Learn how to design clean, modular, and reusable Azure infrastructure with Bicep. Explore parameters, modules, loops, and CI/CD integration with Azure DevOps, and see how to standardize and scale IaC using shared Bicep modules and ACR.
Dive deep into memory grants in SQL Server and Azure SQL. Learn how memory is requested and allocated, why spills to tempdb occur, and how over- and under-allocation impact performance. Apply practical tuning techniques, including Memory Grant Feedback.
Learn how to implement database DevOps with a fully automated Azure DevOps YAML pipeline for Azure SQL. From schema drift detection to dacpac build, versioned artifacts, and safe deployments using reusable templates for scalable CI/CD.
Explore SQL Server 2025 on-premises mirroring into Microsoft Fabric OneLake for near real-time analytics without ETL. Learn setup, limitations, monitoring, and see mirrored data queried live via Fabric SQL Endpoint and Lakehouse notebooks.
Learn how row and page compression work in SQL Server and Azure SQL, how they impact I/O and CPU, and when compression improves—or hurts—performance. Explore internals, limitations, and real-world scenarios to make informed tuning decisions.
Explore SQL Server 2025 locking internals, including Optimized Locking and Lock After Qualification. Learn how these changes reduce contention, blocking, and deadlocks, and how to analyze and optimize concurrency using DMVs and Extended Events.
Learn how to diagnose and optimize slow SQL Server and Azure SQL workloads. Explore real-world query tuning techniques, Intelligent Query Processing internals, and practical strategies to improve performance and reduce costs across cloud and on-premises environments.
plan reuse helps or hurts performance, and how parameter sniffing, plan pollution, and PSP Optimization impact real-world workloads. Diagnose issues using DMVs and Extended Events.
Learn how to build a YAML-based CI/CD pipeline for Azure Data Factory in Azure DevOps. From ARM validation and artifact generation to trigger management, approvals, and environment-specific deployments using proven DevOps patterns.