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.

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

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

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.