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
453 reads
SpaghettiDBA
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
618 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
246 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
889 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,008 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
989 reads
Blogs
Chatting with Power BI: Who Benefits from This Conversation?
By Rayis Imayev
"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t...
A Quick Look at Redgate Data Modeler
By Steve Jones
Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...
Prepping for Certification, Part 2 of ?
By Brian Kelley
The advantage of understanding the make-up of the exam: I can tailor my efforts...
Forums
SQL Server 2022 order by bug?
Hi, I was using order by on a column with characters and saw something...
SQL Server 2025 Build List
Comments posted to this topic are about the item SQL Server 2025 Build List
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Question of the Day
Getting The Database Name
I run this code to connect to SQL Server 2022 from the command line.
sqlcmd -S localhost -EAt the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME() GOWhat is returned? See possible answers