Tag Archives: SP3

How to find the version, edition, Service Pack and Cumulative Update Version of Microsoft SQL Server and its associated components

If you want to find out the version and edition of Microsoft SQL Server then please take a look at Microsoft KB 321185 http://support.microsoft.com/kb/321185

This will show you how to find versions for SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012

SQL Server 2005

Microsoft SQL Server 2005 Cumulative Updates that have been released after SQL Server 2005 – Service Pack 2 http://support.microsoft.com/kb/937137

Microsoft SQL Server 2005 Cumulative Updates that have been released after SQL Server 2005 – Service Pack 3 http://support.microsoft.com/kb/960598

Microsoft SQL Server 2005 Cumulative Updates that have been released after SQL Server 2005 – Service Pack 4 http://support.microsoft.com/kb/2485757

SQL Server 2008

Microsoft SQL Server 2008 Cumulative Updates that have been released since SQL Server 2008 – RTM http://support.microsoft.com/kb/956909

Microsoft SQL Server 2008 Cumulative Updates that have been released after SQL Server 2008 – Service Pack 1 http://support.microsoft.com/kb/970365

Microsoft SQL Server 2008 Cumulative Updates that have been released after SQL Server 2008 – Service Pack 2 http://support.microsoft.com/kb/2402659

Microsoft SQL Server 2008 Cumulative Updates that have been released after SQL Server 2008 – Service Pack 3 http://support.microsoft.com/kb/2629969

SQL Server 2008 R2

Microsoft SQL Server 2008 R2 Cumulative Updates that have been released since SQL Server 2008 R2 – RTM http://support.microsoft.com/kb/981356

Microsoft SQL Server 2008 R2 Cumulative Updates that have been released after SQL Server 2008 R2 – Service Pack 1 http://support.microsoft.com/kb/2567616

Microsoft SQL Server 2008 R2 Cumulative Updates that have been released after SQL Server 2008 R2 – Service Pack 2 http://support.microsoft.com/kb/2730301

SQL Server 2012

Microsoft SQL Server 2012 Cumulative Updates that have been released since SQL Server 2012 – RTM http://support.microsoft.com/kb/2692828

Microsoft SQL Server 2012 Cumulative Updates that have been released since SQL Server 2012 – Service Pack 1

http://support.microsoft.com/kb/2772858

Microsoft Windows based Computers and Laptops – Slow System Startup with Realtek HD Audio Chipset

You may find that Windows based computers and laptops are very slow to startup and in some instances slow to shutdown.  This has been witnessed when out dated drivers are installed for the integrted Realtek HD Audio Chipset.

The Realtek HD Audio drivers offered on Microsoft Update are often dated 2005 and are many years behind those available directly from the Audio Chipset manufacturer.

You can verify your current Audio Chipset and Driver version from “Device Manager”

Please visit http://www.realtek.com/downloads/ to find and download the latest applicable drivers for your Windows system.  They will usually reference the drivers as “High Definition Audio Codecs (Software)” and then under Windows the list Operating System Compatability for each system and provide several download links based upon locations around the world.  Downloads from the Realtek site can be slow at busy times of the day so you may need to be patient and/or download outside peak hours.

As you can see from the table the current drivers from Realtek Support are dated 21st October 2011 and are usually updated every 1-2 months, it would be worth updating to the latest release to resolve your slow startup times and then add updating your audio drivers into your usual computer maintenance schedule.  Once you have updated remember to check Device Manager to ensure that the latest drivers are actually installed and that the device is operating correctly.