Storing JSON in a NVARCHAR(MAX) column? You can query it just like a table using JSON_VALUE and OPENJSON.
SELECT Name, JSON_VALUE(LogData, '$.IP') as LoginIP FROM Logs WHERE JSON_VALUE(LogData, '$.Status') = 'Failed';
This provides the flexibility of NoSQL with the strict ACID compliance of SQL Server. Best of both worlds.
