Thursday, March 5, 2015

Features of SQL Server 2008 / 2012.


Features of SQL Server 2008.

  1. Activity Monitor.
  2. SQL Server Audits.
  3. Backup Compression
  4. Central Management Servers.
  5. Data Collector & Management Data warehouse
  6. Data Compression
  7. Policy based Management.
  8. Predictable Performance & Concurrency.
  9. Resource Governor.
  10. Transaparent Data Encryption.

Features of SQL Server 2012.
  1. Always on Availability Groups.
  2. Windows Server Core Support.
  3. Column Store Indexes.
  4. User Defined Server Roles.
  5. Enhanced Auditing Features.
  6. BI Semantic Model.
  7. Sequence objects.
  8. Enhanced Powershell Support.
  9. Distributed Replay.
  10. Power View.
  11. SQL Azure Enhancement.
  12. Big Data Support.




No comments: