To configure Extended Protection in SQL Server 2008 R2, follow these steps: Open the SQL Server Configuration Manager. Expand Network Configuration. Right-click on Protocols for <Your Instance Name>.

Resolving locking issues with SQL Server 2008 R2 can be troublesome -- but it can also be surprisingly straightforward.

Pop Quiz Pop Quiz: Windows Server 2008 R2 DNS Configuration Applies to the "Configuring Domain Name System (DNS) for Active Directory" objective of Exam 70-640. By Andy Barkl 03/04/2014 Q: A company's ...

Microsoft released SQL Server 2008 R2 Service Pack 2 this week and announced that it's available for download.

SQL Server 2008 R2 Server Management Self-Service Business Intelligence The ability for end-users to do their own analysis and reporting on data is a nice new feature for SQL Server 2008 R2.

For those legacy SQL Server 2008/R2 applications that remain critical, some form of high availability or disaster recovery protection will be required to preserve business continuity.

SQL Server 2008 R2 will be available as part of Microsoft’s Small Business Server package. That version has the same features as the standard edition, but is limited to 75 users.

Applies to the 'Configuring Active Directory Roles and Services' objective of Exam 70-640 TS: Windows Server 2008 Active Directory Configuration.

SQL Server 2008 R2, Office 2010 and SharePoint 2010 are tied even more tightly than other "better together" products around PowerPivot.