Grand Bonne
I know what you’re thinking: Who cares about that free database?
Well, it’s not necessarily the Postgres part that you might care about, but more the fact that a third party is developing software to do what major vendors aren’t doing.
This sort of thing might come to SQL Server someday, and it probably should. The self-tuning features in Azure are ass.
Thanks for reading.
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.
Aren’t you afraid that robots will take your work from you?
I pray every day that they do.
Interesting video – seems that MS are quite well advanced in this area actually. A more complete set of metrics. QueryStore available not only for SQL Server but also MySQL & PostgresSQL. Next version of Querystore (2022) will persist information to be able to re-apply learnings to survive restarts. Auto tuning in Azure already using a copy of the data with the real workload and measuring if a change is beneficial or detrimental & keeping or rolling back as appropriate. I think it depends on whether you take the standpoint of – it’s not as good as Erik, Brent or Pedro or whether you compare to Joe Spud, python developer 1 year out of college.
I disagree about MS being advanced in this area. I’ve seen what the auto tuning features do and they’re 🤷‍♂️ at best.
Great content as always! Thank you! Postgres has always been my weakness