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,923 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,213 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

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

967 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

859 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

664 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,553 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,211 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)

15,040 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,252 reads

Blogs

T-SQL Tuesday #180: Good enough is perfect Roundup

By hellosqlkitty

This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...

Using SQL Compare with Read-only Access

Recently a customer asked if SQL Compare and SQL Data Compare can be used...

Off to Live 360

I am off to Live 360 today, on my last trip of the year....

Read the latest Blogs

Forums

how can i tell if our db2 driver is ms or ibm or other?

i see this in the definition of a linked server on our wh sql...

normal role member to be able to view list of other role members in his DB

Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...

Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code

By Mike McQuillan

Comments posted to this topic are about the item Stairway to Snowflake Level 5...

Visit the forum

Question of the Day

A Strange Result

What does this code return in SSMS 20 from SQL Server 2019?

select '|' + CHAR(0)+'abc' + '|';

See possible answers