These are most of my public presentations, including links to slide deck and demo scripts, and Youtube recordings (when available).
No currently planned speaking engagements.
Getting your ducks in a row
– understanding ordered data flows
Presented at SQL Saturday Gothenburg 2019 and the Swedish SQL Server usergroup in October 2019.
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.
- GroupBy.org abstract,
- Slides and the sp_ctrl3 utility,
- … and my thoughts on presenting on-line for the first time.
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.
- Slides and demo scripts from September 2017.
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.
- Slides and demo scripts from September 2016.