Database Administration KPIs – 2/2
In my last post, I discussed about the quantitative KPIs which, to me, are useful for “outsiders”, i.e. non-DBAs, to...
2013-05-10 (first published: 2013-05-04)
5,212 reads
Visionary: Seeing Through Defects
Joe Lacob bought the struggling Golden State Warriors NBA franchise in 2010. He has been the most hated man by...
2013-05-03
823 reads
SQL Saturday 232 Orlando Call for Speakers!
Hello Dear Reader! We are at that time of the year again. SQL Saturdays are popping up all over the...
2013-05-03
888 reads
Speaking at SQL Saturday Atlanta
WOW! SQL Saturday Atlanta this year is turning into one of the largest SQL Saturdays ever! I’m absolutely honored and pumped to...
2013-05-03
658 reads
Reblog: April 26 to May 2
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-05-03
1,079 reads
Use the Default System Trace to Find Autogrowth Events
The SQL Server Management Studio built-in standard report for "Disk Usage" is very handy to view the performance-sucking autogrowth events...
2013-05-03
2,433 reads
Hunt Down Tables Without Clustered Indexes
This one's a gimme, but an underrated utility script when I enter a new environment and look for low-hanging fruit...
2013-05-09 (first published: 2013-05-03)
2,599 reads
Comparing an inner join vs a subquery
I was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing...
2013-05-08 (first published: 2013-05-03)
5,930 reads
The Activity Monitor is unable to execute queries against the server !
I’m generally not a great fan of Activity Monitor which is built in with SSMS,however today I wanted to check...
2013-05-02
3,448 reads
Want me to do a presentation?
I greatly enjoy doing presentations on a variety of topics, such as Business Intelligence, SQL Server, and personal development. If you...
2013-05-02
718 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Alamat BCA KCP Tmn. Harapan Indah Telp:0821°8200°233
Telp/Wa 628218200233 Komp. Taman Harapan Indah Blok EE No.1, RT.14/RW.7, Jelambar Baru, Kec. Grogol...
Alamat BCA KCP Rajawali Telp:0821°8200°203
Telp/WA 628218200203 Rukan Multiguna, Jl. Rajawali Selatan Raya Blok C5. 2, Blok 2, Pademangan...
Alamat BCA KCP Mangga Dua Mal Telp:0821°7555°651
Telp/Wa 628217555651 Mal No. RM, Jl. Mangga Dua Raya No.49, RT.1/RW.12, Mangga Dua Sel.,...
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers