Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server 2008 (SSQA.net)

Trusted, Productive and Intelligent enterprise data platform.
What's new, rather removed features from SQL Server 2008 (CTP6)

It has been a 'very busy' month sofar, in particular to Microsoft world and sub-domains of Windows Server, Virtual Server & SQL Server and you know why from here.

Not a 'real' launch for SQL Server folks out there, but a concession to their grief that SQL 2008 CTP6 is available to download and next question will be what's new. Here I would like to cover what have been removed from SQL 2008 features, that means they will not be included in RTM version of 2008 version too.

  • First one to get a shot is Notification Services, as you may be aware since SQL Server 2005 version support cycle the Notification Services component is not included within SQL Server 2008 version and such features will be blended in to Reporting Services engine.
  • Next one to get-boot is SQLDMO which has been replaced with SMO since SQL Server 2005 version. Among all of the Microsoft support/forums/articles pages they are recommending you to modify applications that currently use this feature as soon as possible. The extra concession has been given to support of SQLDMO for SQL Server Express, in this case you must need  Backward Compatibility Components. It is better to get used to the SMO rather than handing out the unsupported components within your Application development work.
  • Third one, a big surprise or rather discouragement to DBA section due to the remove of Surface Area Configuration tool which was a new face from SQL Server 2005 and advantageous than Server network utility as compared to SQL 2000/70 versions.
    • Though SAC will be removed and it has been replaced with the content as follows:

 

Settings and component features

How to configure

Protocols, connection, and startup options

Use SQL Server Configuration Manager.

Database Engine features

Use Policy-Based Management, the property settings in SQL Server Management Studio, or sp_configure.

Analysis Services features

Use the property settings in SQL Server Management Studio.

Reporting Services - EnableIntegrated Security property

Use the property settings in SQL Server Management Studio.

Reporting Services - "Schedule events and report delivery" and "Web service and HTTP access"

Edit the RSReportServer.config configuration file, or use Policy-Based Management.

Command line options

Use the sqlps utility and the Policy-Based Management features provided by the SQLPolicy drive in the SQL Server PowerShell provider.

source: MSDN SQL2008 Readme
Posted: Thursday, February 21, 2008 1:11 AM by SQL Master

Comments

Other SQL Server Blogs around the Web said:

It has been a 'very busy' month sofar, in particular to Microsoft world and sub-domains of Windows

# February 21, 2008 1:18 AM

SQL Server 2008 - CTP (SSQA.net) : What's new, rather removed features from SQL Server 2008 (CTP6) said:

PingBack from http://sqlserver-qa.net/blogs/sql2008/archive/2008/02/21/3598.aspx

# February 21, 2008 1:50 AM

SQL Server Knowledge Sharing Network (SqlServer-qa.net) said:

What's new, rather removed features from SQL Server 2008 (CTP6)

# February 21, 2008 9:01 AM

SQL Server Blog by Jason Massie on SQL Server 2005 and SQL Server 2008. said:

# February 22, 2008 1:55 PM
Anonymous comments are disabled