x

Why is SQL Server The Best RDBMS (or better than DB2)?

My division is attending a BI Summit in the (VERY) near future. My VP decided it would be fun to host a technology panel comparing SQL Server and DB2. We utilize both DB2 and SQL Server. I'm the SQL Server DBA, and have to come up with a 10 minute presentation about why SQL Server is great. I can even take a light-hearted jab at DB2, as I'm sure my DB2 DBA colleague will do to SQL Server.

I need help giving me interesting bullet points and facts about SQL Server. A lot of the things I'm finding online seem kind of dated.

Things I have so far.

  • Lowest Total Cost of Ownership. (lower licensing fees, lower hardware costs, bundled management software that is costly add-ons for other RDBMS's)
  • Integrated Security with Windows Authentication services
  • Tight integration with Visual Studio Development environment.
  • Market Momentum: According to IDC Microsoft is the fastest growing DB Vendor (not sure how old this is).
Anyway, anything you guys can help with would be much appreciated.
more ▼

asked Aug 26, 2011 at 08:45 AM in Default

EnrightMcC gravatar image

EnrightMcC
42 2 2 2

(comments are locked)
10|1200 characters needed characters left

4 answers: sort voted first

SQL Server community & training has to be a big thing for SQL Server (although I have no real idea of the DB2 community):

Free training from industry experts:

High quality paid training (again, something that is done in DB2 community too, but SQL Server offerings are brilliant IMO):

What is not to love?

[8]: http://www.sqlexcursions.com
more ▼

answered Aug 26, 2011 at 08:57 AM

WilliamD gravatar image

WilliamD
25.9k 17 19 41

Of the real differences between the two, I think this is the really big one.
Aug 26, 2011 at 10:07 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left
  • Low cost never gets old.
  • Compare how well your DB2 colleague gets on asking questions in the DB2 community with how well you get answers here. I bet you get more, better responses. Try asking this question on Twitter too, using the #sqlhelp hashtag
  • ease of learning from so many online resources
  • performance - there are TPC benchmarks where SQL Server is top
  • integration with other Microsoft tech (esp security) is still a big benefit if you are on a Windows domain
    more
  • Third party tools to help administration/automation
  • PowerShell
  • inclusion of SSRS, SSIS, SSAS, CLR, etc in single license/price
  • Has cloud version - SQL Azure
more ▼

answered Aug 26, 2011 at 08:49 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.8k 75 79 108

(comments are locked)
10|1200 characters needed characters left
Outside of SQL Server being more widely supported and easier to get resources that can support it, as @WilliamD and @Fatherjack have noted, the SQL Server Community is unmatched. I work with several guys who used to work on DB2 and frankly it is a solid DBMS however it is aged. It works well for mainframe, but depending on your business need, find a modern .Net application that you can readily purchase online that says the back end supports DB2. Nearly every vendor codes for MSSQL or Oracle. DB2 seems to be mostly for mainframe and or some in house solution. Keep in mind my exposure to DB2 is from folks who have worked at Credit Card processors so my view is tainted. @WilliamD listed lots of SQL Community items. Check out my blog that contains additional information about PASS and what they offer as well.
more ▼

answered Aug 26, 2011 at 11:21 AM

Tim gravatar image

Tim
36.4k 38 41 139

(comments are locked)
10|1200 characters needed characters left

Not being very DB2 familiar I don't know whether these suggestions are trumped by it but here are some thoughts:

I would suggest mentioning the programming options available both inside and external to SQL Server from UDFs to CLR and more. If it can't be done natively doesn't mean it can't be done through SQL Server.

XML support is also a relatively good point.

Service Broker is sometimes under-valued but for some it is a lifesaver.

Log Shipping, Mirroring, Clustering and Replication are all worthy of mention as well.

Compression & Encryption are good features as well.

And lastly, ones that are hard to argue, the size of the install base, the community and its support, and the wealth of high talent available to work on projects.
more ▼

answered Aug 26, 2011 at 01:03 PM

Blackhawk-17 gravatar image

Blackhawk-17
11.9k 28 31 37

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1850
x346
x19
x2

asked: Aug 26, 2011 at 08:45 AM

Seen: 2054 times

Last Updated: Aug 26, 2011 at 08:45 AM