Today I received a mind-blowing award for my 200th tip at MSSQLTips.com.

In 2015, I wrote about a stored procedure to find strings within all tables across all user databases. In this follow-up tip, I enhance the procedure to optionally include views and search within specific databases.

I show how to piece together portions of SQL Server metadata to generate DBML (which is more useful than it sounds).

I wrote two tips around what you can do when a table that stores the same strings over and over again has grown to an unmanageable size: create a dimension table!

A recent documentation update raises questions about the love-it-or-hate-it READ UNCOMMITTED isolation level.

In this tip I show how I combine GROUPING SETS and PIVOT to get crosstab-style reports without Excel.

I talk about progress in aggregating strings – both in the functionality offered by SQL Server and the quality of my own code samples.

I harassed Erik Ejlskov Jensen enough to make me a universal command-line version of SqlQueryStress, and walk you through setting up a performance test between an Intel and M1 MacBook.

In this tip I show how indirect checkpoints can help improve performance and stability of more than just checkpoint operations themselves, and stifle some (but not all) problems. I conclude that you should proactively change this setting everywhere.

I show how I set up Azure SQL Edge in a Docker container on the new M1 MacBook.

See one way to use a queue table to spread out spiky, ad hoc deletes from a clustered columnstore index.

These functions aren't brand new, but they're in Azure SQL Database and Azure SQL Managed Instance, and they're coming to SQL Server 2022 soon.

See the new overloaded STRING_SPLIT() function with its enable_ordinal parameter, now available in an Azure SQL Database near you.

Every time I write a post about splitting strings, I promise myself it's the last one. I need to stop making that promise. In this tip, I show how I compared my previous favorite ordered splitting function to a different technique using OPENJSON().

I show one way to run arbitrary SQL against objects in an arbitrary database – using nested dynamic SQL.

Using PowerShell calling nested dynamic SQL that drives a cursor, I show one way to collect information about queries with index hints both in the plan cache and in stored procedures, views, and other modules.

After seeing multiple people switch from STRING_SPLIT() to OPENJSON() to deal with multiple parameters, I decided to explore whether that is a change in the wrong direction.

Updated this stored procedure I wrote a decade ago to search for a string in procedure bodies, object names, job steps, and more…

I talk about using partition switching to load in fresh versions of staging tables with the least impact to current users.

I made some landing pages here, with simple and easy-to-remember URLs, presenting sets of links to very frequently-discussed topics around SQL Server.