Daily Coping 15 Aug 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-08-15
8 reads
Blog Posts
Max server memory recommendations are just a suggestion
Some of you might know me because of the Max Server Memory Matrix, a chart I created based off a decade-old algorithm developed by Jonathan Kehayias. The chart has...
2022-08-15 (first published: 2022-08-03)
399 reads
Slides from SQL Saturday Los Angeles 2022
If you attended my talk at SQL Saturday Los Angeles 2022, then you can get my slides here: Adopting a DevOps Process for your Database.
2022-08-15
19 reads
SQL Homework – August 2022 – Replication part 1
You’ll hear a lot of people complain about replication. Including me. That said, replication is an amazing tool. There really ... Continue reading
2022-08-15 (first published: 2022-08-02)
256 reads
Daily Coping 12 Aug 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-08-12
11 reads
How to Fix the Error “MySQL is running but PID file could not be found”
One of our clients in Vietnam, his name is Son Vu, who is developing a website running on VPS (his homepage trainghiemmuasam.com) encountered an error that MySQL could not...
2022-08-12 (first published: 2022-08-01)
177 reads
Thank You Tim!
Ah, Tim Ford. I remember the time we were sitting at Ruth Kriss Steakhouse trying to figure out which of the two of us was the dumbest person in...
2022-08-12 (first published: 2022-07-26)
244 reads
Daily Coping 11 Aug 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-08-11
11 reads
My Toolbox - Greenshot
Foreword
A picture is worth a thousand words. I use screenshots daily, whether it’s to share results, how-to tutorials, point out mistakes or create memes.
None of the tools I’ve tried...
2022-08-11
45 reads
VS Live Microsoft HQ Slides and Code
Thanks to everyone that attended my sessions today at VS Live. I have my slides and code available for download at the VS Live site and here. The Serverless...
2022-08-11
16 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
When SQL Server Central Went Down
Comments posted to this topic are about the item When SQL Server Central Went...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers