SQL SERVER – Poll Result – What is Your Favorite Database?

I previously posted a Poll about What is Your Favorite Database?

I got great response from users. In fact, I received some of the best poll-related comments on this blog  and they are worth reading.

Let us check the result first. Here are the votes I received on different database. Total votes received are 1,697.

SQL Server – 1,121 – 64%

Oracle – 432 – 25%

MySQL – 144 – 8%

Other – 64 – 4%

SQL Server is a clear winner with  1,121 votes, which is an astounding 64% of the total votes. As a matter of fact, it is not startling to see SQL Server  emerge as a winner as this blog is primarily focused on SQL Server, and  on top of that SQL Server is the most popular language.

Lotus Notes/Lotus Domino (total 12 votes) and PostegreSQL (total 12 votes) are the top two DBMS in other section.

Let us have a look at the result in the following image. Here,  I have included all the DBMS who received more than 1 vote.

Now I would like to announce the winner who gave the best comment.  And the winner  is Brian Tkatch. I could not stop laughing after reading his comment. He is dear friend of mine and a SQL Expert who has  actively participated several times on this blog earlier.  Imran Mohammed and phat shantz also came up with interesting comments. I thoroughly enjoyed reading their comments as they discussed unknown details about other database. The comment from Jeff further led to some good discussion on the topic. I have not edited any of their comments and have published their original version.

Comment of Brian Tkatch :

I prefer the DB that is best suited for the job. If there job can use any, i prefer Oracle because it makes the most sense to me.

I’ve use a few RDBMs, but for short periods, like a year or two. I have very particular tastes, and as such am heavily biased, so IMNSHO:

SQL Server implements what programmers want, and then bends to the way things should be where it doesn’t add too much inconvenience.

Pros: Integrated, easy to manage, secure, supported, low cost, convenient in most cases, Pinal Dave

Cons: inconvenient in some cases (SET NOCOUNT ON et al, non-ANSI join-syntax is deprecated, and others) bar set too low for DBAs (allowing much idiocy), no robust command line tool

Oracle implements things the way they should be done, and then bends to the programmer where it is helpful but does not break any ideas.

Pros: Robust, secure, supported, fast, long history

Cons: Very expensive, inconvenient in some cases

MySQL isn’t a database. It’s free and fast for lightweight applications, but lacks security and robustness of a real database. I’d use it where speed and cost are factors, but not security or data retention.

Pros: Fast, free

Cons: Not secure, error messages rarely help, not robust, no reliable data retention, slow on complex queries with large data sets.

Others include:

DB2 implements whatever it can, trying to make everybody happy, supporting the popular features of both SQL Server and Oracle. I would use it where being an IBM shop made sense. Otherwise, SQL Server or Oracle could easily do the same job.

Pros: Supports everything. Cheap. Supported by IBM.

Cons: Easy to crash (i crashed it, that is the server, 4 different times by running regular queries), lack of distinctness

PostgreSQL is similar to Oracle, but free. I’d use it anywhere other people would use MySQL but want a database instead, or where commercial support is a must.

Pros: Fast, free, secure

Cons: Relatively small community supporting it

Access is a RAD for small applications.

Pros: Cheap, integrated, RAD

Cons: Single user, not for large applications.

One word:

SQL Server – Easy

Oracle – Robust

MySQL – Fake

DB2 – Contender

PostgreSQL – Free

Access – Small

Thank you for reading. I think i got it out of my system now. :)

Comment of Imran Mohammed :

BEST RDBMS in Market :

SQL Server

Few reasons:

1. Costs Less.

2. Extra Security.

3. Extra features

4. Comes with many free tools.

5. Have capabilities to handle VLDB (UPSS – 18 TB, Myspace uses SQL Server)

6. Comparatively easy to handle/Interfaces.

List goes on and on….

More Important… I am getting monthly pay cheques because I am SQL Server DBA. :)

Comment of phat shantz :

For years I built standalone business applications using c-Tree, a high-performance, cross-platform database from Faircom that could be implemented with native or server based access.

I still think c-Tree is the best database in the universe, although the downside is the limited acceptance and limited developer resources.

For the past few years, all my clients have used SQL Server.

Like all things Microsoft, SQL Server is a “good-enough” solution, so using and implementing it is tolerable. Since it plays well with MS office and MS builds all its business-centric products around it, it becomes the de-facto standard.

Compromise is not always the best course, but when dealing with jumpy executives and poorly-trained IT, sometimes the best you can do is compromise.

Even for some of the grandest projects, Oracle has usually been overkill. It’s expensive, a hog, slow (in my experience — and don’t blame me, it was always administered by a “professional” Oracle admin), but will handle 500,000 transactions in a gulp. I have seen one implementation of an Oracle database that actually needed that kind of horsepower.

Sybase and MySQL need no comments. Their fanbois are poised out there, ready to tout their superiority and flame anyone who disagrees.

Like one of your commenters stated, the question should be “what’s your favorite database for X type of project?”

If the environment is Microsoft and the platform is business and the clients and staff are untrained and largely uninformed, the answer is always SQL Server.

