These are most of my public presentations, including links to slide deck and demo scripts, and Youtube recordings (when available).
- Management Studio level-up, SQLSaturday #657, Gothenburg, September 2017.
- Management Studio level-up, SQLSaturday #656, Lyngby, Copenhagen, October 2017.
Management Studio level-up
Presented at the inaugural GroupBy.org conference in January 2017.
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.