Today, the product manager on the SQL Azure Technical Marketing team Gregory Leake, announced updates made to Azure SQL Database.
The four mentioned updates are:
- SQL Server support for Linked Server and Distributed Queries against Windows Azure SQL Database,
- Recursive triggers are now supported,
- DBCC SHOW_STATISTICS is now supported,
- Configure database level firewall rules.
Linked Server and Distributed Queries
From an integration point of view this might be the “long” awaited feature. The blog post by Gregory is clear about the direction of integration… query against an Azure SQL database as only the SQL Server box product contains the “Distributed Query” feature.
Previously to get a distributed query like approach to work you had to use the ODBC-to-OLEDB proxy which is not recommended from a performance point of view.
As I mentioned, for an integration point of view it might be the “long” awaited feature. But if you still have doubts about having all your data in the cloud than this feature is another option in your hybrid cloud toolset. With this option added you can now keep your sensitive data on-premise and include data from your cloud hosted application.
I think, this is one of the “don’t try this at home folks” features but I am sure there are some legitimate reasons to have recursive triggers in your app. At any rate, this feature is now available.
Directly taken from Gregory’s blog post:
“DBCC SHOW_STATISTICS displays current query optimization statistics for a table or indexed view. The query optimizer uses statistics to estimate the cardinality or number of rows in the query result, which enables the query optimizer to create a high quality query plan.”
Configure SQL Database Firewall rules at the Database level
Up till now, you could only setup server level firewall rules using the portal or T-SQL commands. Now you have the option to set firewall rules at the more granular database level, with different rules for different databases hosted on the same logical SQL Database server.