Microsoft Updates Windows Azure SQL Database
Microsoft recently added four new features to its Azure SQL Database, offered as a solution for enterprise apps and hybrid applications hosted in an Azure cloud as well as on-premise. In the latest update, Microsoft gave the database:
- Support for native distributed queries
- Recursive triggers
- Support for DBCC SHOW_STATISTICS
- Support for firewall rules at the database level
Distributed queries are not exactly new for Azure SQL, but they required the ODBC-to-OLEDB proxy in previous versions. The feature enables users to run queries across local and remote servers defined as "linked servers". The update allows users to simply define every Azure SQL database with the exception of the virtual master as a linked server.
Additionally, the database solution now supports query optimization statistics for a table or indexed view that is shown via DBCC SHOW_STATISTICS. According to Microsoft, users should be able to use this feature to create a high quality query plan. Admins can also use the management portal or T-SQL commands to configure the SQL database firewall at the server level.
Wolfgang Gruener is a contributor to Tom's IT Pro. He is currently principal analyst at Ndicio Research, a market analysis firm that focuses on cloud computing and disruptive technologies, and maintains the conceivablytech.com blog. An 18-year veteran in IT journalism and market research, he previously published TG Daily and was managing editor of Tom's Hardware news, which he grew from a link collection in the early 2000s into one of the most comprehensive and trusted technology news sources.
See here for all of Wolfgang's Tom's IT Pro articles.