Datasheet

Easier updates
System objects are in the resource database in SQL Server 2005. When a
service pack or other update is applied to a SQL Server instance, replacing
the resource database updates all the system objects. This gives a more
easily manageable upgrade path.
Replication
The setup and administration of replication has been improved in SQL Server
2005. This is carried out from SQL Server Management Studio. There is a new
system health monitor to allow you to check on replication settings and per-
formance. For example, it can tell you how long replicated data takes to reach
subscribers.
WMI configuration
Windows Management Instrumentation (WMI) allows you to carry out a range
of configuration tasks such as specifying client and network settings. You can
also use WMI to determine whether you can safely and effectively carry out a
task at a particular time. For example, you can test whether a target drive has
enough disk space to carry out a backup.
Database Mail
Database Mail is a new feature. It replaces SQLMail, which was present in SQL
Server 2000. Database Mail uses Simple Mail Transfer Protocol (SMTP). There
is no longer any dependency on the Messaging Application Programming
Interface (MAPI), and Outlook is no longer required. The removal of these
dependencies avoids many of the availability problems that SQL Server 2000
users had with SQLMail. In addition, Database Mail is cluster aware, unlike
SQLMail. Database Mail supports logging and auditing.
Availability Enhancements
SQL Server 2005 supports three broad types of enhanced availability:
⻬ Concurrent data access
⻬ Availability after server failure or other disaster
⻬ Availability during database maintenance and repair
29
Chapter 2: New Features in SQL Server 2005
06_577557 ch02.qxp 12/20/05 9:43 PM Page 29