These are most of my public presentations, including links to slide deck and demo scripts, and Youtube recordings (when available).
See me present at these events:
- SQLSaturday #775, Gothenburg, September 15
- SQLSaturday #790, Holland, October 13
Not just polish: how good code also runs faster
Presented at GroupBy.org in September 2018.
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.