Product and service reviews are conducted independently by our editorial team, but we sometimes make money when you click on links. Learn more.

Microsoft Updates Windows Azure SQL Database

By - Source: Toms IT Pro

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 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.

Microsoft recently added four new features to its Azure SQL Database.Microsoft recently added four new features to its Azure SQL Database.

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 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.

VIDEO: Big Data, Big Hardware, Big Software

VIDEO: Data Center Convergence

VIDEO: Cloud Services: No Buzz, No Bull

Moore’s Law In Pictures: An Illustrated History of the Microprocessor

Slideshow: Server Processor Milestones

VIDEO: Quick Look - Intel S2600IP Motherboard

VIDEO: Cloud Services: No Buzz, No Bull