Gianluca Sartori

Gianluca Sartori is an independent SQL Server consultant and a performance tuning specialist. He has been working in the software industry since 1999 and has been working with SQL Server ever since. Currently he is working as Senior DBA for a famous Italian Formula1 team. Besides consulting projects, he works as a SQL Server trainer and in his spare time he contributes to the SQL Server forums. He is also a speaker at several conferences in Italy and in Europe.

Twitter: @spaghettidba
Website: https://spaghettidba.com

SQL Server Infernals – Circle 5: Inconsistent Baptists

by Gianluca Sartori

SpaghettiDBA

There’s a place in the SQL Server hell where you can find poor souls wandering the paths of their circle,...

2015-07-23 (first published: 2015-07-17)

2,945 reads

SQL Server Infernals – Circle 3: Shaky Typers

by Gianluca Sartori

SpaghettiDBA

Choosing the right data type for your columns is first of all a design decision that has tremendous impact on...

2015-07-10 (first published: 2015-07-02)

2,233 reads

SQL Server Infernals – Circle 4: Anarchic Designers

by Gianluca Sartori

SpaghettiDBA

Constraints are sometimes annoying in real life, but no society can exist without rules and regulations. The same concept is...

2015-07-07

833 reads

SQL Server Infernals – Circle 2: Generalizers

by Gianluca Sartori

SpaghettiDBA

Object-Oriented programming taught us that generalizing is a good thing and, whenever possible, we should do it. Complex class hierarchies...

2015-06-29 (first published: 2015-06-24)

991 reads

SQL Server Infernals – Circle 1: Undernormalizers

by Gianluca Sartori

SpaghettiDBA

There’s a special place in the SQL Server Hell for those who design their schema without following the Best Practices....

2015-06-17

884 reads

Announcing SQL Server Infernals

by Gianluca Sartori

SpaghettiDBA

Today I’m starting a new blog series called “SQL Server Infernals”.
Throughout this series, I will take your hand and walk...

2015-06-09

680 reads

Native Client Aliases don’t like Trailing Spaces

by Gianluca Sartori

SpaghettiDBA

I usually don’t post small things like this, but today I fought with this obnoxious problem long enough to convince me that...

2015-06-02 (first published: 2015-05-26)

1,579 reads

Counting the number of rows in a table

by Gianluca Sartori

SpaghettiDBA

Don’t be fooled by the title of this post: while counting the number of rows in a table is a...

2015-05-25 (first published: 2015-05-18)

9,276 reads

Tracking Table Usage and Identifying Unused Objects

by Gianluca Sartori

SpaghettiDBA

One of the things I hate the most about “old” databases is the fact that unused tables are kept forever,...

2015-04-29 (first published: 2015-04-20)

16,874 reads

How to post a T-SQL question on a public forum

by Gianluca Sartori

SpaghettiDBA

If you want to have faster turnaround on your forum questions, you will need to provide enough information to the...

2015-04-24

2,310 reads

Blogs

dataMinds Connect 2026 – Slides & Scripts

By Koen Verbeeck

You can find the slides and SQL scripts for my session “Spice up your...

How to Clear the SSMS Cache (SSMS 21 and Later)

How to Clear the SSMS Cache (SSMS 21 and Later) Updated...

The flight recorder: Replaying what an AI agent did on my SQL Server

“What exactly did it do on my server?” is the first question a DBA...

Read the latest Blogs

Forums

It's Never Just One Thing

By Grant Fritchey

Comments posted to this topic are about the item It's Never Just One Thing

Calculating Min-Max Normalization in PowerBI

By Dinesh Asanka

Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI

Checking the Error Log III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Checking the Error Log III

Visit the forum

Question of the Day

Checking the Error Log III

If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?

See possible answers