Here’s the announcement – and Microsoft SQL Server Developer Edition is now free! Is it big news? Yes, but if you’re a developer the question of whether to favour an upgrade in due course is more nuanced than it used to be.
The JSON has landed (in beta at least) – and I think it’s now some practical use. I’ve collected a few technical references here. There may not be a native JSON type yet, but there are workarounds to provide the kind of assurance control-freak RDBMS developers find comforting. I’ve shown some of them in the […]
Please note: CTP2 has been superseded. See this post for information about JSON in Sql Server CTP3.2 This post is a quick tour of JSON Support in Sql Server 2016. Three key points: 1) There won’t be a native JSON type, instead it will be represented as an nvarchar. 2) There is no BSON or […]
“Stretching” the database now means migrating some or all data from local database tables into the Azure Cloud. The result is a hybrid design: each local table then has a counterpart in the cloud. Any query against the local table will be transparently re-written to include data from the “cloud table”.