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?
Hi there, I hope the following answer helps.
The key differences between SQL Server 2005 and SQL Server 2008 are in these following sectors:
Analysis Services - Multidimensional Database
Analysis Services - Data Mining
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
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.
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.
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