I realized after reviewing the past few posts that I omitted a new piece of functionality introduced in SQL Server 2008 R2. This feature, known as Extended Protection for Authentication (Extended ...

SQL Server 2008 R2 Upgrade Advisor – will anaylyze instances of SQL Server 2000, SQL Server 2005 and SQL Server 2008. To ensure preparedness and a smooth transition into SQL Server 2008 R2. The ...

Microsoft makes good on commitment to continue improving older solutions, but the support will eventually end for this version as a newer, cloudified version 2014 takes over. In what is a commitment ...

Microsoft released SQL Server 2008 R2 Service Pack 2 this week and announced that it's available for download. The new service pack fixes some minor issues, and not much has apparently changed since ...

SQL Server 2008 R2, which ships this month, allows end users to tap into the powerful business intelligence features of SQL Server via tight integration with popular Microsoft applications like Excel.

Database troubleshooting is not for the faint of heart, especially when it comes to troubleshooting locking and blocking problems. Sometimes the elephant in the room is actually a rhino, a problem ...

Microsoft on Friday announced when it will release new service packs for two of its SQL Server products. The company plans to release new service packs for both SQL Server 2008 and SQL Server 2005.

July 9 marked the end of "extended support" for SQL Server 2008 and SQL Server 2008 R2, the last five-year phase of Microsoft's overall 10-year product lifecycle for these products. The two servers ...

Those that are considering migration to 2008 should just go to 2008 R2. As it's been noted, the DB engine changes are minor, but improvements to Analysis Services and Reporting Services are HUGE. I ...