Presentations

Me, goofing off at Data Grillen 2022. Photo credit: Marc Lelijveld

These are most of my public presentations, including links to slide deck and demo scripts, and Youtube recordings (when available).

Upcoming events

I’m scheduled to present at Data Data Céilí 2023 at the one and only Trinity College in Dublin in early June, as well as Data Saturday Oslo in September.

SQL Server Partitioning from Zero to Hero

An introductory session on how to do partitioning on SQL Server, and why it may actually not be for you.

Presented at Data Grillen in June 2022 and the PASS Data Community Summit 2022.

“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.”

SQL Server Privilege Escalation for Dummies

This was my first lightning talk ever, and a super fun session to put together and present.

Presented at the inaugural DataMinutes conference in June 2021.

“We’ve all been there. They didn’t provide you with access to Production, and the DBAs have stopped answering your texts. I’ll show you how to make your own roads, and possibly even cause a career-defining event.”

Getting your ducks in a row

– understanding ordered data flows

Presented at SQL Saturday Gothenburg 2019, the Swedish SQL Server usergroup in October 2019, Group By in October 2021, and Data Saturday Oslo 2022.

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.

Not just polish: how good code also runs faster

Presented at GroupBy.org in September 2018 and SQL Saturday Holland in October 2018, SQL Saturday Finland in May 2019, and SQL Saturday Oslo in August 2019!

You’ve been writing T-SQL for a while, but you want some easy pointers on how to make it go faster.

I want to show you how just a little neater and tighter code can also run a lot faster. These are some of the instant performance improvements that won’t change a lot of code, won’t generate weeks of testing and validation for your colleagues and can be relatively quick to implement.

Management Studio level-up

Presented at the inaugural GroupBy.org conference in January 2017, SQLSaturday #657, Gothenburg in September 2017 and SQLSaturday #656 in Copenhagen.

Move up to Management Studio Superstar with these great productivity tips! We’ll explore stuff like keyboard shortcuts, configuration options, how to keep your SSMS settings synchronized across multiple environments and other really useful everyday tricks and hacks.

SQL Server Security Basics

Presented at SQLSaturday #667, Oslo in September 2017.

The SQL Server security model spans across a number of layers all the way from the OS security down to individual column-level permissions and row-level security, with concepts like owners, inheritance, impersonation, ownership chaining. In this session, I’ll give you a good basic understanding of how to secure your data in SQL Server as well as a look at some common security risks.

Exploring common table expression

Presented at SQLUG in June 2016 and SQLSaturday #536 Gothenburg in September 2016.

Join me for a twisting and turning session where we look at some interesting uses of common table expressions and recursive CTEs. We’ll look at nested CTEs, managing duplicate rows, string and XML parsing as well as dependency trees and other hierarchies. These are not just cool tricks – they’re powerful T-SQL patterns that can improve the stability and performance of your data cleansing and ETL code.