關於SQL Server 2008是否是SQL Server 2005的一個Service Pack

隨著SQL Server 2008越來越多地進入到大家的視線中，也有越來越多的聲音說SQL Server 2008 (Kaitmai)僅僅是SQL Server 2005的一個補丁包。當初我也是這個想法，因為我們把太多的目光放到了例如Geo-Spatial支援、Hierarchical ID、File Stream上，確實這些功能都是建立在SQL Server 2005搭建的CLR -Integrated平臺上的，但是我們也需要看到SQL Server 2008中的其他功能，例如Resource Governor、Declarative Management Framework、Change Data Capture、Reporting Service IIS agnostic report deployment等等。SteveB在美國Launch中更將Policy-base Management列在SQL Server 2008 Top 10新功能的首位，還有美國Launch上關於Activity Monitor的改進、Object Search以及T-SQL Debugger被使用者愛稱為三項Surprise Features。當然還是會有人說這些都是在DMV和DDL Triggers的技術基礎或技術路線上發展起來的，不過哪個產品不是從一條技術路線或某項基礎性改革上發展起來的呢？

因此微軟把SQL Server 6.0/6.5稱為第一代資料庫產品，SQL Server 7.0/2000稱為第二代資料庫，而SQL Server 2005/2008稱為第三代資料庫產品。以此類推，那麼SQL Server vNext是不是會變成第四代資料庫產品呢，那又會有什麼革命性的改變呢？Grid？...哦，跑題了

因此我們還是應該寬容地看待SQL Server 2008，還是應該升級到SQL Server 2008的，升級有問題可以諮詢EMC MSP麼，哈哈哈~~~~！

附上SQL Server 2008現在的新特性以及改進列表：

Policy-Based Management

Management/performance data collection

extended events

database mirroring enhancements

Query plan freezing

resource governor

transparent data encryption

external key management

Hot add CPU

partition aligned index views

backup compression

Table valued parameters

DDL trigger enhacements

T-SQL programming enhancements

T-SQL Intellisense

Entity data model

LINQ

Visual entity designer

Service Broker enhacements

SQLCLR enhacements

Multi-server query

Configuration servers

Hierarchy ID

Large UDTs

Date/Time data type

Improved XML support

Geography data type

Geometry data type

Filestream

Analysis Services scalable backup

Analysis Services dimension design

Star join query optimization

MERGE SQL statement

Change data capture

Analysis Services MDX enhacements

Analysis Services Personalization extensions

Analysis Services aggregation designer

Analysis Services Data Mining enhanced validation

Analysis Services Data Mining and enhanced structures

Analysis Services MOLAP writeback

Analysis Services dynamic management views

Integration Services C# scripting

Integration Services persistent look-ups

Integration Services data profiling

Integration Services import/export wizard enhancements

Integration Services Improved connectivity

Reporting Services IIS agnostic report deployments

Reporting Services report builder enhancements

Reporting Services core engine enhacements

Improved installation

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/9079672/viewspace-217107/，如需轉載，請註明出處，否則將追究法律責任。