Wednesday, September 26, 2012

New service update for Azure SQL database

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
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
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
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
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 ArticlesSQLCached - Similar
... 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
by Jayaram Krishnaswamy | August 2009 | .NET Microsoft. Linking servers provides an elegant solution when you are faced with running queries against ...