SQL Server demos: presentations and code samples

This repository contains experiments, slide and demo scripts of my sessions at in-person or online events such as SQL Saturday, Data Saturday, SQL Start, Delphi Day, Microsoft Conferences and so no.

2025

Event	Session	Material	Video
Data Saturday Pordenone 2025	Optimized Locking in Azure SQL Database: Concurrency and performance at the next level	Slide and Demo
Data Saturday Pordenone 2025	SQL Server Deadlocks: Techniques to identify and resolve them	Slide and Demo
Global Azure 2025	Optimized Locking in Azure SQL	Slide and Demo
SQL Start 2025	How SQL Server 2025 improves concurrency with TID locking and LAQ	Slide and Demo
Delphi Day 2025	SQL Server 2025: What's new in the engine	Slide and Demo
Data Saturday Parma 2025	SQL Server 2025: Optimized Locking in action	Slide and Demo

2024

Event	Session	Material	Video
Data Saturday Pordenone 2024	Database maintenance with Azure SQL Elastic Jobs	Slide and Demo	Vimeo
Global Azure 2024	Database maintenance with Azure SQL Elastic Jobs	Slide and Demo	Vimeo
Delphi Day 2024	Crittografia in SQL Server	Slide and Demo
SQL Start 2024	SQL Server unit testing con tSQLt, Docker e GitHub Actions	Slide and Demo	Vimeo
1nn0va Saturday 2024	SQL Server Maintenance Plan: Fundamentals and best practices	Slide and Demo	Vimeo
Data Saturday Parma 2024	SQL Server Deadlocks: Techniques to identify and resolve them	Slide and Demo	Vimeo

2023

Event	Session	Material	Video
Data Saturday Pordenone 2023	SQL Server 2022 Degree of Parallelism Feedback	Slide and Demo
Delphi Day 2023	T-SQL performance tips & tricks	Slide and Demo
SQL Start 2023	SQL Server 2022 Degree of parallelism feedback	Slide and Demo	Vimeo
1nn0va Saturday 2023	SQL Server unit testing con tSQLt, Docker e GitHub Actions	Slide and Demo	Vimeo
Data Saturday Parma 2023	T-SQL performance tips & tricks	Slide and Demo	Vimeo

2022

Event	Session	Material	Video
Data Saturday Pordenone 2022	T-SQL magic tricks	Slide and Demo	Youtube
DataWeekender CU5	T-SQL magic tricks	Slide and Demo
SQL Start 2022	SQL Server 2022 Parameter Sensitive Plan Optimization	Slide and Demo	Youtube
Delphi Day 2022	SQL Server 2022 Parameter Sensitive Plan Optimization	Slide and Demo	Youtube
1nn0va Saturday 2022	SQL Server 2022 Parameter Sensitive Plan Optimization	Slide and Demo
Data Saturday Parma 2022	SQL Server 2022 Parameter Sensitive Plan Optimization	Slide and Demo	Youtube

2021

Event	Session	Material	Video
Humanitarian IT conference for earthquake victims in Croatia	Automating Azure SQL Database maintenance tasks	Slide and Demo
Data Saturday Pordenone 2021	Database development unit test with tSQLt	Slide and Demo	Youtube
Global Azure 2021	Unit testing in Azure SQL Database with tSQLt	Slide and Demo	Youtube
SQL Start 2021	Database development unit test with tSQLt	Slide and Demo	Vimeo
Delphi Day 2021	Database development unit test with tSQLt	Slide and Demo	Youtube

2020

Event	Session	Material	Video
PASS Global Italian VG	SQL Server Query Store e Automatic Tuning		Youtube
Global Azure 2020	Automating Azure SQL Database maintenance tasks	Slide and Demo
SQL Start 2020	Automating Azure SQL Database maintenance tasks	Slide and Demo	UGISS channel on Vimeo
Delphi & Dintorni Webinars	SQL Server Execution Plans: From Zero to Hero	Slide and Demo	Youtube
IT PRO DEV Connections 2020	Automating Azure SQL Database maintenance tasks	Slide and Demo

2019

Event	Session	Material	Video
SQL Start	SQL Server Execution Plans: From Zero to Hero	Slide and Demo	UGISS channel on Vimeo
Delphi Day Piacenza	SQL Server Query Store e Automatic Tuning	Slide and Demo	UGISS channel on Vimeo
SQL Saturday Athens	SQL Server Query Optimizer end-to-end	Slide and Demo	UGISS channel on Vimeo
SQL Saturday Pordenone	SQL Server Query Optimizer end-to-end	Slide and Demo	UGISS channel on Vimeo
SQL Saturday Sardegna	Set-based vs Iterative programming	Slide and Demo	UGISS channel on Vimeo
SQL Saturday Sardegna	SQL Server Execution Plans: From Zero to Hero	Slide and Demo	UGISS channel on Vimeo

2018

Event	Session	Material	Video
SQL Saturday Parma	SQL Server Query Optimizer end-to-end	Slide and Demo	UGISS channel on Vimeo
SQL Saturday Pordenone	SQL Server 2017 Graph Database	Slide and Demo	UGISS channel on Vimeo

Older events

Presentations and code samples of my talks older than 5 years are available in the subdirectories, organized by year, within the event directory!

Enjoy!