2014-09-25 (first published: 2010-12-23)
26,176 reads
Gianluca Sartori
- Twitter: @spaghettidba
- Website: https://spaghettidba.com
Database Free Space Monitoring – The right way
Lately I spent some time evaluating some monitoring tools for SQL Server and one thing that struck me very negatively...
2014-09-05
465 reads
Announcing ExtendedTSQLCollector
I haven’t been blogging much lately, actually I haven’t been blogging at all in the last 4 months. The reason...
2014-07-22
632 reads
Hangout #18 with Boris Hristov
Yesterday evening I had the honour and pleasure of recording one of his famous SQL Hangout with my friend Boris Hristov (b|t).
We...
2014-04-18
263 reads
Uniquifiers: all rows or the duplicate keys only?
Some days ago I was talking with my friend Davide Mauri about the uniquifier that SQL Server adds to clustered...
2014-03-14
917 reads
Verdasys Digital Guardian and SQL Server
I’m writing this post as a reminder for myself and possibly to help out the poor souls that may suffer...
2014-02-03
1,063 reads
Non-unique indexes that COULD be unique
In my last post I showed a query to identify non-unique indexes that should be unique.
You maybe have some other...
2014-01-30
1,011 reads
Understanding T-SQL Expression Short-Circuiting
Understanding the basics of how T-SQL logic works in branching is important to ensure you code works as expected. This article will help you learn how this impacts control of flow language.
2013-06-21 (first published: 2010-12-30)
34,001 reads
Dealing with custom date formats in T-SQL
Should I be formatting dates on the database side? What tools can I use in SQL Server to format and parse dates? This article helps you decide which one best suits your needs.
2012-03-23
25,638 reads
Setting up linked servers with an out-of-process OLEDB provider
There is an inprocess setting for linked servers. Have you ever used it? Gianluca Sartori gives a look at what the implications are for this.
2011-06-09
24,613 reads
Blogs
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
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