I live for questions and recently, I had someone ask me, does using SELECT * affect Query Store. My immediate gut reaction was, hell no. Of course it doesn’t....
2023-04-24 (first published: 2023-04-03)
387 reads
Your mission, if you chose to accept it, was to share a single tip/hint/fact/something that you wish you’d known about PostgreSQL when you were just getting started learning it....
2023-03-17 (first published: 2023-03-06)
107 reads
Last week I posted the results from using Extended Events to snoop on what happens inside an AWS RDS database. This week, I’m taking a look at what happens...
2023-03-06 (first published: 2023-02-27)
404 reads
Microsoft supplies quite a few knobs to control how Query Store performs data cleanup. You can set your cleanup various ways, and, they interact. Let’s talk about how and...
2023-02-22 (first published: 2023-02-06)
255 reads