In this final post of our four-part JSON series, we showcase the ability to format query results as JSON text using the FOR JSON clause. If you are familiar with the FOR XML clause, you will easily ...

Native support for JSON in the upcoming SQL Server 2016 was buried among the many goodies announced earlier this month for the flagship RDBMS, but it's the feature most requested by data developers, ...

CREATE INDEX idx_Person_1 ON Person(vCompany) As you can see, SQL Server provides a hybrid model where you can put values from JSON either in key or included columns and uses both JSON values and ...

Flat File Import into SQL Server Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server.

SQL Server 2016 is expected to offer native support for working with JSON. The first iteration of this support will be released as part of SQL Server 2016’s CTP 2.

Converting Microsoft SQL server databases to No SQL thus making them convertibleto JSON. And converting CSV data into JSON via python and then exporting them to MongoDB and then converting them to SQL ...