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



No comments:

Post a Comment

Do you know what you installed while custom installing SQL Server 2022?

 When you install any software in Windows OS, the key information gets into the Registry and some of which you can look up in the control pa...