Still, I would never undertake a project using SQL Server without one of the best ORM/EF products available. Microsoft’s LINQ and EF are both less palatable as database access layers than are the visual components that come in Visual Studio tolerable as win or web-form components. (While most of what MS delivers is “good enough,” I think MS delivered LINQ and EF so they could claim they provide something. As they dissatisfied girlfriend says of the gift from an unwanted suitor, “you shouldn’t have.”

Just as I would never deliver a product using the world’s ugliest visual components (the VS toolbox), I would never use SQL Server without a quality (and pricey) ORM.

Even with all it’s drawbacks, sometimes the answer is SQL Server even if the staff and clients are very skilled and knowledgeable. I can think of some cases where it is the best answer, but the meta-requirements have to go far beyond capacity, speed, platform, or tools.

I guess there will always be a few “BetaMax” databases out there that are far superior in performance and capability to SQL Server. But the Redmond Marketing Horde has long conquered the battleground and there is little hope of the best rising above the most popular.

Comment of Jeff :

I’m not sure thats a fair question to ask. There are TONS of databases out there both free and commerical. The real question is always whats you’re favorite database for X.

For a ‘Enterprise’ DB, I like Sql server. It has a low barrier to entry, good tools, reasonable price point etc etc. I like PL/SQL as a stored proc language better than t-sql, but I find the learning curve for new developers to be higher on Oracle.

MySQL’s licensing terms, specifically the GPL’ed ADO.Net provider, personally make it a ‘meh’ option in the open source / free category. If I had to pick an enterprise database for linux shops I’d go with Postgres or Firebird first. MySQL’s ability to have differing disk formats is a really great feature. However the disk formats that it ships with are in my book un-compelling. Postgres and Firebird both have much better concurrency models. They both have much better procedural languages. They dont ‘blackmail’ me into buying support by GPLing a component that every other vendor on the planet licenses under the LGPL and then offering a binary-only support contract.

One database I find myself using a lot is SQLite. It’s a very very simple database. It’s serverless, locking is coordinated through the database file. The resource requirements are low enough for use in embeded systems. The great part about it is the zero-config aspect of it All you need to do is link in the library and point it at the db file. This is great for stuff you’d never think of using a database for otherwise. If I’m writing an application that needs data files, I can make them a database. I can use it as a light-weight db for unit testing. For webapps that expect an unzip and go deployment it’s a wonderful option. I can have a real db that simply lives on a file in the app.

I am really thankful to all of my blog readers and every person who participated in Poll. As requested by many readers, I will have new poll very soon.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

SQLAuthority News – Database Poll and Gandhinagar SQL Server User Group Launch Today

I have published a poll on website few days ago for favorite database of SQLAuthority.com readers. The best comment will win USB drive. The poll will close on April 1, 2009. Looking at the poll result, it seems that Oracle has gained a lot over SQL Server from last time when I checked. Please share this poll with your friends, your UG and community to get better sample. If you are not interested in poll there are many interesting comments, please read them.

Click on Image to go to Poll

Click on Image to go to Poll

Additionally, Gandhinagar SQL Server User Group has launch event today. I suggest all of you from surrounding area to show up at this User Group meeting. We have price for best participation in UG as well. Please read more my post for agenda, time and location SQLAuthority News – Announcement – Gandhinagar SQL Server User Group – March 27, 2009.

You can follow me on twitter for latest updates. My tweets will be a mix of fresh product news, database optimization tips, interesting links, upcoming events, and possibly even some giveaways.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

SQL SERVER – What is Your Favorite Database? – Poll Continuous

I have published SQL Server Poll about What is Your Favorite Database? to get feedback from readers of this blog about what is their favorite database. I have received so far tremendous response. This poll will continue through out this month and will close on 1st of April. I will post all the statistic once the poll is over. I encourage all of you to spread the word about it to different channels, blogs, linked list and emails.

It is not only important to vote for your favorite database but it is equally important to leave comment justifying why and which is your favorite database. I do have received some criticism on the poll. Some asked as this blog is only SQL Server focused the poll will not get good results. I suggest that this blog is for all the developer who are using SQL. So far I have received quite good response from different database users.I am also asked about title of the poll. Some think it should be “What is your favorite RDBMS?”. My response to that is yes I agree at certain level. I have thought for long time before I selected this generic question. I did have received some of the responses  in other section which are not RDBMS so I think my title is fine as it is.

There are some really good comments why one of the database is preferable over other database. I encourage all of my readers to participate in original blog and leave your comment there. There is a award of USB drive but if you are not interested in winning USB drive, please just say so in comment but do not hesitate to participate in the poll.

I have some of the initial result from voting, which I am displaying here however, this is not final result and it can change based on users feedback.

Please vote for your favorite database.

Click on Image to Vote
Click on Image to Vote

Reference : Pinal Dave (http://blog.SQLAuthority.com)

The Poll – What is Your Favorite Database?

What is Your Favorite Database?

I have been listening so many different answer to question of favorite database. I would like to know what is favorite database of SQLAuthority.com readers. I encourage all of you to participate in this poll. It is very quick poll and takes a second.

A gift of USB drive will be provided to user who will also add comment discussing this subject matter. I encourage to send emails to your friends to participate in poll. I am hopping this poll becomes landmark poll for people who are finding answer to favorite database.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Humor – Favorite Website – Funny Image

I just received this image in email and I found it really funny. I do not know the source of the image or is it photoshopped. Thanks David Marsee for the image and email.

If you have something really funny like this, please send them to me. Please do not leave comment regarding grammatical mistake in image as I am sure David (who send email) did not mean it.

Reference : Pinal Dave (http://blog.sqlauthority.com)