Consolidating links and resources

For a long time, I have been seeing the same SQL Server questions 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 mailing lista).

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 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, you can probably remember, or just come to the home page and click on "shortcuts" in the top nav.

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. If I've helped you out, consider thanking me with a coffee. :-)