The Microsoft Connect site is the place where you can leave your feedback, suggestions, and wishes for Microsoft products. The most popular feature request for SQL Server is the one for JSON support. It was created in June 2011 and at the time of writing (October 2017) it has 1,138 votes. The request is still open, as you can see in the following screenshot, and you will see later in this chapter, why it still makes sense to have it in the active state:
Highly ranked requests for SQL Server on the Microsoft Connect site (October 2017)
What arguments are used by community members to justify the request? They are as follows:
- JSON is already standard, and it should be supported, similar to XML.
- Other vendors support it (Oracle, PostgreSQL, and others)
- Due to the lack of JSON support, my customers want to move from SQL Server to other database systems supporting JSON...