You’ve been working with Microsoft SQL Server for yeeears, and you’re pretty confident that you know how to write a query.
So when I tell you about a book called T-SQL Fundamentals, you’re all, “nah, man, I got this covered.”
You are incorrect.
Sure, the first 5 chapters of the book are about 1-2 table queries, CTEs, subqueries, etc, and you’ve probably got that stuff down cold. But here’s where chapter 6 and 7 go:
And subsequent chapters only get more detailed from there: how to properly modify data with transactions in mind, temporal tables, and more.
When you start your 3rd year of working with T-SQL, this is the book your manager should hand you. By that point, you’ve learned enough about querying that you’re getting cocky, and yet there are so many more awesome possibilities available to you.
And if you’re the one who’s the manager – if you have junior folks on your team – then it’s your responsibility to hand Itzik Ben-Gan’s book T-SQL Fundamentals to your team. They’re not getting any smarter on their own, and every day that they don’t read this, they’re producing more inefficient technical debt that you’re going to have to go back and fix later.