Thursday, September 27, 2012

Breaking News: Packt finished publishing its 1000th Book

Aloha,

Packt is celebrating and I have been a part of this success story. Particpate in the celebration and get a free eBook to mark this occasion.

Just go to Packt's web site and register yourself if you are not already registered. The rest is simple.
If you are looking for jump starting your SQL Server / Applications you search for eBook versions of my books shown here:



Good luck
Mahalo

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