SQL Server 2008, aka “Katmai,” gives SQL Server shops plenty of reasons to get excited. The best SQL Server release to date, it sports more nice new features than you can count, and the improvements ...

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. We ...

It's not 2008 anymore. Joey details the ins and outs of upgrading these aging Microsoft servers, including licensing changes, support options and potential pitfalls. It was a simpler time. A decade ...

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, 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.

SQL Server, Microsoft's flagship operational database, has been around for over a quarter century now. That has meant successive waves of innovation for the platform, but has also made for ...

New BI and reporting features in SQL Server 2008 R2 hit the mark, but other additions leave SQL Server shops wanting more With Microsoft SQL Server 2008 R2, Microsoft begins to fully realize its ...

Microsoft is offering users on Windows Server 2008 and 2008 R2 and SQL Server 2008 and 2008 R2 a way to keep getting security updates for free after the official support period ends. Read also: Here's ...

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 need ...