Viewing 15 posts - 1 through 15 (of 148 total)
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"...
October 19, 2024 at 7:50 am
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"...
October 19, 2024 at 7:49 am
On a side note, I really liked how you labeled the toolbar buttons half above and half below.
Thanks for the feedback, Robert. Totally appreciated.
July 7, 2023 at 3:38 pm
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...
April 15, 2023 at 7:30 am
Thanks so much for the feedback, David. I will very likely do another article on "Access-Oriented Security Mechanisms"
April 15, 2023 at 5:53 am
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...
March 20, 2023 at 4:49 pm
This reply has been reported for inappropriate content.
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...
January 3, 2023 at 9:45 am
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...
October 17, 2022 at 7:47 am
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...
July 23, 2022 at 7:58 pm
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...
July 8, 2022 at 10:25 am
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...
June 13, 2022 at 9:22 am
#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...
June 11, 2022 at 3:58 pm
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.
June 10, 2022 at 11:11 am
Thanks for the article.
The photo on licensing caught my attention. The $209 for Standard - CAL. Is that per user? What would constitute a user?
April 11, 2022 at 8:02 am
Interesting analogy here. And quite on point. Thanks so much, Steve.
On microservices, some points of view are that traditional RDBMSes do not quite fit into the design pattern. That each...
November 12, 2021 at 9:55 am
Viewing 15 posts - 1 through 15 (of 148 total)