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?

Dating Responsibly

Splitting strings

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

Can't remember No problem. If you can remember, 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.

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at SQLPerformance and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a father of two, a huge hockey and football fan, and my pronouns are he/him.