Gianluca Sartori
@spaghettidba
Conegliano, Italy
Actions
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.
Links
Awards
Area of Expertise
Topics
Using WorkloadTools to analyze your workload
WorkloadTools is a collection of open-source tools to capture, analyze and replay SQL Server workloads. 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.
I will demonstrate how to install it, configure it, run it and visualize the analysis data using the built-in WorkloadViewer or the PowerBI dashboard, slice the data by Database, User or Application.
Time Series with SQL Server 2022
The last few years have seen the rise of time series databases, specialized for storing and analyzing data change over time.
These databases are great for IoT projects and for telemetry data in general, but their behavior and feature set are different from what we have in relational databases.
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. Are you working with IOT telemetry data or performance metrics? This is the session for you!
Time Series for relational people
Relational databases have been around for 40 years and they are a great choice for most data management needs. On the other hand, telemetry data has some properties that make it not exactly a great fit for a relational database. The last few years have seen the rise of time series databases, specialized for data that has a time attribute.
Join me to see what a time series database is, how it works and how you can use it in your projects. I will demonstrate how this technology enables new possibilities and overcomes some limitations of relational databases. Are you working with IOT telemetry data or performance metrics? This is the session for you!
SQL Server Infernals – A Beginner’s Guide to SQL Server Worst Practices
Are you faced with complaints from users, poor performing code from developers, and regular requests to build reports? Do you uncover installation and configuration issues on your SQL Server instances? Have you ever thought that in dire times avoiding Worst Practices could be a good starting point? If the answer is “yes”, then this session is for you: together we will discover how not to torture a SQL Server instance and we will see how to avoid making choices that turn out to be not so smart in the long run.
You are probably thinking: “Hey, wait, what about Best Practices?”. Sometimes Best Practices are not enough, especially for beginners, and it is not always clear what happens if we fail to follow them. Worst Practices can show the mistakes to avoid. I have made lots of mistakes throughout my career: come and learn from my mistakes!
Responding to Extended Events in near real-time
Extended Events provide deep insight into SQL Server's behavior and allow us to gather information not available by other means. However, compared to other technologies such as SQL Trace and Event Notifications, a way to react to the events as soon as they happen seems to be lacking. 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, such as capturing and notifying deadlocks or blocking sessions.
Monitoring SQL Server without breaking the bank
Monitoring SQL Server can become a very expensive business. Sure, the market offers countless paid solutions, but what if you have a large server estate and your budget is tight?
In this session we will combine multiple open source tools (InfluxDB, Telegraf , Grafana, dbatools and many more) to collect important performance metrics, analyze the data they collect, set up alerts for the critical events, troubleshoot issues and plan for the future. Join me and you will see how monitoring is not a business for billionaires.
3 things you don’t want to store in a database (but sometimes have to)
Some types of data are a very bad fit for a database. For instance, if you ever tried to save logs, pictures or entities with dynamic attributes in a database, you probably have one or two horror stories to share. However, sometimes there is nothing you can do and that data will have to live in your database, like it or not.
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.
Feedback link https://sqlb.it/?7048
Baking Extended Events recipes without breaking a sweat
OK, you got the message: Extended Events is the way to monitor SQL Server from now on. However, you feel overwhelmed by XML shredding and the simplest of tasks seems impossible.
Fear not: in this demo intensive session I will show you how to tackle the most challenging tasks without writing a single line of code. I will use the open-source tool XESmartTarget to audit logins, find unused objects, capture and notify deadlocks and much more.
Stop doing things the hard way! Join me and learn how XESmartTarget can do all the heavy lifting for you.
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top