关于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
  • Advertisements
    Post a comment or leave a trackback: Trackback URL.

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s

    %d bloggers like this: