Information Systems- SQL Servers
Not what you're looking for?
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?
Purchase this Solution
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.
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 ...
Purchase this Solution
Free BrainMass Quizzes
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.