Consolidating links and resources
For a long time, I have been seeing the same SQL Server questions and topics come up over and over again on Stack Overflow and Database Administrators. Two decades ago, I started blogging to reduce the amount of work I was doing to help guide users to the right solutions (except, back then, it wasn't Stack Exchange, it was newsgroups and the occasional mailing list). Anyway, not much has changed. I've written a lot of content to avoid repeating the same long-winded answers time and again and, over time, this made it more tedious to track down links to authoritative or canonical posts about a specific topic.
I took a little break from Q & A this year. When I got back into it more recently, I discovered I was once again scrambling to assemble the right (and most current) links for, say, advising people to stay away from
MERGE. So, I made some landing pages here, with simple and easy-to-remember URLs, presenting (and sometimes explaining) a small set of links to further reading on the topic. So far, these are the landing pages I've put together:
Bad Habits & Best Practices
So, you want to use MERGE, eh?
I'm using NOLOCK; is that bad?
Using SQL Server on a Mac
Resources for Dynamic SQL
AddWithValue adds no value
SQL Server 2022 Resources
Asking good database questions
sqlblog.org/split? No problem. If you can remember
sqlblog.org, it's going to be pinned to the home page.
Personally, I use a program called Unclutter on my Mac as an effectively infinite clipboard, and have the URLs stored there permanently, even though I doubt I'll ever forget any of these ones. If you find you're searching for a URL more than once, it might be handy to use some kind of productivity app.