Daniel Hutmacher
Principal consultant at Structured Concepts
Stockholm, Sweden
Actions
SQL Server developer for 25-odd years, Microsoft Data Platform MVP, organizer of Data Saturday Stockholm, volunteer/co-organizer of GroupBy.org.
I still occasionally blog at sqlsunday.com.
Awards
Area of Expertise
Topics
SQL Server Partitioning from Zero to Hero
Ever since the incident, you’ve been wanting to learn more about database partitioning in SQL Server. This session walks you through what partitioning really does, and what it doesn’t do. We’ll take a look at some of the quirks of partitioning, as well as how to use it to boost performance, enable high(er) availability, and even build lightning-fast data retention policies.
Get your ducks in a row - understanding ordered data flows
There's a lot of information out there to overwhelm you when it comes to performance tuning your queries. It's very easy to feel like you're drinking from a fire hose when you're reading long blog posts or listening to technical conference sessions. Operators, metrics, wait statistics, page life expectancy, parallellism and fragmentation.
But let's take a step back and understand the one fundamental principle of querying data - ordering. This session is all about interactively and visually explaining the flow of data in terms of ordering, and how that affects the performance of your queries and server.
Once you get these basics right, tuning will feel so much easier and execution plans may even start to appear quite intuitive.
From substitutions to public keys - an introduction to cryptography
Cryptography is everywhere. Most of what you do on the Internet and in the cloud is encrypted. If you’re working with data or cloud infrastructure, just checking the TLS checkbox is only half the job. You need to have a decent understanding of what goes on underneath the padlock icon in order to keep your company’s dirty secrets safe.
In this high-level introduction to cryptography, we’ll look at the origins and evolution of encryption, leading up to modern-day symmetric and asymmetric encryption, signatures and certificates. After the session, you’ll be able to use hand-wavy phrases like “certificate chain” and “public key infrastructure”, as if you know what they mean.
No PhD required.
ACID in SQL Server: what it is, how it works, and how to live more adventurously.
You’re a developer, data engineer, or DBA working with SQL Server. You remember reading about ACID compliance in some computer science class a couple of decades ago, and maybe you just assumed that every transaction you run in SQL Server is fully ACID: Atomic, Consistent, Isolated and Durable.
That’s what the packaging says, and it’s mostly correct.
ACID has long been a core concept of transactional databases, but there are a number of ways we can manipulate or even disable some of these four properties in SQL Server. Sometimes intentionally, and sometimes perhaps unexpectedly.
In this session, we’ll look at the real-world effects of the settings and hints in SQL Server that affect ACID compliance: when to use them to improve your database workload, and when to avoid them. We’ll compare isolation levels, delayed durability, and distributed data patterns.
You’ll not only walk away with a better understanding of the underlying transaction logic, but you’ll know which settings can cause data loss, and which ones can actually improve application performance.
Data Saturday #49 - Denmark - 2025 Sessionize Event Upcoming
SQL Konferenz 2024 Sessionize Event
Data Saturday Oslo 2024 Sessionize Event
DataGrillen 2024 Sessionize Event
SQLBits 2024 - General Sessions Sessionize Event
dataMinds Connect 2023 Sessionize Event
Data Saturday Oslo 2023 Sessionize Event
Data Saturday Gothenburg 2023 Sessionize Event
Data Céilí 2023 Sessionize Event
Data Saturday Oslo 2022 Sessionize Event
DataGrillen 2022 Sessionize Event
DataMinutes #1 Sessionize Event
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top