I’m pleased as punch to be able to share with you the fact that I helped Tracy Boggiano write a whole new book on Query Store. It will be available in October. You can pre-order it now.
Tracy is a great author and a serious scholar of SQL Server. She’s put together an excellent resource on Query Store. I added a couple of chapters just to help her out, but this is truly her book.
Query Store is incredibly simple to use. It is however a bear to manage, so getting Tracy’s book is a must if you’re going to be implementing Query Store on your databases. By the way, you really should be implementing Query Store on your databases.
Tracy covers all the topics from reporting with Query Store, to running it in Azure, to working with automatic plan regression fixes. If you want to know about Query Store, this is a unique resource that is more complete than any other source. I strongly recommend you get a copy and I’d say that even if my name wasn’t on the cover.
Will this be available as a Kindle eBook?
Yes. It will be.
Excellent. I believe Tracy mentioned this in her email to about speaking at our User Group in October. Great timing!
You going to make her schlep copies of the book?
Hi Grant, are the automatic plan regression fixes explained in the book also applicable to Azure SQL database ?
The last good plan mechanism is in Azure SQL Database too, yes. Here’s Microsoft’s docs on it: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automatic-tuning