Explore BrainMass
Share

Information Systems- SQL Servers

This content was STOLEN 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 25, 2018, 7:29 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
See Also This Related BrainMass Solution

Emerging technology article

Please help me with this:

For this assignment, each student must find a recent article (published within the last month) on an emerging information technology that interests you and write a max. 1 page analysis.

FROM ATTACHMENT:

For this assignment, each student must find a recent article (published within the last month) on an emerging information technology that interests you.
1. Begin with a one paragraph abstract of the article--the "What" that summarizes the nature and capabilities of the technology. Cite the source of the article and provide a hyperlink to the article.
2. In the remainder of your write-up, provide the "So What":
a. Tell us why the technology in question is important for managers to consider and
b. Describe the potential impact of this technology on business in the foreseeable future.

Note: Articles are primarily graded on the value of the "So What" analysis. (Maximum 1 page)

View Full Posting Details