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:
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. Visualization
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.
SOURCE: COPIED FROM A CONTEST - WINNER POST
1 comment:
Just Compare these features:
1. SQL Server provides only one mirror/standby database server and Oracle provides 80+ redundant Servers.
2. SQL Server only installed on Windows Operating and Oracle Installed almost on all hardware and Operating systems.
3. SQL Server provides just Clustering for High Availability (Failover Cluster) and Oracle Provides cluster for both High Availability and High Performance.
4. SQL Server Cluster provides only one Active node in clustering and oracle provides all Active-Active node clustering.
5. Oracle Management Studio is very easy tool for Administration just like Management studio of MS SQL Server with Proactive monitoring approach.
Post a Comment