SQLAuthority News – FREE Microsoft Visual Studio 2010 Ultimate with MSDN

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 (http://blog.SQLAuthority.com)

About these ads

158 thoughts on “SQLAuthority News – FREE Microsoft Visual Studio 2010 Ultimate with MSDN

  1. There are several reasons why SQL Server is better than any other RDBMS.
    User-friendly: anyone can start with SQL Server Management Studio
    Cost: It’s affordable compared to other similar systems
    Cloud: You’ve got almost all the features in the cloud as on premise.
    BI: Business Intelligence is included in the package!
    You can easily connect to SQL Server, either with SSMS, Excel, Access, .NET, PHP or what ever’s your favourite application/programming language

  2. SQL Server is better because it is a great environment for all types of DB professionals: DBA, BI and DB Developers.

  3. SQL Server is better than any other RDBMS because-
    1.It is easy to Install
    2.It is easy to operate
    3.It is easy to maintain
    4.But cost effective.

  4. SQL Server has got SQL Server Management Objects(SMO) for programmatic management of SQL Server. SMO can be used for creating a client similar to SSMS. Moreover SMO can also be used for running SSIS packages using .NET. This makes SQL Server better than any other RDBMS.

  5. The best “feature” of SQL Server is the broad and active community – one can always ask a question on a forum and get an excellent professional answer within minutes. Application-wise I cannot really express my opinion, because I am not an expert in any other RDBMS system, and the only perks and shortcomings I know are the ones of SQL Server, so I do not have a solid ground for a compare. However, I am confident that the support and the professionalism of the community bring great value to the product.

  6. For me the reasons it is the best RDMS software is as follows

    1. Its easy to install
    2. The areas of the software are clearly marked i.e.
    BI / Notification services / etc
    3. Intergration of CLR functions
    4. Use of SQL Features inside Visual Studio i.e SMO and managed classes

    5. The community of users is polite / welcoming and vast in knowledge for all vertical markets.

  7. SQL Server is better than other RDBMS applications because..

    Its accessible – even non-technical people can get a database up and running in short order.

    Built in business intelligence – SSAS, SSIS and SSRS all available within the BIDS framework.

    Cost – The sheer number of features available either free or on a standard license is extremely high

    But mostly, I think SQL Server is better than other RDBMS applications I’ve used because of the community – the experts are approachable, humble and always seem willing to continue to learn new things.

  8. SQL Server RDBMS is better than other RDBMS in the sense that it offers a full range of products from being a Relational Database Systems to providing an end to end data warehosuing Life Cycle.
    It provides tools and applications to perform ETL operations and carry through the Datawarehousing process to provide end user reporting and predictive analysis features using Data Mining.
    As a an RDBMS which is easy to install and administer, the product has expanded its footprint into the areas of Self Service BI and Cloud Computing.

  9. I learned RDBMS on SQL Server 2000 back in 2002; picked up a book and read it until the pages came out. 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 university’s online directory 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 school’s 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 directory 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 to SQL Server forums 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 ($5, if I remember correctly) 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.

  10. The single feature I prefer are the deployment options. I worked on software installations, and SQL Server is about the only RDBMS that you can deploy in a setup with your own software: You can easily connect to an existing instance, or you can install an existing instance.

    You can do that all in your Setup software. I also tried to do the same thing for Oracle, but that’s just impossible – even finding out which Client version is installed on a computer is an impossible task. For Oracle you cannot really automate the installation of your software, so you need to send an engineer to the customer site to install and configure everything.

    The one competitor that allows deployment is MySQL, but SQL Server has much better upgrading paths.

    So, my criterium is integration with software sold by VARs, and then SQL Server is the clear winner.

  11. I love it because it is extremely easy to use, very easy to install. I love the fact that you can use the GUI to generate the T-SQL scripts behind each command.

    I love the Business Intelligence built in.

    I love the fact that it’s scalable and I even love the fact that there’s a whole Developer edition that you can use freely to test out what you will need in your environment.

    I love the fact that it is fully integrated into Virtual Studio, and, as a programmer, it makes things so much easier!

    All in all an awesome product.

  12. Simply because it is from Microsoft :)

    Other reasons could be the as a .NET Developers , this is already bundled with Visual Studio ( SQL Express Edition )
    which makes the whole process easier

  13. I don’t do much with any SQL, but when I do I very much like SQL Server’s low maintenance; you don’t need someone babysitting the server(s) 24×7.

  14. SQL Server is better than other RDBMSs because:

    - #sqlhelp: thousands of community members race to help others when they need an answer or tutorial. Just amazing.

    - @: Thousands of community members on Twitter and other social networks, ready to provide technical, moral, humourous, and profesisonal help when needed.

    - #sqlSaturdayXX: Free, open to anyone training at the professional level. Again, amazing.

    - #sqlPASS: a great professional organization, free to join, for professional development and community building. International organization with local chapters.

    - Many installation license options. Embedded, Express, Enterprise. Some of them free. A price point for all businesses, not just giant corporations with unlimited tech budgets

    - Azure: In the cloud…

    - Broad support in third party tools. Much better support than other RDBMs.

  15. SQL Server is better than any over RDBMS in my opinion for the following reasons:

    > Easy to learn, install and manage.

    >It’s feature loaded and therefor more cost effective, and a better choice for companies for reducing total cost of ownership and increasing ROI even for SMB’s.

    >It’s from Microsoft and therefor provide excellent use of CLR which allows it to integrate more effectively with .Net Framework, increasing the effectiveness, compatibility and integration with all of the MS programming languages.

    >Due to the popularity of the product, and largely the whole Microsoft product lineup, the community is overwhelming and bristling with skilled people, and a brilliant support team from Microsoft, namely CSS and PFE’s.

    >SQL is documented excellently i.e. KB articles, MSDN, techNet and the wealth of info to be found on discussion groups and forums.

    And SQL is also breaking grounds with BI solutions and with new releases coming up like PDW and datacentre, it’s really maturing even more into a total enterprise solution forming the backbone of international companies, and even new MS solutions like SCOM, OCS, SharePoint.

  16. I could give hundreds of reasons why SQL is the best RDBMS, from the feature rich offering to the enterprise class scale which it is used. What is really comes down to is not even a feature built in but instead the community behind it.

    Thousands of experts, bloggers and users in all forms share and contribute extensively. We spend saturdays getting together to teach and learn from each other. You can ask a question on twitter with a tag #sqlhelp and have industry experst respond faster than any vendor specific support could ever hope to.

    Database work is often a solitary task and I think all around having a community who openly communicates and helps on and other makes it the best.

    In short…Its the people as much as the product that makes it the best!

  17. SQL Server is better in many ways than other RDBMS. Price wise it is expensive than MYSQL(which is free) but way cheaper than Oracle. Licencing options are great and also you get the BI Stack bundled with the engine with the same licence.

    But the best feature that stands out for me when SQL server is compared to other RDBMS is the documentation(Books Online) and the community[Look at you, you spend probably half of your week helping others for FREE]. The other thing is Microsoft’s willingness to invest in building a community and always taking feedback and comes up with a new and improved set of features and deprecate the poor features.

    BTW I disagree with most of the comments above that says Installation of SQL Server is easy. They make it looks like easy for marketing but it is misleading. It has the worst possible default options and users click next next and done with install and end up with all kinds of problem later.

  18. SQL Server is better than other RDBMS for the simple fact it is a great value for money enterprise solution.

    My favourite features of the database engine are >

    1) Service broker messaging system
    2) XML datatypes and XML manipulation
    3) SQL 2008′s compression functionality

    I love the fact that within the licence, you also get >

    1) Integration Services (ETL Platform)
    2) Reporting Services (Reporting Suite)
    3) Analysis Services (Business Intelligence)

    It’s a feature rich stack of technologies that I hope one day to master.

    Community support through newsgroups , blogs , sites and events is excellent for SQL Server. It has a great following and help is always on hand.

    rich

  19. I don’t know whether it IS better than any other dbms out there. I’ve worked with DB2, IMS, Informix, and Oracle, but never SQL Server. Perhaps if I win, I can use the MSDN subscription to find out why everyone thinks it’s so great.

  20. I haven’t used many RDBMS’s, but…

    I’ve used Oracle… I want to smash in my monitors.
    I’ve used mysql… I want to bash my face on the keyboard.
    I’ve used Access… and it has lots of quirks.
    I’ve used SQLite… and it didn’t seem like i could find help with my ‘should be obvious’ problems.

    I’ve only used SQL Server 2005 & 2008, and so far I have yet to hit a problem that I can’t solve quickly by poking around myself or searching around the community. I spend almost no time managing my server or dealing with sql problems, and most of my time writing code.

  21. SQL Server is better because:
    Security – Microsoft helps keep us updated and secure.
    Scaleable – Works for small tasks, to exponentially large tasks.
    Ease of use – All the tools you need, in one box.
    Talent pool – There is a large pool of people to tap when I need to hire a new DBA.
    Support – I can always find them when I need them. This is the most important thing in my opinion.

  22. Sql Server is the best choice of RDBMS not just because of its ease of use, flexibility and affordable price, but also because it is a data source designed to work with Microsoft Office applications. Microsoft Office is used by technical and non-technical personnel alike and is an incredibly powerful and popular choice of software.

    Sql Server will not only import and export data from MS Office, it can also be set up with native SQL queries without another IDE or compiling any code. Obviously, if the choice is made to make processes that are compiled, SQL server, like its competitors, offers that flexibility. The real value of SQL Server is the speed with which very powerful BI applications can be built and quickly prepared for display to business users.

  23. SQL Server is better than other RDBMS application simply because it was created by MICROSOFT. Microsoft produced better and the best products in the world.

  24. Well,

    SQL Server is one of the best complete RDBMS platforms ever available. Its got whatever one needs and more,which is ever stable and trustworthier than before. The community help available for this piece of technology is unprecedented.

    With the introduction of MDS, Powershell,Filestream has made it unparalleled relative to the tools out there.

  25. SQL Server is like most RDMS systems, a database engine but what make it better than other RDMS systems (especially SQL 2008 onwards) are new features and other bells and whistles it comes with.
    Here are the few:

    1. Easy integration with Microsoft Operating systems.

    2. East integration with world’s most common database: Spreadsheet, microsoft excel in particular and power pivot has significantly enhanced its value.

    3. User friendly interface

    4. Easy to create maintenance plans.

    5. Integrated Security (windows authentication): This definitely help streamline server access based on Active directory policies and groups.

    6. Mixed Authentication: Not only it gives the option to use windows authentication, it allows other applications to authenticate based on username and password

    7. Disaster recovery: SQL Server is very easy to restore after a disaster (proper backup and recovery strategy needs to be implemented) as compared to other RDMS. All you need is File system restore followed by system state and then restore databases from backup. I have been involved in DR for a lot systems and doing DR on a SQL Server is much easier than any other RDMS system. Other benefits include Failover Clustering and Transaction Replication

    8. Licensing: The licensing structure of SQL Server is much better as compared to other RDMS systems. Other RDMS systems have a very complex licensing structure which comes out to be much costly than SQL Server.

    9. SQL Server Management Studio (SSMS): As compare to other RDMS systems tools, SSMS is the best tool for a developer or a DBA.

    10. SQL Server Business Intelligence: Business Intelligence in SQL Server has come a long way and has evolved so much. It is one of the best if not the best in the market at the moment.

    Since SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services comes with the SQL Server license, customer doesn’t need to spend extra money on these additional tools, instead that money can be spend on something else e.g. upgrade SAN, user training.

    11. Virtualisation

    12. Administering and Monitoring: SQL Server 2008 R2 has really scored high in its new administration and monitoring tools. It has made the life of a DBA (even accidental DBA) a lot easier.

    13. Backup Compression: Even though it is a new feature in SQL Server 2008, it has really helped companies to upgrade to the new version and speeding a lot (if not all) of the backup operations.

    14. Data Encryption: SQL Server 2008 provides a lot of encryption options to encrypt data and code. Transparent Data Encryption has really safe guarded some of the crucial data movement operations our company.

  26. Sql Server is a very good platform for developers because it can scale from a small version all the way up to an enterprise level. For developers, you only have to learn one RDBMS platform and your project will easily scale as you need it without having to adapt to different RDBMS as your performance requiremens change. It also has a very complete tool set for developers with built-in support in Visual Studio.

  27. Great idea for a contest! Here’s my list:
    • Approachability – SQL Server is a much more intuitive platform to begin management with comparative to competing technology.
    • Affordability – The cost to implement the SQL Server platform is typically much lower.
    • Dependability – SQL Server provides many high-availability features that solidify an enterprise’s ability to rely on the environment to deliver consistent, always-on results.
    • Scalability – Features like clustering and replication allow SQL Server to scale better than many entrenched platforms.
    • Extensibility – Perhaps one of the best features, SQL Server is very extendable. Features like CLR integration, close ties to the operating system, Azure (cloud database services), and integrated security controls makes SQL Server easy to extend based on your enterprise’s needs.
    • Flexibility – SQL Server can be used in narrow-focus platforms, such as mobile devices, or in very broad, multi-tiered enterprise applications.
    •Simplicity – SQL Server is arguably the most simple enterprise database platform to administer and develop.

  28. SQL Server is the best database because it has the widest compatibility, broadest client appeal and most compelling new features. SQL Server can be used anywhere from small embedded desktop applications to large distributed database farms allowing applications to scale better than any other DBMS on the planet. SQL Server continues to add new features like table valued parameters, GIS data types, streaminsight and data mining are but a few examples of how SQL Server has been extended to meet customer needs while still providing outstanding performance and ease of development making SQL Server better than any other DBMS out there.

  29. definitely Sql Server is hell lot better than other databases i have used like My Sql and Oracle.
    Following are the features i think contribute to above:

    1) More user friendly GUI
    2) Most of the drivers required are already installed for windows
    3) Largely used as commercial database in most of the companies
    4) index able views
    5) Graphical view designer
    6) Computed Columns
    7) ACID Compliance
    8) Merge operator to perform update,insert and delete in single query
    9) Replication
    10) Can program stored procedures/functions in multiple languages
    11) Can define custom aggregate functions
    12) Can write Set/Table returning functions that can be used in FROM clause
    13) Various Date Time supported data types including time zone also(DateTimeOffset date type)
    14) Windowing function
    15) Advanced Database Tuning Wizard
    16) Maintenance Plan Wizard

  30. SQL Server is better because:
    – it integrates better with other microsoft products, including developer tools and office products.
    – it provides scalability; from ‘hidden’ single user /desktop systems through to terrabyte farms.
    – it is versatile; it includes not only traditional RDBMS features but also OLAP, Reporting, ETL, etc.
    – it is easy to install and administrate and manage; does not require a DBA
    – it continues to grow as a product, with each new major release adding significant additional features

    Basically, it does the job without getting in the way.

  31. SQL Server a better RDBMS

    1. Very User Friendly in every aspects may it be installation / usability / Maintainbility

    2. Has evolved very nicely along with every version and is now loaded with all the features which an ideal RDBMS system should have.

    3. Being evolved as database, now SQL Server has spread its tentacles in fields of BI with its tools SSIS / SSAS / SSRS, SSIS today is considered a very beautiful tool for data migration.

    In addition there are many more features / attributes which makes the SQL Server the best and cannot be mentioned in single comment, but surely in comming days SQL Server will be the best.

  32. 1 Drivers are already installed on Windows (integrate seamlessly with desktop apps)

    2 Lot of commercial application support

    3 Graphical View Designer (e.g. you can see tables and select fields drag lines to do joins) included no additional charge

    4 Computed Columns

    5 WITH CUBE

    6 Windowing Functions OVER..PARTITION BY

    7 Advanced Database Tuning Wizard

    8 Maintenance Plan Wizard

  33. -User-friendly interface
    -The very best learning curve
    -Less-time adoption
    -Excellent Quality/Price ratio

    And much more…

  34. 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.

  35. 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!

  36. 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.

  37. 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

  38. 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

  39. 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.

  40. “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.

  41. 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.

  42. 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.

  43. 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.

  44. 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!!!

  45. 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.

  46. 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.

  47. 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.

  48. 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.

  49. 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!

  50. There are many reasons that makes Sql server far better than other rdbms.In simple words i like to say
    1)GUI -it has got better GUI than other RDBMS
    2)User-friendly
    3)Intellisence:it has intelligence which can show all the commands r syntax when we type the starting letters
    4)Integration with other applications and also the support it gives to dot net apps is superb and which is essential for every RDBMS
    5)debugging is very easy and it is easy to identify errors thru the error msg we get ………….this is a big victory over other rdbms
    and it also provides some built in functions and databases which helps to learn better sql and debugging and the list goes on……………………………………………………………………………………………………..

  51. Compare to other RDBMS, SQL Server is more
    user-friendly, easy to leran, easy to maintain.
    Cost is comparatively modest.
    Performance is excellent, and the optimizer is more advanced.
    It’s the best RDBMS for Window platform.

  52. Let’s be frank the others “kinda sux” in comparison. SQL Server is like the Millennium Falcon in Star Wars it always seems to come through with the hyper drive just when you need it. When the evil Lord Vader (Data Problems) comes along you have a light saber (MSDN Forums) close by. Everything is so easy, just like the saying “May the Force be with you!” I can drop and drag my way into any source solution. It is like i do not even have to think about what i am doing. Others such as Oracle 9i I have to really think about what i am doing. It’s like being on a speeder bike on forest moon of Endor there is always some obstacle to over come. SQL Server is by far the best RDBMS Applications on the market for being easy to use, price, data management, self-tuning, self organizing, and self maintaining. Love it and use it.

  53. Let’s be frank the others “kinda sux” in comparison. SQL Server is like the Millennium Falcon in Star Wars it always seems to come through with the hyper drive just when you need it. When the evil Lord Vader (Data Problems) comes along you have a light saber (MSDN Forums) close by. Everything is so easy, just like the saying “May the Force be with you!” I can drop and drag my way into any source solution. It is like i do not even have to think about what i am doing. Others such as Oracle 9i I have to really think about what i am doing. It’s like being on a speeder bike on forest moon of Endor there is always some obstacle to over come. SQL Server is by far the best RDBMS Applications on the market for being easy to use, price, data management, self-tuning, self organizing, and self maintaining. Love it and use it.

  54. SQL Server is an enterprise ready database platform that provides high performance, scalability, availability and a vast array of easy-to-use features, all at a low price.

  55. 1. Installation and configuration is easy.
    2. It have all the required Tools to manage Enterprise level database.
    like Performance profiler,sql query generation UI.,Query planner. SSIS/SSRS/SSAS.

    3. Wizards for performing operations
    4. Cost effective
    5. Integration with .NET CLR
    6. Azure: Cloud support to save hardware and resource cost.
    7. Database audit log
    8. Policy management in DATABASE.
    9. single environment to manage multiple database servers from DBA desk.
    10. Shell programming is power full feature in MS sql server.
    11. Secure and scalable database
    12. MS sql can fit for all size of organizations it have different type of license as per requirement that making it loving for All type of business organizations.

  56. -It is easy to Install and use.
    -Compact for both developer and Administrator.
    -Cost is low when compare with other products.
    -It Microsoft products to reach end users.

  57. SQL Server is better than any other RDBMS applications because of following reasons.

    SQL Server is a quality product that meets most business needs most of the time, at the lowest price point of any major DBMS vendor.

    It has super usability at low cost,easy installation,self-tuning capabilities, graphical administration, integrated business intelligence and extensive collection wizards,real-time BI, management tools, database mirroring, integrated .NET and much more.

    It is most secure DBMS having role-based security for server, database and application profiles; integrated tools for security auditing, tracking different security events and additional sub-events, plus support for sophisticated file and network encryption, including SSL,delegation.

    And more on that now it supports cloud computing with Microsoft Sql Azure.It is a cloud-based relational database service built on SQL Server technologies.

  58. Microsoft SQL Server provides the most intuitive RDBMS management suite that integrates seamlessly with Visual Studio, the most productive software development suite on the market. Microsoft SQL Server offers an ACID compliant RDBMS with advanced database features such as XML support, full-text search, OLAP data-mining and advanced SQL query management. The Microsoft SQL Server product suite offers versions to support everyone from the budget student learner up to the enterprise product manager.

  59. Easy to…

    Learn: SQL Server Express is ready for you.

    Install: GUI based installer, click & click.

    Maintain: SSMS, with friendly GUI.

    Extend: Write CLR sp in VB.NET or C#.

    Develop: Visual Studio has features for it.

    Depoly: Integrated Windows Authentication, reuses your existed Windows Security Identifiers.

    That’s how people choose SQL Server within 30 seconds.
    (ok i lied, maybe longer)

  60. Thank you all for continuing participation!

    This content is open for another 7 days at this moment!

    Keep your suggestions, comments and opinion coming!

    Kind Regards,
    Pinal

  61. Having had experience in several RDBMS products including Oracle, I must say that SQL Server is a superior product due to its scalability, ease of maintenance, flexibility, and overall bang for the buck. As a developer, I have found more capabilities in T-SQL for SQL Server 2005/2008 than in Oracle 10g. Currently I am porting T-SQL stored procedures to an Oracle 10g environment and I get frustrated in taking something that’s easily done in SQL Server and having to create a work-around to get similar functionality in Oracle.

    To put it another way, even if I were offered more money to work on Oracle vs. SQL Server, I’d take the lesser paying job to stick with SQL Server. My overall stress level would be much lower!!

  62. 1. SQL Server is a THE product that meets most business needs almost all the time, at the lower price range of any major RDBMS vendor
    2. SQL Server’s popularity is especially because of its easy installation, self-tuning capabilities, graphical administration, integrated business intelligence and wide range of help wizards
    3. The price-performance ratio is better than it’s competitors
    4. Robust applications can be built with SQL Server as it features built-in log shipping, online backups, failover clusters and native support of virtual servers.
    5. On Scalability lines SQL Server can handle un-imaginable throughputs
    6. Security features include role-based security for server, database and application profiles, integrated tools for security auditing, tracking 18 different security events and additional sub-events, support for sophisticated file and network encryption, like SSL, Kerberos and delegation. Many of these features are available only as extra-charge options on other RDBMs

  63. Pingback: SQL SERVER – Win USD 11,899 worth MSDN Subscription 5 Days to go Journey to SQL Authority with Pinal Dave

  64. When it comes to SQL ,There are many thing to tell..They are
    1) User Interface
    2)It has sepioerate App for Reporting,Integration Service ,Which makes it more effective .
    3)And it has many Wizard in it ,Instead of Queryingl a lot ..
    4)Cost is less when comparedd with other products
    5)A Cool IDE ….

    I like to work with it …

  65. Sql Server is better than any other RDBMS because it does so many things behind the scenes for me. One thing is i don’t need to use Dual. Second, it just works! The ROI by itself is enough to convince anybody to use SQL Server or just migrate from another RDBMS.

    The built-in support for .net CLR types is nice & there is much more to come. We have barely scratched the surface.

  66. Why SQL Server is better than any other RDBMS applications?

    ??!!

    Is there any RDBMS better than SQL Server ?! Judging by the responses, comments posted by the SQL Community and the multitude of web sites and books dedicated to the product no other RDBMS comes close.

    The endless features, level of quality, performance and support for the product speak volumes.

    No other RDMBS has such an active following of MVPs, developers and users that are so passionate about a Product. Supported by Microsoft and a global active community.. no other RDBMS product out there comes close!

  67. 1. friendly GUI
    2. easy to install
    3. free to use (EXPRESS)
    4. easy connect to other RDBMS (Linked Server)
    5. support CLR
    6. database related function all built-in

  68. - SQL Server is loaded with features with effective cost
    - Easy to learn & operate
    - Main different its Microsoft Product , compatible with all Microsoft new Feature
    - Thousand of help material, blog, training , video training, MSDN available
    - power full & easy BI tools
    - there are more thousand of different, but i believe its good because of Microsoft product & its marketing strategy .

  69. Hi everyone,

    1. Sql server Backup and recovery is more efficient and robust
    which is the primary task of a DBA.
    2.Sql server provides the best security among existing RDBMS.
    3.Sql server is not just a DB,it include Reporting services,BI,Utilities for DB ie SSIS make it more than just a Database.
    4.Cheapest Price compared to others with these services.
    5.Very user friendly.
    6.ACID properties are strong.
    7.Daily i am seeing positive in sql server which makes me very happy.

  70. SQL Server is the best database because — it is cost effective, it is complete, it is current with technology, it is the best price performer, it is great on security. Well if you review all of the comments, it is these and probably some more common factors that many people suggested, but . . .
    As an average web developer and the sole IT person for a private school supporting around 80 computers as well as handling three or four websites, I find SQL Server to be the best because it is easy to learn and it does what it promises. It is reliable, not from a technical perspective but on the practical side. One can “pick it up” knowing that it will perform as promised and provide help along the way where you do not know what help you need. While it is strong at the enterprise end of the spectrum, it is easy for the little guy to figure it out and make great use of its features so to allow guys in a position like mine to use the best tool onthe market without having to spend a year of his life learning how to use the tool. Intentionally or not, Microsoft designed a great, high end enterprise database that works wonders for the guy who is not part of that huge enterprise.

  71. First upon, thanks for bringing this questions. I had heard lots of arguments comparing one RDBMS with another and believe me the debate never ends.

    What we can think is how one RDBMS better than other – one thing must be remember; what you think is good, could be bad per other opnion.

    I like SQL Server because of its SIMPLICITY. I learned SQL commands over Oracle (ah! it was too long that I used oracle and never touched it again after being FRIENDLY with SQL :) ).

    I like following attributes of SQL Server hence I loved this one… and as I am trying to deep dive into technology I am being passionate lover… :)

    1. First thing I liked is as said its SIMPLICITY.
    2. Easy Availability– one dont have to pay huge bucks to make SQL Available.. he can use Express edition available free.
    3. Uncomplicated installation process – follows the same standard as of other MS Product like MS-Office etc… that no one need special knoledge of installation process to get ready to use SQL.
    4. Can be install on Average system – like few other RDMS, SQL do not have special hardware requirement. so one can be benefitted without having his/her system upgraded.
    5. User friendly UI. again abide to MS standard for all other application so anyone feel friendly on first visit.
    6. Easy navigation through common shortcuts and tool box. I dont have to remember multiple keys to navigate.. what works in MS-Office / VS etc.. almost works in SQL as well.
    7. BOL – help documentation is easily available and more friendly to browse to get the correct help.
    8. Perfect match for all level of organizations… small firms to big enterprise to data store.
    9. Perfect suite of application – good clubing and packaging of Database engine, Agent Service, Notification Service, Reposting Service, Analisys Service, Integration Service.
    10. Support for Multi- Instance and side by side installatio of multiple versions.
    11. Enhanced Security
    12. Enhanced Optimiser
    13. availability for various technologies to support high availablity like Log Shipping, Replication, Clustering, Mirroring etc..
    14. Easy to tune up, one can easily tune up the performance with help of wizards and additional tool like Profiler etc litle knowledge.
    15. Advancement in the technology.. like SQL Azure, CLR integration, DAC, Intellisense (though I didnt like current intellisense but it helps often).
    16. Broader community – I like the SQL community, in Fact I have sharpened my skill through this community.. where you can easily catch up with SQL MVP or MS SQL Team. I love dedication you guys shown up in communities. I believe that if someone is in crisis, this community will never let him get down with SQL.
    17. non ANSI functions in SQL are similar to other programming languages hence feels comfortable and dont have to dig more to find the right function that is equalent in something like in .net.

    ah… I never thought I can praise SQL Server in these many ways, still there are lots of things that are poping up in my mind.. like Query Plan and its help and documentation to understand one… like files and file groups are utilised.. I remember having problem when one dont know where does the RDBMS technology keeps the data file, but that never happen with SQL… how friendly are the extended procedures and DMO’s…Centralized Server management, Data collection, Resource Governer.. Oh No!!again I found myself in a state of praising each feature delivered by SQL.

    Wrapping up as time to be with someone special – SQL Server.

  72. 1- Great GUI
    2- Easy setup and config
    3- T-SQL very simple and do powerful action
    4- Low Cost for many feature
    5- Great Services like Reporting Services, etc.
    6- Integrate with SharePoint
    7- best support
    8- CLR functionality that one of best SQL Server features.
    9- Great tools for performance tuning
    10- Scalable and Secure database
    11- Shell programming

    and many more other option that is better than any RDBMS.

  73. Its the best because.

    It can be free
    It integrates with everything
    Its easy to install
    Its pretty flexible
    Its the right size

    Awesome community support

    With all that said, is the best bang for your money and time.

    Well and lets not forget, that is best because I know I lot about it and I want the subscription.

  74. The answer is easy. Ease of use with Max. Performance so many things you can do without losing your sleep over how to those things

  75. There are numerous reason why sql server is better than any other RDBMS. Following is some of them.

    1.
    Very very straight forward installation, the very first step that attrack users.

    2. The interface is extremely user friendly, and one can learn it without much efforts.

    3. Fulfills every one requirement, from small to enterprise level businesses.

    4. Trival / Free, EXpress, version is available.

    5. A very huge online helping community is available, so if you face a problem there are so many people to help you.

  76. User friendly interface – Any Body Can Learn By Own To Clear All RDBMS Concept.
    Installation Is Simple
    Support – I can always find them when I need them. This is the most important thing in my opinion.
    As There are lot of reason N Number Of Features is Added Hat’s On Top.
    Tools From Red Gate.

    Thanks To SQL Server From Where I Learn A Lot

  77. Threre are serveral reasons why SQL Server is better then other RDBMS.
    1.We can pass any integer value as a string which is not possible in any other RDBMS like passing value 20 in Sql as ’20′.
    2.Easily take Backups and also Restore method is quite simple.
    3.Manage Indexing is very simple and strong.
    4.Maintain Large Database is easy.
    4.Lower Cost,Lower Maintaince,Time Saving so Best Solution compare to others.

  78. One big fact is sql is more populer then other.
    Sql is more freiend to use like OS Xp then other.
    Also SQL give power full security thats reason SQL Server is better than any other RDBMS applications

  79. Hi,

    It is easy to install and administer.

    It is rapid development from one version to other version.

    New type of features like CLR Integration added. It is not found in other RDBMS applications.

    SQL Server is having excellent User Base and highly knowledgible MVP’s like Mr Pinal and others.

    Immediate help from Sql Community for any problem in sql server.

    Excellent Help from BOL

    etc., etc.,

    Thank you and regards
    Y. Rama Krishna

  80. There are Several Reason Why SQL Server is Better Then Other.

    1..Easy to use and administer
    2..Flexible and functional out of the box
    3..Inexpensive compared to the competition
    4..Easy interoperability and migration path

  81. It implements all the 12 rules of Dr. E. F. Codd, which makes it a better “RDBMS” than others in market.

  82. “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.

  83. 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?

  84. 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 ;-)

  85. 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…

  86. 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.

  87. 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.

  88. 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

  89. With most other RDBMS it seems to take ten people to accomplish a task that one person can do with SQL Server.

  90. 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

  91. 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.

  92. 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.

  93. 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.

  94. 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.

  95. - 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.

  96. 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

  97. 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

  98. 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

  99. On the *same* hardware running NT – SQL Server has the best tpcc numbers. (www.tpc.org). Oracle has higher tpcc numbers but only on non-NT platforms – and the cost per tpcc is higher.

    Mobile/client version of product is exactly the same as the server one (with Oracle it isn’t)

    SQL is generally accepted as easier to install, use and manage

    SQL Server is cheaper to buy than Oracle (though this is such a small part of lifetime support costs it really shouldn’t be a consideration)

    Extra facilities “in the box” – e.g. OLAP, English Query, DTS

  100. following are the reason why SQL Server 2008 is better RDBMS

    1. Eeasy to Install
    2. Can be programaticaly managed by SMO.
    3. We can use functions developed in C# with the help of CLR. It provides a top-up functionality by using features of C#.
    4. SSIS:- Help us in talking with any type of data & to put in the required place.
    5. SSIS:- It also help us in transforming data before putting in the destination.
    6. SSRS:- No need to have any other reporting tool. SSRS can do what you can think in terms of report.
    7. SSRS:- Develop & render report in any format, according to your choice.
    8. Provides various features in T-SQL like ‘if exist’ which is unavailable with other RDBMS.
    9. SQL Server installs and runs smoothly with the Visual Studio development suite which is unavailable with Oracle. YOu need to do some settings.
    10. Comes with the bundel SSRS, SSIS & SSAS with SQL Server.
    11. YOu can work with XML datatype.
    12. Features like clustering and replication allow SQL Server to scale better than many entrenched platforms.
    13. SQL Server can be used in narrow-focus platforms, such as mobile devices, or in very broad, multi-tiered enterprise applications.
    14. Security features include role-based security for server, database and application profiles, integrated tools for security auditing, tracking 18 different security events
    and additional sub-events, support for sophisticated file and network encryption, like SSL, Kerberos and delegation.

    On the top it is from Microsoft & also its price is less in comparison to Oracle.

  101. SQL Server provides a growth path for any application. As an application requirement expand, the SQL Server platform provide a path for supporting the growth. From Sql Compact Edtion thru the Data Center Version, the software is similar enough to support any type of application.

  102. Microsoft SQL server is a relational database management system.

    * SQL Server is a RDBMS, a complete database.
    * It uses MS- SQL as the query language.
    * SQL Server offers a high level of security, reliability and scalability depending on the business needs.
    * The server offers a wide data storage, full text query search, buffer management, logging and transaction, fast data retrieval etc.
    * It offers a variety of replication services to avoid loosing data.
    * It offers SQL Server Reporting Services for data gathered from the database.

    * SQL Server is compatible with structured query language and has rich support for XML.
    * SQL Server includes number of features that support ease of installation, deployment, scalability, data warehousing and system integration with other server software.

    * Database engine-It provides support for data access interfaces like ADO, OLEDB and ODBC. Replication-It enables to maintain multiple copies of data on different computers and also keep data well synchronized.
    * DTS-It is for importing and transferring data from multiple heterogeneous sources. It is used to build data ware housing and data marts by the process of extracting data from multiple OLTP systems.
    * Analysis services-It organizes data from data warehouse cubes to provide rapid answers to complex queries. Analysis the data stored in data warehouse and data marts.
    * Meta data services-It is a set of services that helps to manage metadata.
    * Metadata describes meaning and description of applications and processes.

    * SQL Server has Logical Architecture and Physical Architecture.
    * The data is organized into logical design that is visible to user.
    * Logical components include objects, users, roles, collations, logins and groups.
    * The database itself maintains data as files on disk.
    * Logical components Objects include table, data type, view, stored procedure, function, index, constraint, rule, default and trigger.
    * Collations Control how character strings are stored physically and the rules by which character are stored and compared.
    * Logins-Each database user should have login id to allow database to identify.
    * Users are who can connect to database.
    * Role is a single unit of users having same permission.
    * Physical Architecture-Page and extents describes physical database organisation.
    * Page is the fundamental unit of data storage. Page is divided into data rows which contain all data.
    * Extents is the place where tables and indexes are stored.

    * Allow us to create and manage all objects.
    * Client application communicates with SQL server by transact-SQL statement.
    * SQL Server supports 3 types of transact-SQL statement namely DDL, DLL and DML

  103. because of its simplicity & robustness.
    It can work in efficient manner for small scale application and as well as larger auditence & business application/domain.

    upgradations are narrowly related with previous versions. So develloper can easily upgrade themself.

    It is MS product it can work along with Security module of windows to manage the data security.

  104. SQL Server implements several features required of a robust RDBMS solution. SQL Server has many advantages to offer in regards to implementing a relational database.

    SQL Server provides an end to end RDBMS solution that allows frictionless installation, configuration, role management, and data backup and recovery. The user friendly interface allows both developers and admins to unlock the rich feature set that a true RDBMS solution can provide in the least amount of time.

    Advanced features and optimization techniques can be attained with the use of table variables, XML support, clusters, and indexes. SQL Server has the capability to have redundancy by the use of nodes/clustering or mirroring. SQL Server’s ability to import/export data (SSIS), generate reports (SSRS), and analyze the data growth (SSAS) are an added boon.

    These are features that are essential to real world situations where teams are working together to collaborate on basic data driven websites all the way up to enterprise level projects. One significant benefit of using SQL Server is its close integration with Visual Studio CLR which allows application developers to interface seamlessly with the business logic layer. Overall SQL Server meets the needs of application development and tightly integrates with .NET Framework.

  105. Mobile/client version of product is exactly the same as the server one

    SQL is generally accepted as easier to install, use and manage

    SQL Server is cheaper

    Includes OLAP, English Query, DTS

  106. It is my bread-and-butter and its the same for many thousand others. I love working on this, and thats why it simply IS THE BEST!!!

  107. First, SQL Server is highly recommended
    for situations where the volume of data grows rapidly,
    spending precious resources, without a management
    standardized data.

    * The high performance of the new version allows companies
    stagger safely and available from a project
    Small to high volumes of data and transactions.

    * Merge and standardization of heterogeneous data with
    Integration Services. Through the Integration Services is
    possible to obtain, standardize and “clean” data originated
    from different sources such as ISPs. NET, ODBC, OLE DB and flat files with Excel and XML.

    * Through the resources of StreamInsight, we
    provision made quick decisions based on
    information from multiple data sources, all in
    memory, if necessary, can be persisted in the database.

    * Availability of data in the cloud with SQL Azure
    Database without worrying about backup and administration

    * Ability to dynamically add CPUs and memory
    a running system;

    * Work with up to 64 GB of memory systems 32
    bits through the AWE (Address Windowing Extensions), even
    these being limited to 4 GB.
    BI high-performance and easy access to users
    common across the Power Pivot (Excel 2010 and SharePoint
    2010).

    * Geographical representation and geometric with Spatial Dates,
    for displaying maps, routes and custom shapes.

  108. Pingback: SQLAuthority News – Last 2 Day to Win MSDN Subscription – Total 2 to Win Journey to SQL Authority with Pinal Dave

  109. SQL Server is better than all other RDBMS applications as it offers an unmatched set of tools which can be used to easily manage, transform, and present data throughout all levels of an organization.

  110. SQL Server is better than any RDBMS because ……

    * Robust architecture

    * Manageability
    Management Studio
    Database Tuning Advisor

    * CLR Integration
    Integration with CLR
    Stored procedures in any .NET language
    Triggers in any .NET language
    User-defined functions
    .NET objects stored inside the database

    * Visual Studio Integration
    Can view database objects through Visual Studio
    Ability to debug stored procedures through Visual Studio
    Support for Visual Studio Project
    Auto-deployment of database objects through Visual Studio
    Context-sensitive online help for editing stored procedures
    BI technologies integrated with Visual Studio

    * SOA Application Development
    XML Support
    Native XML type in the database
    XQuery support
    XML update functions
    XML indexes for improved performance

    * Web Services
    Database as a Web service producer
    Database as a Web service consumer
    Integration with Visual Studio
    Primary programming (Any CLR language) language

    * Query Notification
    Query Notification through ADO.NET

    * Asynchronous Message Queuing
    Guaranteed, exactly once delivery
    Queues stored in database
    Transactional integration with database
    Abstraction level(Queues, messages)

    * Integration of BI technologies
    SQL Server Analysis
    SQL Server Integration Services
    SQL Server Reporting Services

  111. Hi Pinal,

    SQL server have all the functionalities and additional features as well which all have mentioned in all the replied posts like user friendly , ado.net , sql clr,etc..
    But the most important thing is that we can easily troubleshoot sql server with using sql server DMV’s and as well easy to tuning the sql server databases.
    like if anyone can stuck with it they can do easily with help with sql server.

  112. It just helps me to solve day-to-day problems. Simply. Smoothly.
    This is why I love it.
    I really doubt people are loving it for its triggers or indexes ))) People love its real-life magic.

  113. PROS:

    1- In RDBM world, SQL has huge Market Share compare to any other RDBM which gives you good opportunity to be part of big MS Community which work together as great solution providers

    2- SQL works in any Small Business or Large Enterprise with its different Versions available to cut the price.SQL improvement came steady which ensure that it has standards meet of your today’s and tomorrow needs.

    3- Job security as I’ve more Job opportunities, since it has large market of customers to support.

    4- Application, User friendly, efficient, cost effective, much more supportive (from Microsoft and community). Leverage to improve your skills gradually with each upgrade version.

    5- Much more as it gives me passion everyday to learn and grow in Knowledge without being some SMART kid but passionate. Thanks Microsoft & competitors !!

  114. I love sql server as it paid me for my work. simple difference is like windows Vs Linus.

    I use Microsoft because it paying me for my work and i love linux because it is free and expandable

  115. Sql Server provides best GUI than other RDBMS.There are number of different versions available to use.So If some donot required a higher version than we can use a express or advance edition of sql server.

  116. 1) SQL Server provides easy to learn and use functionality that will handle almost any database need from the smallest of businesses to large enterprises.

    2) The administration of a SQL Server database is much easier than the leading competitors without sacrificing features.

    3) We have the SQL Authority, Pinal Dave, to turn to when we have questions. :-)

  117. Can SQL run on Linux,Unix ??????????????

    Oracle is the robust and the best DB available in the RDBMS world

    M…S need to open gates for SQL to work on multiple OS…

    • Can SQL run on Linux,Unix ??????????????

      Oracle is the robust and the best DB available in the RDBMS world

      M…S need to open gates for SQL to work on multiple OS…

  118. Here you can , easily know it is better then rest other

    RDMShttp://technet.microsoft.com/en-us/magazine/2008.04.overview.aspx

  119. Pingback: SQLAuthority News – A Monthly Round Up of SQLAuthority Blog Posts Journey to SQL Authority with Pinal Dave

  120. Hello All,

    Due to very heavy response to this contest. The result will be announced now later this week. I will also update the contest with information about judge and their decisions very soon.

    Kind Regards,
    Pinal

  121. Pingback: SQLAuthority News – MSDN Subscription Giveaway Announced Journey to SQL Authority with Pinal Dave

  122. Hi all,

    from time to time I am forced to work with Oracle-DB, so I can compare working/operating with other RDBMs – the most significant things why SQL Server fits at least my needs at best are:

    1. Installation is by way smoother than Oracle
    2. Operating is easier
    3. It is easy to maintain
    4. The Oracle-Client-Components are horrible to install, troubleshoot etc. – sqlncli is an msi-file: easy to deploy
    5. we converted one DB from Oracle to SQL-Server. Result: the performance within the Application was as twice as high as before (same Server-Hardware)

    Greetings,
    Mike

  123. It’s better than the others because its widespread use draws so many people to this forum that a large number of people see this question and ponder it. That in turn will cause perhaps more people to consider situations where say a document database might be more appropriate, or not, depending on what a given business requires, the ultimate goal of course being that we all prosper, lifting us all up to bigger and better things.

  124. Pingback: SQLAuthority News – Why SQL Server is better than any other RDBMS Applications? Journey to SQL Authority with Pinal Dave

  125. Are you kidding me?

    Don’t you ever heard of “PostgreSql” RDBMS?

    -It’s fully ACID compliant
    -It’s completely FREE (Really Free)
    -It’s supports every technical features that supports by Ms Sql Server (Even more…)
    -It’s running on Windows, Linux, Unix, MacOs X, etc…

    please check out this link: http://www.postgresql.org

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s