JSON Support coming to SQL Server

One useful feature coming to SQL Server 2016 is the support for JSON. This makes sense since WebAPI is becoming popular and the default supported format is JSON.

The syntax is pretty much like the XML support inside SQL Server.
For example:
Select ...
From ...
For JSON PATH, Root('Orders')
Or
FOR JSON AUTO
Read more: http://blogs.msdn.com/b/sqlserverstorageengine/archive/2015/06/07/for-json-clause-in-sql-server-2016-ctp2.aspx

Comments

Post a Comment

Popular posts from this blog

SQL Server 2017 Installation Issue - VS Shell installation has failed with exit code 1638

Tried to install SQL Server on a new laptop and ran into this issue of unable to install VS shell. Followed this link to uninstall C++ runtime 2017 first and then SQL Server installation succeeded. https://dba.stackexchange.com/questions/190090/help-installing-sql-server-2017-vs-shell-installation-has-failed-with-exit-cod Remember to reinstall the C++ run time 2017 afterwards, so that VS2017 still works.
Read more

How to delete Windows.old folder in Windows 2012 R2

I have run into this issue several times and thought to write a post for it: http://social.technet.microsoft.com/wiki/contents/articles/15221.enabling-disk-cleanup-utility-in-windows-server-2012.aspx What you need to install is feature: Desktop Experience  This can also be done with  PowerShell 1.0:  Add-WindowsFeature -Name Desktop-Experience In PowerShell 2.0, you first have to import the appropriate module manually: Import-Module ServerManager Add-WindowsFeature -Name Desktop-Experience Then you can search for Disk Cleanup, and cleanup system installation files by following these steps: Open Disk Cleanup by clicking the Start button  In the search box, type Disk Cleanup , and then, in the list of results, click Disk Cleanup .  If you're prompted to choose a drive, click the drive you just installed Windows on, and then click OK . In the Disk Cleanup dialog box, on the Disk Cleanup tab, click Clea...
Read more

Move TFS Database to another SQL Instance

Some high level steps involved in moving TFS Database to another instance. Tuesday, March 28, 2017 3:13 PM iisreset /stop TfsServiceControl.exe quiesce tfsconfig remapdbs /databasename:{TFSServerName}\{SQLInstanceName};Tfs_Configuration /SQLInstances:{TFSServerName}\{SQLInstanceName} /AnalysisInstance:{TFSServerName}\{SQLInstanceName} /AnalysisDatabaseName:TFS_Analysis tfsconfig repairjobqueueTFSCOnfig Accounts /ResetOwner /SQLInstance:{TFSServerName}\{SQLInstanceName} /DatabaseName:TFS_Configuration TFSCOnfig Accounts /ResetOwner /SQLInstance:{TFSServerName}\{SQLInstanceName} /DatabaseName:TFS_Configuration TFSConfig RegisterDB /SQLInstance:{TFSServerName}\{SQLInstanceName} /databaseName:TFS_Configuration IISReset TFSServiceControl unquiesce
Read more