Microsoft SQL Server 2008 R2 features, requirements: Study guide

Test your knowledge of Microsoft SQL Server 2008 R2 features, hardware and system requirements and find out how to benefit from new features such as Master Data Services.

Before implementing Microsoft SQL Server 2008 R2 for your customers, you're going to need to know the ins and outs of this newest SQL Server release. This study guide will test your knowledge of SQL Server 2008 R2 features and requirements and prepare you to answer questions from your customers.

From the Standard to Datacenter edition, there are many different SQL Server 2008 R2 features available that solutions providers need to be aware of. This guide also explains pricing for each edition. You will get information on Microsoft SQL Server 2008 R2 requirements, including hardware and system prerequisites, to help you determine whether this new release fits into your customers' environments. You will find out more detailed information, including how many nodes are needed in the Parallel Data Warehouse feature, as well as the main advantages of using the Resource Governor.

The SQL Server management pack for System Center Operations Manager (SCOM) 2007 R2 is just one of the SQL Server 2008 R2 features that solutions providers can use to make monitoring a simpler process. Using this study guide, you'll learn about SCOM and another key component in Microsoft SQL Server 2008 R2 -- Master Data Services. You also need to know the Microsoft SQL Server 2008 R2 requirements if you want to install Master Data Services or use the utility control point (UCP) properly.

After completing this quiz, you will gain access to more resources on Microsoft SQL Server 2008 R2 features, editions, monitoring and system requirements.

This was last published in May 2010

Dig Deeper on Database software management

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.