Most of the new features are new database tools, etc.  That has always
been a strong point with SQL server.  IMO, the weak point of the
database (aside from the vendor and the price), is a lack flexibility of
the client APIs and the stored procedure syntax.  

The interesting features are the xml querying, recursive querying, and
'multiple active results sets'.  I think MS is laying down a more
relational foundation which would allow for such features.  They have
been working on this product for years and years...it will be fun to see
how it turns out.

Merlin

Tue, 10 Feb 2004 08:18:30 -0500
"Merlin Moncure" <merlin.moncure@rcsonline.com>
Re: MS SQL features for new version
Yes MS tools for MS SQL have always been there strong point. Easy to get
started and get things going quickly. I on the other hand have never ran
into a lack of flexibility with the client APIs or the stored procedure
syntax.

In all cases I have encountered we have turned away from MS SQL because the
scalability and high availability options have been weak to non existent.

Keith

-----Original Message-----
From: pgsql-hackers-owner@postgresql.org
[mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Merlin Moncure
Sent: Tuesday, February 10, 2004 7:19 AM
To: shridhar@frodo.hserus.net
Cc: PostgreSQL-development
Subject: Re: [HACKERS] MS SQL features for new version


Most of the new features are new database tools, etc.  That has always been
a strong point with SQL server.  IMO, the weak point of the database (aside
from the vendor and the price), is a lack flexibility of the client APIs and
the stored procedure syntax.  

The interesting features are the xml querying, recursive querying, and
'multiple active results sets'.  I think MS is laying down a more relational
foundation which would allow for such features.  They have been working on
this product for years and years...it will be fun to see how it turns out.

Merlin

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly


Tue, 10 Feb 2004 09:15:07 -0600
"Keith Bottner" <kbottner@comcast.net>
Re: MS SQL features for new version