SQL Server does support JSON, but not at a persisted data format. It provides features to export relational data in a JSON format, and to parse it into columns, but there is no native JSON support.

SQL Server 2019 builds on intelligent query processing features that were implemented in SQL Server 2017, and expands them to new areas of the database engine. Let's take a deeper dive into some ...

Early discussions on SQL Server 2008 seemed to suggest that it would really only be a point release, quite unlike what occurred with SQL Server 2005. Anyone looking at the new and upgraded features in ...

4. Multi-Server Queries: being able to submit a batch of queries against multiple servers simultaneously. Multi-Server Queries – a nice touch in SQL 2008 3.

In early November 2021, Microsoft announced the private preview of its flagship database product, SQL Server 2022. At some point in 2022, we will see SQL Server 2022 released as a general availability ...

SQL Server 2022 is a core element of the Microsoft Intelligent Data Platform and now it comes with new features. The platform seamlessly integrates operational databases, analytics, and data ...

In this blog entry I will examine my 3 favorite new features that show how SQL Server 2014 provides high-performance OLTP, optimization of business analytics and migration of data to the cloud.