Friday, May 22, 2015

MSSQL Server 2016 coming with JSON Support

With over a thousand votes on the Microsoft Connect site, JSON support is the most requested feature for SQL Server 2016. This month, Microsoft announced that the upcoming release of SQL Server 2016 will fulfill that request. Sort of.

Microsoft will certainly be touting this feature as an additional reason to upgrade when the time comes. Natively supporting JSON helps bridge the gap between the desirable aspects of a NoSQL database and a relational database like SQL Server. The trouble is that with this current implementation, you're not really gaining anything over what's currently available. It's nothing like the native XML data type that became available starting with SQL Server 2005.

Read more at http://www.itworld.com/article/2925117/enterprise-software/mssql-server-2016-coming-with-json-support-not-really.html

1 comment:

  1. FOR JSON and OPENJSON are shipped first because they are the main ask in the connect item. Type is also important but it seems that it can be implemented with CLR (e.g. import Json.Net as assembly).The only things that you cannot implement using some CLR are FOR JSON and OPENJSON.

    ReplyDelete