New Features in SQL Server 2008

Top New Features in SQL Server 2008, which overtakes the perivious version of SQL Server 2005.

Data Compression wizard

                   By Data Compression wizard configuration is easy and it helps to save disk storage, for each and every individual tables or indexes compression option is enabled, compression can improve disk I/O and memory utilization.

Upgrade Adviser

                     These reports provide links to technical information that assist in addressing upgrade problems and it provides administrators detailed information that can be used to prepare for upgrades.

Server Group Management

                  Here servers do not need to be configured individually, due to management is centralized. Stream results of multi-server queries into a single result set or into multiple result sets are possible.

Data Auditing

                      By this new feature we can audit logons, password changes, data access and modification etc. audit results can be saved in to file or in to the Windows Security or Application logs for later analysis or archiving.

Streamlined Installation

                  Independent SQL Server components, such as Database Services, Analysis Services, and Integration Services, can be optionally selected for installation. SQL Server 2008 installation process is to be easier and more efficient.

Table-Valued Parameters

To the Developers it reduces complexity and simplifies the process of working with data sets and data tables. It allows stored procedures to accept and return lists of parameters so here Developers can write applications that pass sets of data into stored procedures rather than just one value at a time.

CLR Enhancements

                        User-defined aggregates (UDAs) and User-defined types (UDTs) now enhanced up to 2GB of data and can accept multiple inputs. Using UDAs and UDTs with larger data since 8KB size limit restriction has been removed.

Design Alerts

                 Design mistakes are underlined in blue; this is similar to spelling mistakes are underlined in red in Microsoft Word. And now we can see the full explain of warning by placing our arrow on the underlined object, and can disable AMO warnings if you choose.

External Key Management

                    It gives option to storing the keys separately from the data which ensures to more extensible and robust security architecture so helps organizations comply with data privacy regulations.

DATE / TIME Data Types

                      DATETIME2 refer Coordinated Universal Time (UTC) instead of the system time for greater accuracy and the new DATETIMEOFFSET data type gives  time zone support by storing date, time and offset such as 'plus 5 hours'.