Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

Such a user-defined data type is considered a complex type in SQL-99. Once you define the new type in the SQL Server catalog, you can use it as a column in a table.

If screaming speed in data access is the most important thing in your life, SQL Server's durable in-memory, memory-optimized tables are your answer. They were good in SQL Server 2014 and they're even ...

SQL Server 2022 takes that ability a few steps further. Last year, I wrote a column on the introduction of query store hints into Azure SQL Database.