Roger Schönmann has more than 20 years of IT experience specializing in Microsoft SQL Server security and performance tuning across on-premises and Azure environments, plus extensive experience delivering SQL Server training and consulting. He holds Microsoft Certified Solutions Expert (MCSE) for SQL Server, Microsoft Certified Trainer (MCT), and Azure Solutions Architect Expert credentials. Prior to dbi services, he was Senior SQL Server Consultant at Trivadis (Accenture) in Zurich. He trained as an Informatiker HF at the ABB Technikerschule in Baden. His project experience spans federal agencies, financial services, print media, public administration, industry, and healthcare.
Within the past few days I was investigating one of the new features of SQL Server 2025: Optimized Locking. I was curious about the capabilities, the behaviour and as well the limits of the feature. Optimized Locking is based on two primary components: Here we have the transaction ID working as a unique identifier for a transaction. Each row which…
Within the past few days I was investigating another new feature of SQL Server 2025: OPTIMIZED_SP_EXECUTESQL. I was curious about the capabilities and the behaviour. OPTIMIZED_SP_EXECUTESQL is a database scoped configuration which allows us to get rid of the overhead of compiling and producing execution plans when we deal with dynamic SQL. The first user-session which launches a given dynamic…
During the last years working with customers and teaching them in security topics, I realised that a lot of DBAs are not familiar with or aware of the differences between the two “owner” existing in SQL Server. That’s why I decided to write a blog about it. Well, in SQL Server we are dealing with two principals in terms of…
I had the opportunity to participate the SQL Server conference event (SQL KONFERENZ 2024) with my collegue Nathan Courtine.Independent from each other we chose exactly the same sessions as we are both interested in topics like Security, Performance Tuning, Azure and Artificial Intelligence (AI). For me, it was a great pleasure to see all those guys – from which I…
