Azure SQL Updates
Azure SQL Updates
Written by Kay Ewbank   
Wednesday, 26 September 2012

New features have been added to the Windows Azure SQL database through service updates.

Microsoft has deployed service updates to Windows Azure SQL Database that add new features. The database now has support for linked server and distributed queries against the database, and you can now use recursive triggers. On the admin side, DBCC SHOW_STATISTICS is now supported, and you can configure firewall rules at the database level.

The support for linked server and distributed queries means you can add an Azure database as a linked server then use it as a data source for linked queries that take data from both local on-premises and cloud data. Until now you if you wanted to write a query like this you had to use the ODBC-to-OLEDB proxy, which was “not recommended for performance reasons” (to put it mildly).

 

 

The changes to the firewall add more granular control; until now you could only set Azure firewall rules at the server level, but the changes allow you to set the rules at database level using either the management portal or T-SQL, and have different rules for different databases hosted on the same logical SQL Database server.

 

azure

More Information

Linked Servers (Database Engine)

Related Articles

New Azure Services for Hybrid Cloud

 

blog comments powered by Disqus

 

To be informed about new articles on I Programmer, install the I Programmer Toolbar, subscribe to the RSS feed, follow us on, Twitter, Facebook, Google+ or Linkedin,  or sign up for our weekly newsletter.

 

Banner


Be Counted In the Next VisionMobile Survey
20/04/2016

After the recent publication of its 2016 Q1 report, VisionMobile is already gathering data for the next report, which will cover the languages and tools we are across six sectors mobile, cloud, deskto [ ... ]



GNU Gneural Network - Do We Need Another Open Source DNN?
12/04/2016

Everyone who is anyone needs their own neural network package and GNU, not to be left out of the action, has just released version 0.8.0 of Gneural - what else would they call it? Is this just a gestu [ ... ]


More News

 

Last Updated ( Wednesday, 26 September 2012 )
 
 

   
RSS feed of news items only
I Programmer News
Copyright © 2016 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.