We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Operating systems software Reviews
15,603 Reviews

Microsoft SQL Server 2008 review

£48.88 inc VAT

Manufacturer: Microsoft

Our Rating: We rate this 4.5 out of 5

Microsoft 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 extend to both performance and manageability.

Microsoft 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 extend to both performance and manageability.

In a few cases, such as the Resource Governor, you'll wish Microsoft had taken the functionality a little further. But whether you manage an OLTP environment, or an OLAP environment, or both, you will most likely find Katmai compelling. SQL Server 2008 easily passes our own five-point test for upgrades.

Our five-point test requires a new release to bring at least five significant improvements to our data environment - a large data warehouse - or it's not worth upgrading. Each improvement has to change our life in a significant way, either by dramatically shortening the time to do common tasks or by allowing us to do something we couldn't do before.

These five Katmai features easily pass the test: Change Data Capture, Lookup Cache, Data Compression, PowerShell integration, and Policy-Based Management. And with Microsoft SQL Server 2008, we could easily keep counting.

Change Data Capture and Lookup Cache will be popular with DBAs who want to speed up ETL (Extract, Transformation, and Load) processes, as will the pipeline improvements in Integration Services, enabling Microsoft SQL Server 2008 to push data much faster.

NEXT PAGE: faster, sleeker

Visit Business Advisor for the latest business IT news, reviews, tips and tricks - plus sign up for our unique and FREE business IT newsletter

Microsoft SQL Server 2008 Expert Verdict »
Framework: SQL Server Setup installs the following software components required by the product: .NET Framework 3.5 SP11, SQL Server Native Client, SQL Server Setup support files. Software: SQL Server Setup requires Microsoft Windows Installer 4.5 or a later version. Network Software: Shared memory, Named Pipes, TCP/IP, VIA. Internet Software: Microsoft Internet Explorer 6 SP1. CD or DVD drive. SQL Server 2008 graphical tools require VGA or higher resolution: at least 1,024x768 pixel resolution
Microsoft mouse or compatible pointing device is required.
  • Overall: We give this item 9 of 10 overall

It's not without its faults, but Microsoft SQL Server 2008 easily passes our own five-point test for upgrades by bringing at least five significant improvements to a data environment. It's a winner.

There are currently no price comparisons for this product.
  • Visual Studio 2008 SP1 review

    Visual Studio 2008 SP1

    Microsoft Visual Studio 2008 (VS08) Service Pack 1 (SP1) took eight months to arrive. Considering the capabilities that have been added, eight months might not seem so long.

  • Genie Backup Manager Professional 7.0

    Genie Backup Manager Professional 7.0

    This is a solid product. With the addition of disaster recovery and a little more attention to visual detail, it would have achieved better scores.

  • Windows Server 2008 review

    Windows Server 2008

    Microsoft's long-awaited Windows Server 2008 delivers advancements in speed, security and management, but its virtualisation and network-access control features come up short.

  • FileMaker Pro 9.0

    FileMaker Pro 9.0

    Serious FileMaker developers, database and network admins, and managers who worry about tying different piles of company data together are going to be the big beneficiaries of major improvements in the latest update to the FileMaker family of products.

  • Microsoft SharePoint Server 2010 review

    Microsoft SharePoint Server 2010

    Microsoft SharePoint Server 2010 is a significant improvement over SharePoint 07, providing IT execs with multiple ways to streamline their infrastructure and cut costs.


IDG UK Sites

Windows 9 release date, price, features: 30 September marked for unveiling

IDG UK Sites

Gateway to your kingdom: why everybody should check and update their broadband router

IDG UK Sites

Netflix whips up 3D VR viewing room for Oculus Rift during company hack day

IDG UK Sites

Best Mac? Complete Apple Mac buyers guide for 2014