Gianluca Sartori
Gianluca Sartori is a Data Platform MVP, independent consultant and performance tuning specialist. He has been working in the software industry since 1999 and has been working with SQL Server ever since. He also works as a SQL Server trainer and in his spare time he writes technical articles and participates the SQL Server forums. Gianluca enjoys presenting SQL Server topics at conferences in Europe and US. He is currently working as lead DBA at a famous Formula 1 team.
Gianluca Sartori's Sessions
Time Series with SQL Server 2022SQLBits 2024
SQL Server 2022 introduces new time series capabilities, that will allow us to to work with time series data in the same database that we use for all the rest of the data.
Join me to see what SQL Server 2022 brings to the table for time series data, how to use the new features and what are the opportunities and the limitations.
3 things you don’t want to store in a database (but sometimes have to)SQLBits 2022
Some types of data are a very bad fit for a database. Join me to see how to survive with a database full of data that should not be stored there. I will demonstrate how to deal with billions of rows of logs without trashing the database, how to store millions of pictures effectively and how to deal with dynamic attributes in a sensible way.
Using WorkloadTools to analyze your workloadSQLBits 2022
In this session I will show you how to use WorkloadTools to connect to a SQL Server database, on-premises or in the cloud, and analyze all the queries that are run against it.
Baking Extended Events recipes without breaking a sweatSQLBits 2021
In this demo intensive session I will show you how to tackle the most challenging tasks with Extended Events without writing a single line of code.
Baking Extended Events recipes without breaking a sweatSQLBits 2020
In this demo intensive session I will show you how to tackle the most challenging tasks with Extended Events without writing a single line of code.
Benchmarking in the CloudSQLBits 2019
Join me in this session and learn how to capture a production workload, replay it to your cloud database and compare the performance. I will introduce you to the methodology and the tools to bring your database to the cloud without breaking a sweat.
SQL Server Infernals - A Beginner’s Guide to Worst PracticesSQLBits 2018
When you're in a rush, following best practices is a luxury you may not be able to afford. What about just avoiding worst practices instead? Join me for this session and learn from my mistakes!
Simplifying XEvents Management with dbatoolsSQLBits 2018
Bye #TeamProfiler and hi #TeamXEvents with the power of dbatools
Benchmarking like a PROSQLBits 2017
In this demo-intensive session you will discover how to capture a meaningful workload in production and how to replay it against your test system.
Responding to Extended Events in near real-timeSQLBits 2016
In this session we will see how the Extended Events streaming API can be used to process events in a near real-time fashion. We will demonstrate how this technology enables new possibilities to solve real world problems.
Time Series with SQL Server 2022SQLBits 2024
SQL Server 2022 introduces new time series capabilities, that will allow us to to work with time series data in the same database that we use for all the rest of the data.
Join me to see what SQL Server 2022 brings to the table for time series data, how to use the new features and what are the opportunities and the limitations.
3 things you don’t want to store in a database (but sometimes have to)SQLBits 2022
Some types of data are a very bad fit for a database. Join me to see how to survive with a database full of data that should not be stored there. I will demonstrate how to deal with billions of rows of logs without trashing the database, how to store millions of pictures effectively and how to deal with dynamic attributes in a sensible way.
Using WorkloadTools to analyze your workloadSQLBits 2022
In this session I will show you how to use WorkloadTools to connect to a SQL Server database, on-premises or in the cloud, and analyze all the queries that are run against it.
Baking Extended Events recipes without breaking a sweatSQLBits 2020
In this demo intensive session I will show you how to tackle the most challenging tasks with Extended Events without writing a single line of code.
Benchmarking in the CloudSQLBits 2019
Join me in this session and learn how to capture a production workload, replay it to your cloud database and compare the performance. I will introduce you to the methodology and the tools to bring your database to the cloud without breaking a sweat.
SQL Server Infernals - A Beginner’s Guide to Worst PracticesSQLBits 2018
When you're in a rush, following best practices is a luxury you may not be able to afford. What about just avoiding worst practices instead? Join me for this session and learn from my mistakes!
Simplifying XEvents Management with dbatoolsSQLBits 2018
Bye #TeamProfiler and hi #TeamXEvents with the power of dbatools