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

With end of support looming for Windows Server 2008 and SQL Server 2008, Microsoft has a new option for those users to keep getting security updates: By moving workloads to Azure.

Microsoft's database releases from 2008 and 2010 reach end of extended support. In response, Redmond says, that for many customers, the time for cloud migration has arrived.

I have taught several classes on the new features of SQL Server 2008, made a Web Seminar and written a Whitepaper on the subject. I have also attended the SQL PASS Summit in Seattle where there ...

New BI and reporting features in SQL Server 2008 R2 hit the mark, but other additions leave SQL Server shops wanting more ...

SQL Server 2008 SP3 Express, a free edition of Microsoft's database management system, can be downloaded here. Microsoft also released a Feature Pack for SQL Server 2008 SP3.

SQL Server 2008 has some great new features. One of them is the new auditing capability. Now we can audit at the server, database and table level according to specifications provided by the DBA.

SQL Server 2008 and SQL Server 2008 R2 reach their end of support on July 9. Windows Server 2008 and Windows Server 2008 R2 will hit their deadline six months later, on Jan. 14, 2020. With these ...

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.

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer ...

An application that is based on Visual Studio for developing solutions for SSIS, SSAS, or SSRS is called Business Intelligence Development Studio, or BIDS. With SQL Server 2005, it was introduced. It ...