If you’re the kind of person who likes to read books, here are some that I think would expand your horizons. These links are Amazon affiliate links, so I make a few cents when you buy through ’em. It’s your way of tipping me for the book recommendations, so thank you!
- Level 1: T-SQL Fundamentals by Itzik Ben-Gan: with a name like “Fundamentals”, you’re gonna think this book will be easy. It’s not. It’s 361 pages of the stuff I should have learned before I wrote my first query, but didn’t.
- Level 2: T-SQL Querying (Developer Reference) by Itzik Ben-Gan: after you’ve finished Fundamentals, here’s 803 pages of pivoting, windowing, dates/times, BI, graphs, in-memory OLTP, and more.
- Great Post, Erik by Erik Darling: if you’ve enjoyed Erik Darling’s blog posts here, then you’ll love a book full of ’em, lavishly illustrated in full color. (The first time I held this book, I was amazed at what a difference full color makes when viewing stuff like queries and plans.)
Performance Tuning Books:
These first two are both overviews of performance tuning, covering wide swaths of the tools built into SQL Server to assess its existing performance and make it go faster. I do have to caution you, though: they’re not step-by-step cookbooks that give you recipes to take an existing server, understand what’s wrong, and make it go right. They’re more of a collection of techniques, and it’s up to you to put things together in the right order. They’re still both good resources though:
- Learn T-SQL Querying by Pedro Lopes and Pam Lahoud: probably the worst-named book out there, and the sales are probably being hurt even more by the publisher not allowing you to read the table of contents on Amazon. Trust me though, the authors cover a lot of ground in 450 pages of performance tuning tips.
- SQL Server 2017 Query Performance Tuning by Grant Fritchey: don’t worry about the version number in the name. Some publishers just insist on putting version numbers in titles to make books seem new, which on the flip side, also makes them seem dated a few years later. This 823-page monster is mostly evergreen.
Then the below are a little more specialized, talking about specific features that you may wanna learn:
- Query Store for SQL Server 2019 by Tracy Boggiano and Grant Fritchey: again, ignore the version number in the title and just focus on the topic. Query Store is like a flight data recorder for SQL Server 2016 & newer, and now that most of you are running 2016 in at least one of your servers, it’s probably time to dig in to learn how this works. This is one of those features that sure as hell isn’t self-managing, and I know a lot of clients who’ve turned it on without learning it – only to have their workloads stop workloading. Learn it first.
- SQL Server 2019 Revealed by Bob Ward: go read the documentation page of What’s New in SQL Server 2019. If you want an entire book of that, that’s what this book is. In February 2020, I’m gonna be honest: most of you aren’t deploying SQL Server 2019, let alone using the new features like Always Encrypted with Enclaves, Kubernetes, and Polybase. However, if like me, you’re just generally curious about the investments Microsoft is making, this is an enjoyable read.
I don’t have current book recommendations for production database administrators: folks who specialize in installation, configuration, high availability, disaster recovery, and automation. If you’ve found current (and currently available) books on that topic that you enjoy, drop ’em in the comments for others to find.
What? What? Your book was always in the blog post above. The whole time. You just didn’t look closely enough. (fidgets nervously)
I think this “sql-server-execution-plans-3rd-edition” By Grant Firtchey also good for SQL Server Execution plan (https://assets.red-gate.com/community/books/sql-server-execution-plans-3rd-edition.pdf)
It’s amazing. It’s stupendous. It’s mostly because of Hugo Kornellis. Ha! Teasing, except about Hugo. Thanks!
Shit, no “complete show plan operators” in the list… I guess I’ve to write another one that is really complete :-)…
Very nice list btw!
Thanks! Hugo’s working on a web site with that. Hover over the SQL Server Execution Plan Reference at the top for the list of topics: https://sqlserverfast.com/
Brent, I have to agree with Fabiano Amorim. The “Complete Show Plan Operators” is a great book and deserves to be part of this list!
Cool, that’s what the comments are for – y’all’s book recommendations. Glad to hear it!
I found “Pro SQL Server Always On Availability Groups” by Uttam Parui (Author), Vivek Sanil (Contributor)
to be a really good read for taking someone new to AOAG through the process of setting them up, and the various options you have. I have recommended it to a number of people.
Pro SQL Server Internals By Dmitri Korotkevitch
I’d second this recommendation
“Pro SQL Server Always On Availability Groups” by Uttam Parui (Author), Vivek Sanil (Contributor)
“Refactoring Legacy T-SQL for Improved Performance” by Lisa Bohm.
For all lovers free ebooks: https://github.com/ktaranov/sqlserver-kit#free-ebooks
Especially recommend Inside the SQL Server Query Optimizer (by Benjamin Nevarez) (it is 2010 year but very useful)
Thanks for the shout out, and the feedback! We can’t change the title, but we were able to work with our publisher to sort out the TOC issue on Amazon. There’s now a high-level topic listing in the description and they have added “Look inside” so you can read the entire detailed TOC.
Pam – you’re welcome! Great job on the book. Y’all rocked it.
Some one please tell me if Itzik Ben-Gan is updating his Querying and Programming books.
Send him an email and ask him.