SQL Server 2008 R2 (rtm) release to manufacturing was in the market in 2010,
SQL Server 2008 R2 is sophisticated released by Microsoft added number of new features and functionality in this version.
SQL Server 2008 R2 is sophisticated released by Microsoft added number of new features and functionality in this version.
SQL Server R2 includes number of new and enhanced functionality without purchasing any new component license like other has been following this model, I am just outlining such issue that might have been faced by number of IT guys, when they are going to select or decide such a strong database for their organization. You may consider other than SQL Server 2008 R2 but please do a good research and try to download free trial of such databases server. Like you can ask from IBM to deploy a trial version in your organization environment and you also can request Oracle to deploy or you can install it by yourself – and try to test full load on this test environment.
IBM also a big company and invested millions in research so do a good research when you are going to buy any database solution for your organization like IBM DB2 etc.
SQL Server 2008 R2 supports many feature in terms of total cost of ownership where as oracle may be missing somewhere in our opinion. What Microsoft SQL Server 2008 R2 supports with single license they are:
- Column compression,
- Module signing using certificate,
- SQL Server data services,
- Power Shell,
- Policy based management etc.
For such feature you might consider paying more for oracle if you want to get such feature in oracle environment.
Microsoft has also released sql management studio to manage database on client pc's.