I was going to put
my foot down on this until i read this line
"Depending on your ability to make use said features, your
mileage may vary"
There two things
every developer should look at when features are listed in a Software
Product.
1. Are those
features really practical and applicable in ones use case - its like telling me
your car can move at 300 mph and drag and elephant accros sahara on a gallon of
gas - when am i ever going to get an opportunity to do that?
2. Do those
features actually work as well as supposedly stated by the vendor. I this case
when i say work i really mean something like this... am i gonna be able to
replicate one terrabyte of data halfway accross earth and it takes me 36hrs
especiall if am using one of SQLservers relication such as snap shot. might as
well do an SQL dump of the data and fedex it to the remote location and have it
imported back in. nuff said.
Now in many cases
without going into details, SQL Server (in general) has come short of
expectations. Just a quick comment. Packing features into a product causes it t
become bloated and thats why we have what we call plugins. A good product
has all the necessary stuff one needs and the addition candy supplied as
a pluggin. Now with RDMS like MYSQL it has been deliberately stripped
off some of the features to make it as robust as it is today... Wait.
here's the catch. some of the features have also simply been moved
into various storage engines so the developer has the ability to choose
what engne and features they need.
I'll stop
there
Steve Obbayi,
From: skunkworks-bounces@lists.my.co.ke
[mailto:skunkworks-bounces@lists.my.co.ke] On Behalf Of
Rad!
Sent: Wednesday, June 10, 2009 6:11 PM
To:
Skunkworks forum
Subject: Re: [Skunkworks] MySQL on
Windows
Well, that is entirely subjective. I too have used a variety of RDMBS
systems, and for the solutions I used SQL Server I am very happy with the
performance. Whereas you are unable to find positive things I can find several.
For instance
- 3 replication techniques
- Dedicated date and time data types (fantastic for reporting and data
warehousing)
- Timezone aware datetime type
- Geospatial type
- Embedded .NET runtime, allowing procedures and functions to be written in
.NET as well as allowing use of 3rd party DLLs. A godsend for situations where
SQL is very poor like regular expressions
- Integration services for ETL tasks
- Business Intelligence
- Data warehousing
- Structured error handling in T-SQL (try-catch-finally)
- Transparent data encryption
- etc
Depending on your ability to make use said features, your mileage may
vary
On Wed, Jun 10, 2009 at 5:59 PM, Moses
<mosenetk@gmail.com> wrote:
The article aside, I have used for several years SQL-Server,
Oracle, Postgres and Mysql. When presented with the same optimal level of
load, hardware and platform, SQL-Server sucks in comparison. There are very
few positive things that I can say about sql-server in COMPARISON with other
DB platforms other than the fact that they have a huge marketing budget and
effective sales network!
On Wed, Jun 10, 2009 at 9:50 AM, Rad!
<conradakunga@gmail.com>
wrote:
Interesting article. I've come to find that articles
praising one vendor's products over another's wiritten by the vendor are
best taken with a pinch of salt. I read Oracle comparisons by Oracle, SQL
Server comparisons by Microsoft and DB2 comparisons by IBM skeptically. Not
to say that they lie, but they are written in such a way to make the
competition look less appealing.
Selecting a database for production
useI would imagine is best done on a case by case basis depending on several
factors (cost, support, skill set, features, operating system, problem
domain etc) which would mean for different scenarios you'd end up with
different databases.
_______________________________________________
Skunkworks
mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
Other
services @ http://my.co.ke
Other
lists
-------------
Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce
Science
- http://lists.my.co.ke/cgi-bin/mailman/listinfo/science
kazi
- http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
_______________________________________________
Skunkworks
mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
Other
services @ http://my.co.ke
Other
lists
-------------
Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce
Science
- http://lists.my.co.ke/cgi-bin/mailman/listinfo/science
kazi
- http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general