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
-User-friendly interface
-The very best learning curve
-Less-time adoption
-Excellent Quality/Price ratio
And much more…
The Oracle rep wanted to sell me RAC for my small-medium business, and said that if I couldn’t install/configure it, he could sell me Oracle Database Machine.
The IBM rep showed me video on how they could build an IT infrastructure that could run a global enterprise. Unfortunately I did not have global enterprise IT budget.
The MySQL guy said he had a schedule conflict with his high school prom, and he had already commited to doing the A/V gear for the band.
But SQL Server was just right, except I didn’t understand why I needed SCOM for my SMB.
SQL server is intuitive to use and learn. It offers great deal of features at best prices. SQL 2005 new feature “DB mirroring” is great deal!
MS SQL Server is better than other RDBMS because:
– It’s an enterprise level database server.
– Great performance and scalability.
– Can perform business layer functionality using stored procedures and user functions allowing thin clients.
– Easier to maintain compared with others RDBMS.
– Integrated graphical designer, graphical administration and wizards.
– Free BI module (SSAS)
– Free ETL module (SSIS)
– Free Reporting Services (SSRS)
– Several editions for different requirements.
– It has a free express version for testing or low volume projects.
– Lower TCO compared to others.
– Easy installation.
– Self-tuning capabilities.
– Extensive collection of help.
SQL Server is better than other RDBMS
– Since it is a fairly new RDBMS some techniques are thought out of the box instead of just implementing the same thing that is done by others.
– It has lots of developer friendly tools.
– It has lots of blogs and support documentation.
– Easy to learn
-Nachi
All of the usuals: easy to learn and use and cost efficient. But I read that it works great with Visual Studio and what better way to experience it
I think SQL Server is great because its taken the reigns of power out of giants like Oracle and given them back to businesses.
Users now have choice when considering enterprise solutions that they didn’t have previously.
And it just *works*. SSAS, SSRS, SSIS are all fantastic compliments to the rdbms.
“Ease of use” has to be the answer.
I have developed software for 22 years and have seen many development environments. Nothing compares to Microsoft when it comes to integrate development environments. Ever since Gee Whiz Basic was released Microsoft has strive to make ease of development its key strategy for the uptake of its technology. This strategy just keeps on getting better, hence Microsoft dominance in the market. I can create an environment on my laptop and know it will scale when released to support transaction growth.
To this end I’d like to say thank you Microsoft. You have support my life-style, paid for children’s schooling, and my mortgage. Don’t know what I’d do without MS. Now I can’t wait for the MS-Cloud to form.
Why SQL Server is better than any other RDBMS applications? There are plenty of reasons:
Business Reasons:
– great business application documentation support from Microsoft and the community – Microsoft put a real effort into offering well thought out documentation, free on the web
– usability
– trusted brand
– universality
– pricing structure within the grasp of all businesses
– Microsoft listen to feedback over the versions
– accessibility for people with physical challenges
Technical Reasons:
– accessible learning curve, ease of entry for novices
– maintainability – it delivers so well that, even when it’s not looked after properly, it still works away
– enterprise scalability
– integration with Sharepoint
– flexibility
– well planned technical documentation, with examples
and Best of All – the SQL Server community is actively supported by Microsoft, is second to none, and the people are amazing.
SQL Server installs and runs smoothly with the Visual Studio development suite. SQL Server comes with the Management Studio tool built-in; you often buy extra utilities to get the same functionality out of other RDBMS.
i cant say any reason about its good or bad ..!but it looks simple and user freindly..!
SQL Server is better than other RDBMS because as it is easy to leran for every one and reliable and scalable and Accurate for the requirements.
Hi Pinal,
Here are the short list of advantanges of using SQL over other RDBMS.
1. User Friendly
2. Most adapters and components comes in with Windows itself.
3. Pretty much supported with .NET than any other rdbms.
4. Purchasing a single product gives us the advantage of using SQL Database Engine, SSIS,SSAS and SSRS.
5. And in SQL R2. There are lot of features for publishing and deploying to SQL easily from VS 2010 easily.
6. Intellisense
7. Performance tuning
8. Job scheduling
9. Spatial data types and queries
10. CLR Integration
and what not?
All the features are there.
SQL Server always rocks!!!
1. Its more user friendly and has less learning curve than any other RDBMS.
2. Anyone who doesnot have a prior knowledge on SQL can quickly get updated in no time.
3. SSMS provides a easy to use interface comparitively with any other DB Server related UI.
4. Suitable for RAD.
5. Oracle Sequneces vs Identity columns – means a better maintainability.
6. It eases the effort of any dba/sql developer from creating databases on the fly to all the way of monitoring it using SQL Profiler.
7. SQL Server is getting better day by day with its state of the art features which are very user friendly.
8. Cost affective and easy to install.
1) MS SS Have use number of MVP,Trainers and blogers with the help of them and Organigations and developers can know the what is the problem and what is the solution for that.
2) Sqlserver is the Single solution for all the levels of Data Business Solution.Like It have the Analysis and Integration And Rich reporting Services where as other RDBMS tools not have all in one.
3) Multiple options for Disater Recovary for the mutiple organigation based on the their database size and cost,So small organigation can use their respective disater recovery solutions based on their cost when they start up when they grow then they can easily change to new recovery methods.
Simple it is MS product Native to all MS environments and most powerfull for .NET
Features wise competitive with every other RDBMS today.
Thanks
Nagaraj
Sql Server did to databases what Windows did to pc’s. It brought it to the masses!
1.Easy to use.
2.The thing just runs – I have been to places where they did not have DBA’s and were running SQL Server without a problem for years.
3.No other RDBMS can run from a mobile phone all the way up to Fortune 500 companies.
4.SQL server has a lot of free features thrown in: Reporting services, Integration services, Analysis Services…
5.No other database is as easy to develop for. I do not have to fight it to get my job done!
6.Integration with .NET is easy and powerful. CLR has saved my skin a few times and made me look good.
7.Integration with all other Microsoft technologies – Office, SharePoint…
8.The price is right ;) (TCO)
9.The quality of the product – of all products I use, SQL has definitely the fewest bugs that I could find.
10.The value I can add to customers by just using the SQL Server stack makes it a winner for everybody!
11.The community: There is always somebody that can help you with a problem and the web is full of examples for SQL Server.
12.TSQL: It is just easier than the other offerings.
It was an easy-to-use, developer-friendly relational database, which tied nicely to classic ASP. I wrote tons of stored procedures from the start, and avoided using ad hoc queries — and never had any security issues.
For a Matrimonial site that needed quick response and tons of features, I wrote the entire search engine in a SQL Server stored procedure, with additional user-defined functions. At the time, the collected data was in flat files stored on OpenVMS. I used a nightly DTS to pull the data and ran cleanup procedures to store it on SQL Server. All of this with great ease. And lets not forget: There’s not an equivalent of DTS/SSIS on Oracle. Going back to SQL Server 2000, this has been a powerful feature of the database, making developers’ lives easier.
For the same matrimonial project, I needed to provide users with the option to leave multiple fields blank and allow searches on any combination of values they provided. The handy “coalesce” function made this a snap. I posted in my blog and got great help on how to accomplish this. The final SELECT statement looks beastly, but it’s quick and efficient. This was long before Oracle supported the “coalesce” function.
Also, I constantly used the IF EXISTS (SELECT *…) in my stored procedures and user-defined functions. Believe it or not, Oracle still doesn’t have a direct equivalent of this easy feature. If you wanted to insert a row but wanted to check that it didn’t already exist, you’d simply do an IF EXISTS. Easy and intuitive. This is much harder in Oracle.
In addition, the ease of using stored procedures with web apps makes SQL Server a web developer’s best friend. It took us over 2 weeks to get Oracle working with ASP.NET; SQL Server worked with it like a breeze. And the syntax was easy too. If you’ve connected Oracle stored procedures to ASP.NET apps, it’s not a trivial task. We had to install a 200Mb data provider to talk to Oracle. Not my idea of easy.
Moreover, SQL Server installs and runs smoothly with the Visual Studio development suite. SQL Server comes with the Management Studio tool built-in; you often buy extra utilities to get the same functionality out of other RDBMS.
With Oracle, you have to set up TNS files and ensure they have the correct settings on development and production. With SQL Server, you don’t have to worry about any of this.
Reporting tools? Built into SQL Server. As far back as 2002, you could purchase an inexpensive. add-on from Microsoft to enable reporting capabilities. Today, the SSRS tool is robust, easy to use, and also developer-friendly. For years I was trying to convince my boss to go with SSRS; she finally went to a conference and saw how powerful it was and she was sold. Instead of a third-party tool that kept crashing daily, the university went with a product that users, admins, and developers love.
The sole reason why SQL Server is better than any other RDBMS is its solid abstraction that targets all users, beginners and experts alike.
Have used the leading RDBMS (name starts with O) for the last 6mths and the only problem I faced was the over-availability of super complex features, most of which were meant for DB purists.
I am an app developer. DB is an essential part of my app. The way I assist my app users by abstracting the tables and their relations with my UI design, SQL Server assists me by abstracting all the low level Data Structures and features as advance as Indexes, Jobs and much more, with sleek and meant-for-usage UI.
Add to it the astounding seamless Setup experience. Trust me, apart from MS Access (which again is an MS product), no other RDBMS ever had usability and user-centric features.
Hats off!
SQL Server has very less bug rate than other RDBMS.