Developers often dispute the merits of SQL as a legitimate programming language, but this misses the point. SQL is a powerful 4GL for accessing data.

I'm trying to implement full-text searching against a database with a large number of relevant columns (think searching through user profiles with a bunch of valid fields). For my initial stab at ...

With SQL Server 2016, it now makes sense to store JSON objects in your database (even though there’s no JSON datatype). Here’s how to query JSON properties to find the rows you want.