Virtual Network Service Endpoints for Azure SQL Database is now generally available in all Azure regions.
By using Virtual Network Service Endpoints, you can allow traffic only from selected virtual networks and subnets, creating a secure network boundary for your data. Traffic from your virtual network to the services will always remain on the Microsoft Azure network backbone.
With the GA, we now support SQL service endpoints on the App Service Environment subnets.
Database compatibility level 140 is now the default for new databases created in Azure SQL Database across almost all public regions. As of this writing, there are already 539,903 databases in Azure SQL Database running in compatibility level 140. The biggest change is the enabling of the adaptive query processing feature family, but there are also query processing-related fixes and batch mode improvements as well.
We are delighted to announce the general availability of Database Scoped Global Temporary Tables for Azure SQL DB. Similar to global temporary tables for SQL Server (tables prefixed with ##table_name), global temporary tables for Azure SQL DB are stored in tempdb and follow the same semantics. However, rather than being shared across all databases on the server, they are scoped to a specific database and are shared among all users’ sessions within that same database. User sessions from other Azure SQL databases cannot access global temporary tables created as part of running sessions connected to a given database. Any user can create global temporary objects.
We are excited to announce the release of a new version of the Elastic Database Client Library for Azure SQL database supporting Java. The client library provides tools to help developers scale out the data tier of their applications using sharding, including support for multi-tenancy patterns for Software as a Service (SaaS) applications.
Azure SQL Database automatic tuning, industry’s first truly auto-tuning database based on Artificial Intelligence, is now providing more flexibility and power with the global introduction of the following new features:
Automatic plan correction
Management via T-SQL
Index created by automatic tuning flag
Automatic tuning is capable of seamlessly tuning hundreds of thousands of databases without affecting performance of the existing workloads.
We’re delighted to announce the availability of an expanded set of sample SaaS applications, each using a different database tenancy model on SQL Database. Each sample includes a series of management scripts and tutorials to help you jump start your own SaaS app project. These samples demonstrate a range of SaaS-focused designs and management patterns that can accelerate SaaS application development on SQL Database.
We are excited to announce that transactional replication to Azure SQL Database is now generally available (GA). This feature allows you to migrate your on-premises SQL Server databases to Azure SQL Databases with minimal downtime.
Azure SQL Database built-in intelligence will continuously monitor database usage, detect disruptive events that can cause poor performance, and generate an intelligent insights diagnostic log. The insights provided will consist of a root cause description of performance degradation and improvement recommendations where possible. You will be able to couple this feature with Azure Log Analytics, or a third-party solution for custom alerting and reporting capabilities.
Now available in Azure SQL Database, native scoring will allow you to score machine learning models generated by RevoScaleR or revoscalepy packages from Transact-SQL. The PREDICT function will allow you to score models as part of your transactions without calling an external language runtime.