new features added to sql server 2008

• Database mirroring. Microsoft first introduced this feature
in SQL Server 2005 and enhanced it in SQL Server 2008.
Database mirroring provides data administrators a low-cost
disaster recovery solution.
• Service Broker. SQL Server Service Broker provides an
integrated infrastructure on which developers can create
asynchronous messaging applications.
• Policy-based management. SQL Server 2008 lets you
automatically enforce and monitor policies for database
operations. You can also push these policies to your servers.
• Resource Governor. The Resource Governor lets you limit
the resource consumption of incoming requests by
classifying incoming connections as specific workload types
and defining limits for those types. You can also redefine the
limits in real time.
• Backup compression. SQL Server 2008 can automatically
compress database backups, a feature previously available
only via the purchase of third-party software products.
• Performance data collection. SQL Server 2008 lets you
store performance data in a centralized database. It also
provides enhanced tools for analyzing and reporting on such
performance data.
• New data types. The new SQL Server 2008 FILESTREAM
data type allows you to store large binary data, such as
documents or images, directly in an NTFS file system. Other
new data types include support for spatial data and the time
date type.
• “Hot add” hardware. First introduced in SQL Server 2005,
hot add memory helps system administrators decrease
downtime when important memory upgrades are necessary.
On supported hardware platforms, SQL Server 2008 also lets
you add one or more CPUs while the program is running.