Deeply insightful. Actual = Estimated (in context). Thanks for sharing.

Very practical article. Well written! Thank you.

Great article and great to read from you, Sir.

You know I used to make a joke that we changed the meaning of the acronym NoSQL from "No Structured Query Language"...

Great article and great to read from you, Sir.

You know I used to make a joke that we changed the meaning of the acronym NoSQL from "No Structured Query Language"...

Thanks for the feedback, Robert. Totally appreciated.

Thanks for a thought-provoking article, Ryan. Good info on adoption of SQL Server. And my deepest condolences to Sir Moore's family. Great life lived.

On Moore's Law, is it inaccurate to say...

Thanks so much for the feedback, David. I will very likely do another article on "Access-Oriented Security Mechanisms"

Thanks for the feedback, Wayne! Great idea for a new article. Been quite a while ago.

PS: Interestingly, while writing it I did wonder whether anyone was actually still using PerfMon...

Thanks for sharing, Mike.

My understanding is that you have explained that indexes with low selectivity columns can still be useful as the first column in a multicolumn index. This is...

Interesting proposition. I take it that the reference to real data being unavailable refers to the "CPU Cycles" aspect. There are some simple tests that could contribute to the conversation...

Hi Kenneth, I tried following your talk, my sql is 2016, I chose the sql template when I hit finish Powershell opens then it errors I see text in...

Quite contrary to popular belief, index REBUILDs are NOT a problem compared to REORGANIZEs.

Here's just one example.  I had a table that had an ever increasing Clustered Key that...

The author of this article recommends that shrinking the log file is a solution to this issue - but the log file has grown because of transactional activity. Unless...

#3 in your recommendations is incorrect.  If your database is set to full or bulk-logged recovery models - you absolutely need to be running frequent transaction log backups.

If you...

Very true @CozzaroNero. Best to understand the database behaviour and plan for the optimal transaction log  size. Shrink is a quick fix if one gets into trouble.