Browse by Tags

• authentication
• bol
• books online
• builds
• clustering
• connect
• consistency
• cumulative updates
• CUs
• DDL
• DMVs
• Documentation
• Downloads
• habits
• hofixes
• hotfixes
• knowledge base
• Microsoft Update
• New Features
• patching
• product enhancements
• saving face
• service pack 3
• SP3
• SQL Server 2005
• SQL Server 2005 builds
• SQL Server 2005 SP3
• SQL Server 2005 updates
• SSMS

• Bad habits to kick : using ancient copies of Books Online

  In my last post in this series , I talked about inconsistent table aliasing. Today I was reminded of another behavior that DBAs and developers alike can be lazy about: keeping Books Online current. There are always going to be mistakes in any set of documentation,...( Read More... Posted Tuesday, February 23, 2010 3:42 AM from Aaron Bertrand | (Comments Off) Filed under: bol, books online, service packs, habits

• Connect digest : 2009-12-31

  Like Hugo's immensely popular item pushing for SQL Server 2005 Service Pack 3 , Steve Jones has created suggestions prompting new service packs for both 2005 and 2008: #522122 : Service Pack 4 for SQL Server 2005 #522123 : SQL Server 2008 Service Pack...( Read More... Posted Thursday, December 31, 2009 11:43 PM from Aaron Bertrand | (Comments Off) Filed under: connect, DMVs, service packs, DDL, consistency

• Installing Service Packs / Cumulative Updates on a SQL 2005 cluster

  In our environment, we run the task scheduler as a cluster resource, so that scheduled tasks always run on the active node. (In ancient history, we would have scheduled tasks that weren't cluster aware - in the event of a failover, we'd have to manually...( Read More... Posted Friday, November 20, 2009 9:56 PM from Aaron Bertrand | (Comments Off) Filed under: clustering, SQL Server 2005, cumulative updates, service packs, hotfixes, patching

• How to really detect the version of SSMS you are running

  Earlier this week, a hotfix was released that, among other thigns, addressed an issue where, if you restored a 2000 database from 2005 SSMS, it did not go well. The KB article ( KB #972687 ) says that only certain versions of SSMS are affected, and proceeds...( Read More... Posted Saturday, August 22, 2009 5:08 AM from Aaron Bertrand | (Comments Off) Filed under: SSMS, connect, service packs, CUs

• Whither art thou, oh Microsoft support?

  Back in June, I told you about a post-SP3 CU that was released for SQL Server 2005: Cumulative Update #4 (9.00.4226). This was exciting news, because it was the first build to introduce locked pages in memory support for the masses (e.g. those running...( Read More... Posted Friday, August 07, 2009 11:28 AM from Aaron Bertrand | (Comments Off) Filed under: Downloads, service packs, hotfixes, saving face, knowledge base

• Connect Digest : 2009-05-16 : please vote!

  Here are the items from this week that I feel deserve some attention. ==================== Hotfixes / service packs should leave authentication mode alone I may have talked about this issue here before, I'm not sure, but I thought I was the only one who Read More... Posted Sunday, May 17, 2009 1:33 AM from Aaron Bertrand | (Comments Off) Filed under: Documentation, connect, authentication, New Features, books online, service packs, product enhancements, hofixes

• SQL Server 2005 SP3 through Microsoft Update now supports clusters

  What this says to me is, if any of your clusters have automatic updating turned on, you might get SP3 as a surprise. Since the blog post states that it must be run in attended / UI mode, maybe that is not quite true (it will probably download but not Read More... Posted Thursday, March 26, 2009 2:17 AM from Aaron Bertrand | (Comments Off) Filed under: clustering, SQL Server 2005, service packs, SP3, Microsoft Update

• More information on SQL Server 2005 SP3 + Cumulative Updates

  I recently posted about the availability of SQL Server 2005 SP3 . I have a bit more information about cumulative updates and the service pack, for those of you who might be confused about the whole mess involving CU#10, CU#11, post-SP3 CU#1, and are wondering Read More... Posted Thursday, December 18, 2008 3:31 AM from Aaron Bertrand | (Comments Off) Filed under: cumulative updates, service pack 3, builds, service packs, SQL Server 2005 updates, SQL Server 2005 SP3, SP3

• More info on SQL Server 2005 SP3 + Cumulative Updates

  I recently posted about the availability of SQL Server 2005 SP3 . I have a bit more information about cumulative updates and the service pack, for those of you who might be confused about the whole mess involving CU#10, CU#11, post-SP3 CU#1, and are wondering Read More... Posted Thursday, December 18, 2008 3:31 AM from Aaron Bertrand | (Comments Off) Filed under: cumulative updates, service pack 3, builds, service packs, SQL Server 2005 updates, SQL Server 2005 SP3, SP3

• SQL Server 2005 SP3 is available!

  At long last, SP3 is here. I will save my comments for later but wanted to get the news out right away! http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4 For those that keep track, the build number is 9.00.4035. Read More... Posted Tuesday, December 16, 2008 10:45 AM from Aaron Bertrand | (Comments Off) Filed under: SQL Server 2005 builds, service pack 3, service packs, SQL Server 2005 updates

• SQL Server 2005 SP3 Beta is available!

  Okay, it happened a couple of days ago; sorry for not noticing. But SQL Server Release Services / Sustained Engineering has announced that an SP3 Beta has been made available . The build is 9.00.4028 and you can download it here: http://www.microsoft.com/downloads/details.aspx?FamilyId=D22317E1-BC64-4936-A14B-7A632B50A4CA Read More... Posted Friday, October 31, 2008 2:03 PM from Aaron Bertrand | (Comments Off) Filed under: cumulative updates, service pack 3, builds, service packs