I just received following “NOT FOR SALE” subscription of Microsoft Visual Studio 2010 Ultimate with MSDN. As a MVP, MCT I already have free subscription to MSDN and TechNet. I plan to give away this free subscription to someone who is need of the same or can use it the best.
You can win the subscription. I will pick the winner of the subscription on 25th of the July. Which means you have 10 days to take part. I will decide the winner with the help of fellow MVPs and subject matter experts.
You need to answer one simple question: Why SQL Server is better than any other RDBMS applications?
Leave your answer as a comment to this thread, or post it on your blog with links to this blog post. To avoid spams and bad entries, I will moderate all the comments. If you have left comment and it is not visible send me the same comment in email pinal “at” sqlauthority.com . All the entries should be there before 25th July. I will announce winner before 1st of August.
Update: Due to overwhelming response of the contest, the evaluation of the winner is still going on. I will announce very soon who won the subscription.
Reference : Pinal Dave (https://blog.sqlauthority.com)
154 Comments. Leave new
MS SQL Server has all you need for your data: features, tools, support and great community!
“Why is SQL Server better than any other RDBMS applications?”
Quite simply because there are no available RDBMS applications. The SQL language deviates quite significantly from the relational model (no domain support for attributes, implicit ordering of both rows and columns, duplicate rows permitted by default, etc. etc. etc.). Read any book by Chris Date, Hugh Darwen, or Fabian Pascal to appreciate the myriad subtle yet serious implications that result.
Consequently, SQL server has the same fundamental weaknesses as any other SQL DMBS product.
Let’s be honest: SQL is a poorly designed language. For example, think about queries involving aggregate expressions and how messy they get: Why do we need a HAVING CLAUSE in addition to a WHERE clause? How ugly is that!
That said, SQL Server does have much better support tools than most of its competitors and the T-SQL dialect is arguably the best of a bad bunch – certainly ‘cleaner’ than its main competitor, Oracle PL/SQL. Designing robust and performant databases in any SQL flavour often involves working around SQL limitations and MS SQL Server offers some facilities (e.g. CTEs, CLR interop) that, used judiciously, can help a great deal.
Possibly not the kind of answer you’re looking for, but until truly relational products are available, we will all have to put up with the shoddy second-rate SQL language. The more people that understand this, the sooner better products may arrive.
Khurram Amin:
Your assertion that SQL server (or indeed any SQL product) implements all the 12 rules of Dr. E. F. Codd is utterly ridiculous. You clearly don’t know Codd’s rules. Why did you just make that up?
@Mattste
My be I was just dreaming after watching the “Inception”. Can you please write which rule is not implemented and why?
You can start nearly with no knowledge and no money. It seamlessly works with Visual Studio. You can set it up and forget it. But if you want to do some serious development SQL Server + Visual Studio is a more developer centric platform than DB2 or Oracle. And finally, it better suits the mindset of the .Net developer and that’s probably the reason I’m using it ;-)
Why SQL Server is better than any other RDBMS applications?
Its not!
Its a tool – like any other – and I pick tools to suit jobs.
For example – i don’t pick up a drill bit to hammer nails…
Similarly i don’t use SQL server in every instance, if its the correct solution [and the client is willing to pay for it] then I’ll use it, otherwise anything from a simple text file datasources, through XML, to SQL [in any guise] and on to ORM / Object Databases…
In a nutshell – because it does everything that you could ask for, it does it well, is fast, it is self-aware, self-healing, self-tuning, easy for beginners, configurable for the advanced, and is the entire data collection / manipulation / reporting package in one affordable shot.
A well thought out product to serve everyone.
I love working on SQL Server. It’s best because it’s RDBMS with excellent tools (SSMS, Tuning Advisor, Profiler, RS, Integration Services etc….)…. + Licensing is not that costly. Can download Express edition for free (For learning purpose). Has msdn support really nice. in that they reply to questions as soon as they can. means it has good support. Really nice format for getting certification. (Which is one of my goal MCDBA).
It’s part of my life. and it’ll be part of my life.
simple sql server serves the RDBMS , IN ITS NAME IT HAS THE SERVER ITSELF
S: SCALABILITY
Q:QUALITY
L:LIABILITY
I think SQL is better than other RDBMS db is because
a. Honestly speaking, i have used this from initial stages when i started my web programming..!!!
b. Other than that it is better as it has very clean and simple user interface
c. Plus it provides various other features in it such as SSAS, SSRS and SSIS
d. Also it pretty user-friendly and easy to use.
e. Plus it inexpensive (and even free–Express Edition)
f. Has straight forward installation and has many third party tools (eg RedGate)
g. Easy to backup-restore database, easy to generate scripts(Insert, update, delete etc) and easy for Support Admin Guys also
I am not Hardcore SQL Server User as i am a web developer and not DBA, but these are the feature that i love the most about SQL Server
Thanks
With most other RDBMS it seems to take ten people to accomplish a task that one person can do with SQL Server.
Hi,
reasons why MS SQL Server is the best:
1) Easy to install – even a non DBA can install it for testing
2) Maintenance is easy to start
3) Purchasing isn’t too expensive
4) 1 + 2 + 4 = very good TCO
5) Information in book, @MS and the web
6) Scalability is really impressive
7) Tools: Many tools available
Kind regards,
Sascha
SQL Server is fastest in providing many new functionalities in every version it releases. I believe so, the future versions of SQL Server will be astonishing.
I think SQL is better than other RDBMS db is because
It is meant for foxpro and dbase developers. Enterprise needs ORACLE
It very slow in catching with ORACLE. Even, they can’t copy what ORACLE to offer.
Great price point. BI suite included in the license. More “googlable” information than any other RDBMS on the web due in part to price point accessibility.
I think it is better because is it is easier to maintain than others.
It is why because its easy to install, configure especially administration even though for non-DBA’s.
I am not DBA but I learnt and explor by myself, it is fintastic database engine.
– Great installation tool
– Extensive documentation, enormous and helpful community
– The number 1 administration tool for:
– Daily maintenance
– Administering jobs
– Optimizing queries
– Really really fast.
– Powerful third party tools.
– Scales well.
Top Features in SQL Server than any other RDBMS
1) IF EXISTS
2) COALESCE
3) SSIS- DTS
4) Easy Maintenance
5) Debugging Feature for Stored Procedures.
6) Common Integrated Development Suite- Visual Studio.
7) Reporting Tools (SSRS).
8) User Friendly Navigation.
9) Easy to Deploy the Solutions.
10) Good GUI Management Tool.
11) High- Availablity Database
12) Coming up with Good Features like (Data Encryption, Resource Governing, Performance Data Collection, CDC & Many more)
13) Online Backup with Point-in-Time Recovery
14) Licensing: The licensing structure of SQL Server is much better as compared to other RDMS systems with various options
SQL Server supports all RDBMS Features (Codd Rules)
1) ANSI SQL, SubQueries, Joins, Cursors, Prepared Statements
2) ACID Transactions with Commit, Rollback
3) Updateable Views
4) Distributed Transactions
5) Snapshot/Consistent Repeatable Reads
6) Server-enforced Referential Integrity
7) Security (GRANT/REVOKE, SSL, fine grained object privileges)
8) Updateable Views
9) Information Schema/Data Dictionary
SQL Server is better than any other Relational Database because it is easier to install, configure, create backup-restore plan, maintain and less complex. It has also extensive, experienced and willing Immediate help from Sql Community for any problem in sql server
SQL Server supports all RDBMS Features (Codd Rules)
1) ANSI SQL, SubQueries, Joins, Cursors, Prepared Statements
2) ACID Transactions with Commit, Rollback
3) Updateable Views
4) Distributed Transactions
5) Snapshot/Consistent Repeatable Reads
6) Server-enforced Referential Integrity
7) Security (GRANT/REVOKE, SSL, fine grained object privileges)
8) Updateable Views
9) Information Schema/Data Dictionary