Saturday, August 29, 2009

New Features Of SQL Server

New Features of SQL Server 2000:
  1. User-defined functions
  2. Indexed views
  3. Distributed partitioned views
  4. INSTEAD OF and AFTER triggers
  5. New data-types
  6. Cascading RI constraints
  7. Multiple SQL Server instances
  8. XML support
  9. Log shipping
New Features of SQL Server 2005:
  1. Database Mirroring
  2. Online Restore
  3. Online Indexing Operations
  4. Fast Recovery
  5. Standards-based Information Access
  6. SQL Server Management Studio
  7. Dedicated Administrator Connection
  8. Snapshot Isolation
  9. Data Partitioning
  10. Replication Enhancements
New Features of SQL Server 2008:
  1. Policy-Based Management
  2. Performance Data Collection (Data Collector)
  3. Data Compression
  4. Resource Governor
  5. Transparent Data Encryption
  6. External Key Management / Extensible Key Management
  7. Data Auditing
  8. Hot-Add CPUs and Hot-Add Memory
  9. Streamlined Installation
  10. Server Group Management
  11. Upgrade Advisor
  12. Partition Aligned Indexed Views
  13. Backup Compression
  14. Extended Events
New Features of SQL Server 2008 R2:
  1. Support for 256 logical processors
  2. Improvements in multi-server management
  3. Master Data Services
  4. Geospatial visualizations in Reporting Services
  5. Self-service BI with Project Gemini




sql server 2000 new features. sql server 2008 new features. sql server 2012 new features. sql server 2008 r2 new features. difference between 2008 and 2012. sql server 2008. sql server 2012. sql server 2005 new features. sql server 2012 major features. sql server features. new additions in sql 2012. sql denali new features. new addition in denali. new look of 2012 sql server. Top 10 SQL Server 2008 Features for the. What is new in SQL Server 2012. denali. My Top 5 SQL Server 2012 Features. New Features in SQL Server 2012. Four Tutorial for SQL Server 2012 New Features. sql server new features 2008 for developers. sql server new features 2008. new features sql server 2005. windows new features. virtualization new features. microsoft new features. new features performance. monitoring sql 2008 management

0 comments:

Post a Comment