Browse by Tags

All Tags » Service Pack (RSS)
16 April 2009 07:33

Cumulative update package 1 for SQL Server 2008 Service Pack 1 now available

Cumulative update package 1 for SQL Server 2008 Service Pack 1 KB Article Cumulative Update 1 for SQL Server 2008 Service Pack 1 (SP1) contains only hotfixes that were released in Cumulative Update 4 for SQL Server 2008. These hotfixes are not included...
Posted by sqldbatips | with no comments
Filed under: ,
08 April 2009 16:19

SQL 2008 Service Pack 1 RTM now available

Service Pack 1 for SQL Sevrer 2008 is now available (download link below). Two of the key features in this are the ability to slipstream the service pack with the RTM media to provide a prepatched install (which I tested during the CTP and seems to work...
Posted by sqldbatips | 1 comment(s)
Filed under: ,
29 October 2008 12:43

SQL 2005 Service Pack 3 Beta now available

SQL 2005 Service Pack 3 Beta is now available for testing. Remember this is a beta for testing purposes only, do not deploy to production servers Download SQL 2005 SP3 Beta View what's new in SP3
Posted by sqldbatips | with no comments
Filed under: ,
11 August 2008 21:05

Visual Studio 2008 Service Pack 1 RTM download now available

As mentioned in a previous post , parts of SQL 2008 require you to have Visual Studio 2008 SP1 RTM installed if you had previously installed Visual Studio 2008 prior to installing SQL 2008. Today, Visual Studio 2008 Service Pack 1 RTM is available for...
Posted by sqldbatips | with no comments
Filed under: , ,
10 July 2008 15:51

Important Security Update for SQL Server MS08-040

Microsoft have released a set of security updates for SQL 7, 2000 and 2005 to resolve four privately disclosed vulnerabilities. For details of the affected systems and vulnerabilities see Microsoft Security Bulletin MS08-040 . Note that if you have already...
Posted by sqldbatips | with no comments
Filed under: ,
12 December 2007 18:34

Processadmin server role broken by SQL2005 Cumulative Update 3

After you apply SQL 2005 Cumulative Update 3 (3186), members of the processadmin fixed server role can no longer kill spids (which since that is all that role allows you to do effectively makes it useless). This is supposedly fixed in Cumulative Update...
Posted by sqldbatips | with no comments
Filed under: ,
11 April 2007 23:50

SQL 2005 SP2 Re-release and post fixes explained

If you're as confused about what's going on with SQL 2005 SP2 and the various post SP2 hotfixes as I am, Bob Ward from PSS has a very detailed explanation of the various permutations here . Hopefully this will help clear up much of the confusion!
Posted by sqldbatips | with no comments
Filed under:
13 March 2007 23:35

Windows 2003 Service Pack 2 released

Windows Server SP2 has been released. The download page is here . There is a performance improvement for SQL Server 2005 around the winsock API but it's most noticeable in higher end (>8CPU + multi NIC) hardware running workloads that show a high kernel...
Posted by sqldbatips | 1 comment(s)
Filed under: ,
08 March 2007 07:23

SQL 2005 Performance Dashboard Custom SSMS Reports available

As I've previously blogged about, SQL 2005 SP2 allows users to write custom reports that are hosted in SSMS and are available via the Reports context menu in Object Explorer. Microsoft have now released a group of reports that can be used to troubleshoot...
Posted by sqldbatips | 1 comment(s)
Filed under: , ,
07 March 2007 15:02

Another SP2 Maintenance Plan bug - Database Integrity Checks

** Update: A hotfix is now available to address this issue here for SQL versions 3042 through 3053** ** Update: A hotfix is now available to address this issue here for SQL versions 3150 through 3158** Tony has picked up on another issue with SP2 in regard...
Posted by sqldbatips | with no comments
Filed under: , ,
More Posts Next page »