Explore BrainMass
Share

Explore BrainMass

    Information Systems- SQL Servers

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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?

    © BrainMass Inc. brainmass.com October 10, 2019, 5:25 am ad1c9bdddf
    https://brainmass.com/business/management-information-systems/information-systems-sql-servers-504715

    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