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,933 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,226 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

818 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)

977 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

867 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

669 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,558 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,256 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,336 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,281 reads

Blogs

PowerPoint to HTML with Claude AI

I had an idea for an animated view of a sales tool, and started...

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!

By Klaus Aschenbrenner

Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...

Monday Monitor Tips: SQL Auditing Preview

One of the features we advocates have been advocating for is a better way...

Read the latest Blogs

Forums

Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()

By Bill Pearson

Comments posted to this topic are about the item Level 28: DAX Text Functions:...

Creating JSON I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating JSON I

Expensive CPUs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Expensive CPUs

Visit the forum

Question of the Day

Creating JSON I

On SQL Server 2025, what happens when I run this code:

SELECT JSON_OBJECTAGG( 'City':'Denver')
GO

See possible answers