Share
Explore BrainMass

Information Systems- SQL Servers

Using the Online Library, the Internet, and all course materials, locate information about the differences between SQL Server 2005 and SQL Server 2008.

Try to complete the following:

*What are some of the improvements made between these two versions?
*Why are these changes important?

Solution Preview

Hi there, I hope the following answer helps.
Answer:

The key differences between SQL Server 2005 and SQL Server 2008 are in these following sectors:

Database Engine
Analysis Services - Multidimensional Database
Analysis Services - Data Mining
Integration Services
Replication
Reporting Services
Service Broker

In other words, the SQL Server 2008 is an improvement over the SQL Server 2005 on the above sectors.

What are some of the improvements made between these two versions?
On a more detailed approach, the following areas are specifically improved in the SQL Server 2008, surpassing the SQL Server 2005:

Transparent Data Encryption- The ability to encrypt an entire database
Backup Encryption- Executed at backup time to prevent tampering
External Key Management- Storing Keys separate from the data
Auditing- Monitoring of data access
Data Compression- Fact Table size reduction and improved performance
Resource Governor- Restriction system of users or groups from consuming high levels or resources
Hot ...

Solution Summary

The solution lists the key differences between SQL Server 2005 and SQL Server 2008. It also identifies the improvements made between the two versions and the importance of these improvements. It contains three references. Two of them are from microsoft and msdn site.

$2.19