Windows Azure SQL Database Service Update

In a recent update to the Azure SQL database service the following features were added:

• Support for linked servers-
• Distributed Queries against the database-local & Azure databases
• Support recursive triggers
• Support for DBCC Show_Statistics

Firewall configuration at database level (previously at Server level)-You get better control

Firewalls can be set up at the portal or through T-SQL-makes life easier.

 

If you want to look at earlier service updates you can find them in my book:

 

 

Links to linked server, distributed queries etc. here,

 

MySQL Linked Server | Jayaram Krishnaswamy

jayaramkrishnaswamy.sys-con.com/node/1060191

You +1'd this publicly. Undo

Aug 4, 2009 – Jayaram Krishnaswamy is a technical writer, mostly writing articles that are related to the web and databases. He is the author of SQL Server ...

 

MS Access Linked Server, comparing providers | Jayaram ...

jayaramkrishnaswamy.sys-con.com/node/1004765Cached

You +1'd this publicly. Undo

Jun 16, 2009 – In this article on SSWUG.org web site, the MSDASQL OLE DB ODBC driver is compared with Microsoft Jet 4.0 as related to creating a linked ...

Microsoft Jet or MSDASQL for Linked Servers? | Jayaram ...

https://jayaramkrishnaswamy.ulitzer.com/node/1064612Cached

You +1'd this publicly. Undo

Aug 7, 2009 – Jayaram Krishnaswamy is a technical writer, mostly writing articles that are related to the web and databases. He is the author of SQL Server ...

 

Latest Articles in the Category SQL

dotnetslackers.com/articles/sql/?page=1&sort=2Cached

You +1'd this publicly. Undo

Jayaram Krishnaswamy, May 21, 2009. Views: 18,484 Avg Rating: 0/5 Votes: 0 Comments: 0. This article explains how to set up a Postgres linked server on SQL ...

Creating a linked Postgres Server on SQL Server 2008

dotnetslackers.com › Recent Articles › SQLCached - Similar

You +1'd this publicly. Undo

... on SQL Server 2008. Published: 21 May 2009. By: Jayaram Krishnaswamy. This article explains how to set up a Postgres linked server on SQL Server 2008.

MySQL Linked Server on SQL Server 2008 | Packt Publishing

www.packtpub.com › Articles › .NETCached - Similar

You +1'd this publicly. Undo

by Jayaram Krishnaswamy | August 2009 | .NET Microsoft. Linking servers provides an elegant solution when you are faced with running queries against ...