SQL Server 2008 Brochure is available to download. It contains many information like available Server Editions, Top New Features, New Available Technologies and additional resources.
Top New Features
- Use Resource Governor to manage concurrent workloads
- Enforce policy compliance consistently across the enterprise with the Policy-Based Management
- Reduce storage requirements and increase query performance with data compression and Sparse Columns
- Protect sensitive data with Transparent Data Encryption and advanced auditing
- Troubleshoot, tune, and monitor SQL Server 2008 instances across the enterprise with Performance System Analysis
- Build high performance analysis solutions with scalability, performance, data mining, and user interface enhancements in SQL Server Analysis Services
- Take advantage of improved performance,usability, visualization, and integration with the 2007 Microsoft Office system in SQL Server Reporting Services
- Integrate location-enabled applications through support for spatial data
The Codename of the SQL Server 2008 is Katmaii and it was released in the year 2008 (of course). The full-text search functionality has been integrated with the database engine. SQL Server includes better compression features, which also helps in improving scalability.
Here is the question for you – are you still using an earlier version of SQL Server? Please leave a comment below.
Reference : Pinal Dave (https://blog.sqlauthority.com),