Azure SQL databases in logical servers, elastic pools, and managed instances

Azure SQL Database is a Database as a Platform service designed for applications that will use database as self-contained service. Databases can be grouped together to simplify management options or share the resources. There are different options that can be used to bound databases in the groups, which will be explained in this post…. Read more

JSON is Generally available in Azure Sql Database!

JSON functionalities are now generally available in Azure Sql Database! All functions that are available in SQL Server 2016 are also available in Azure Sql Database. Azure Sql Database enables you to get values from JSON documents using JSON_VALUE function, modify values in JSON text using JSON_MODIFY function, transform JSON to table using OPENJSON function… Read more

JSON is available in Azure SQL Database

JSON functionalities that are added in SQL Server 2016 are also available in Azure SQL Database see Public preview: JSON in Azure SQL Database. All functionalities that you can use in SQL Server 2016 RC (i.e. FOR JSON, OPENJSON, built-in functions) are also available in Azure SQL Database, including JSON_MODIFY function that is added in RC… Read more

What’s new for In-Memory OLTP in SQL Server 2016 since CTP3

SQL Server 2016 is making a lot of enhancements to In-Memory OLTP to make it easier to use and perform even better. In a previous post I listed all the new features that had been included in SQL Server 2016 up to and including CTP3. But we have added a lot of new features since then, including… Read more