Browsed by
Tag: Patching

SharePoint/Office 2007 Service Pack 3 coming Q4 2011

SharePoint/Office 2007 Service Pack 3 coming Q4 2011

The Office Sustained Engineering Team has announced that Service Pack 3 (SP3) for Office 2007 & SharePoint 2007 will be coming some time during 2011 Q4.  This appears to be the last major update to the 2007 client & server stack as the team states:

“We are offering this release in preparation for the April 2012 end of mainstream support for the 2007 client and server products. The October 2011 release provides a 6-month window to test and deploy the release prior to exiting mainstream support.”

The Service Pack will be a roll-up of all prior 2007 Cumulative and Public updates since Service Pack 2 plus some new hotfixes.  As always with the SharePoint 2007 world, you will need to install the WSS update before the MOSS update.  There is not a planned or expected CU requirement following the SP3 installation. 

To quote the article directly:

“SP3 will include changes in the following areas:

Office Client 2007 Suites
Office SharePoint 2007 Servers
Office SharePoint Search Server 2007
Office SharePoint Designer 2007
Office Project 2007
Office Visio 2007
Office Proofing tools 2007
Calendar Printing Assistant for Outlook 2007
Office InterConnect 2007
Office Compatibility Pack
PowerPoint Viewer
Visio Viewer
Office Servers Language Pack
Windows SharePoint Services 3.0
Office Access Runtime and Data Connectivity Components”

Soapbox time!!!!

upgrades

As always, please plan to test your upgrade plan in your Development/Test/QA environment prior to ever consider installing in Production. 

Keep in mind that if you only have a Production environment, you really only have a testing environment.  Now is a good time to start updating your resume if you haven’t and you are even thinking about heading down an upgrade path. 

Consider spending as little as $50 a month with a company like CloudShare to get a testing environment.  They have a great pre-production hosting option that will allow you to validate your scenarios without having to invest a ton of capital to do it.

NOTE: Best Practices for installing SharePoint 2010 Service Packs and updates changed as of August 31, 2011 according to the Update for SharePoint 2010 Products page

“As a result of the new packaging, it is no longer necessary to install the SharePoint Foundation cumulative update and then install the SharePoint Server cumulative update.”

Keep an eye on this, the story has now changed and then changed back since RTM.

Office Web Apps Service Pack 1 is here!

Office Web Apps Service Pack 1 is here!

It has almost gone overlooked, but Office 2010 and SharePoint 2010 are not the only products to get a Service Pack 1 release today.  I know that the Office Web Apps are a bolt on to SharePoint 2010 and so they don’t get a whole lot of attention, but from an end user feature enhancement perspective, I am almost more excited about the Office Web Apps SP1 than anything else released today (Office 365 not withstanding).

Sourced directly from Microsoft’s KB2460073:

Overview of Office Web Apps SP1 improvements

These are the key areas of improvement in SP1.

All Office Web Apps

  • OpenDocument Format (ODF) support:
    Lets you view and edit ODF documents in Office Web Apps.
  • Lets you use Office Web Apps with the Google Chrome browser.
  • Outlook Web App document attachment viewing (for Exchange Online only):
    Lets you view Office document attachments in the browser directly from Outlook Web App.
  • Lets you use Office Web Apps with Internet Explorer 9 in Native mode.

Word Web App

Lets you print Word documents from Edit mode (in addition to View mode).

Excel Web App

  • Added a Close button.
  • Lets you insert charts in Excel Web App.
  • Lets you copy and paste values and formulas by dragging the fill handle.

PowerPoint Web App

  • Lets you print presentations from PowerPoint Web App.
  • Lets you edit text in more shapes, not just placeholder shapes.
  • Lets you insert clip art in PowerPoint Web App. (By default clip art support is disabled. An administrator can decide to enable it.)

 It is important to keep in mind that Microsoft has already released the June 2011 Cumulative Updates that contain security patches important enough to be released simultaneously with these Service Packs, so be sure to install that as well.

Also, Microsoft has already released a list of known issues when installing Service Pack 1.  The Office Web Apps specific item,sourced directly from Microsoft’s KB2532126, is:

  • If Office Web Apps will be used in a mixed version environment, where Office Web Apps has SP1-or-later applied while SharePoint Server 2010 remains on the RTM version, you must install the following two updates before you install SP1 for Office Web Apps:
    • 2510639 Description of the SharePoint Server 2010 update: April 12, 2011

    • 2510648 Description of the Office Web Apps update: April 12, 2011

Here are the download links:

Service Pack 1 for Microsoft Office Web Apps 2010 (KB2460073)
http://www.microsoft.com/download/en/details.aspx?id=26639

Downloadable list of issues that the service pack fixes
http://download.microsoft.com/download/B/0/D/B0D1540B-6CF6-4674-9C8E-7A45FD91C163/Microsoft%20SharePoint%202010%20and%20Office%20servers%20Service%20Pack%201%20Changes.xlsx

SharePoint Foundation 2010 June 2011 CU (UPDATED)
http://support.microsoft.com/hotfix/KBHotfix.aspx?kbln=en-us&kbnum=2536601

SharePoint 2010 Service Pack 1 is here!

SharePoint 2010 Service Pack 1 is here!

Today Microsoft released Service Pack 1 for SharePoint 2010 which is a rollup of all previous Cumulative Updates through April 2011, which means that deploying directly on top of RTM bits supported, as well as number of stability, performance, and security enhancements based upon customer feedback.  There is a detailed white paper that about the Service Pack that can be found at this location.​

CAVEAT: Microsoft strongly recommends installing the June 2011 Cumulative Update immediately after the installation of Service Pack 1. The June Cumulative Update includes several important security and bug fixes that are not included SP1.

Here is the list of of the new features in SP1:

· Support for SQL Server Code Name “Denali”

anyone who has read any of my tweets or articles has probably noticed that I am a fan of Denali, so this is a huge feature for me

· Shallow copy functionality

this new feature allows sites with externalized blobs to be moved from one contentdb to another without having to reinternalize the blobs using the Move-SPSite powershell cmdlet. 

The white paper states​:

Prerequisite
In order to use shallow copy, you must have installed the Microsoft® SQL Server® 2008 R2 Remote Blob Store. The Remote Blob Store is included in the Microsoft® SQL Server® 2008 R2 SP1 Community Technology Preview Feature Pack (http://go.microsoft.com/fwlink/LinkId=221775).

There are a couple of things that jump out at me here that are concerning:

  1. The link doesn’t work
  2. SP1 supports functionality that is only available in SP1 CTP?  RBS is supported in SQL 2008 R2, does it work with that? (I fully intend to test this and post back, but it is a concern that I felt was worthy of raising)

I’m not getting all nervous about this just yet since this all just released today.  It will be interesting to see what comes of this over the next couple of days/weeks, but it is a VERY exciting feature if it works as advertised.

· Site recycle bin

Great feature to allow self recovery of Site Collections and Sites without having to revert to backups or third party tools.

· Improvements to storage management (StorMan.aspx)

Storage Space Allocation is huge when dealing with quota enforced sites.  This page, which was available in versions prior to 2010, allows end users to view their large files and determine what fat to trim to keep within their quotas.

· Cascading filters for Performance Point services

Quoted from the white paper: “New cascading filter support enables you to pass the value of one filter to another.”

· Additional browser support

Better support for Chrome

One more piece of really useful information to come out of the white paper:

Updated Windows PowerShell Commandlets

· NEW: Get-SPDeletedSite (SharePoint Server 2010)

· NEW: Remove-SPDeletedSite (SharePoint Server 2010)

· NEW: Restore-SPDeletedSite (SharePoint Server 2010)

· Move-SPSite (RBSProviderMapping parameter added) (SharePoint Server 2010)

Here are the download links:

Service Pack 1 for SharePoint Foundation 2010 (KB2460058)
http://www.microsoft.com/download/en/details.aspx?id=26640

Service Pack 1 for Microsoft SharePoint Server 2010 (KB2460045)
http://www.microsoft.com/download/en/details.aspx?id=26623

Downloadable list of issues that the service pack fixes
http://download.microsoft.com/download/B/0/D/B0D1540B-6CF6-4674-9C8E-7A45FD91C163/Microsoft%20SharePoint%202010%20and%20Office%20servers%20Service%20Pack%201%20Changes.xlsx

SharePoint Foundation 2010 June 2011 CU (UPDATED)
http://support.microsoft.com/hotfix/KBHotfix.aspx?kbln=en-us&kbnum=2536601

SharePoint Server 2010 June 2011 CU (UPDATED)
http://support.microsoft.com/hotfix/KBHotfix.aspx?kbln=en-us&kbnum=2536599

SharePoint 2010 & SQL 2008 R2 build numbers and helpful patching links

SharePoint 2010 & SQL 2008 R2 build numbers and helpful patching links

In an effort to make life simpler I have compiled a short list of useful link to build numbers and patching sites for SharePoint 2010 and SQL 2008 R2.

The Microsoft SharePoint Updates PagesSharePoint 2010 – http://technet.microsoft.com/en-us/sharepoint/ff800847.aspx
SharePoint 2007- http://technet.microsoft.com/en-us/office/sharepointserver/bb735839.aspx
This is your official sites for downloading the SharePoint updates from Microsoft.  Highly useful rather than waiting on the blogger community to send you a link, or get the TechNet bulletin, your carrier pigeon to arrive, or any of the other 120+ ways to get your SharePoint update information!

Cornelius J. van Dyk’s Blog on Versions for SharePoint
http://www.cjvandyk.com/blog/Lists/Versions/
Highly useful link if you find yourself a CU or two behind and you want to know what version of the CU is currently applied to your farm.  Simply visit your Central Admin Manage Patch Status page http://localhost:####/_admin/PatchStatus.aspx to check what version number your farm is on.

SQL 2008 R2 build numbers
http://support.microsoft.com/kb/981356/
This has proven to be the most reliable site I have found for listing the latest build numbers for SQL Server since 2008 R2 dropped.  To find out what what build you are running do the following:

  1. Open SQL Management Studio
  2. New Query
  3. type and then execute the following command
    select @@version 

    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode, .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode pre
    {font-size:small;color:black;font-family:consolas, “courier new”, courier, monospace;background-color:#ffffff;}
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode pre
    {margin:0em;}
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode .rem
    {color:#008000;}
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode .kwrd
    {color:#0000ff;}
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode .str
    {color:#006080;}
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode .op
    {color:#0000c0;}
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode .preproc
    {color:#cc6633;}
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode .asp
    {background-color:#ffff00;}
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode .html
    {color:#800000;}
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode .attr
    {color:#ff0000;}
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode .alt
    {background-color:#f4f4f4;width:100%;margin:0em;}
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode .lnum
    {color:#606060;}

We are working on getting a SQL Server version’s page up on CvD’s blog as well, but for now I here is a table with the info:

April 2010 RTM
10.50.1600.1
May 2010 CU1
10.50.1702.0
June 2010 CU2
10.50.1720.0
August 2010 CU3
10.50.1734.0
October 2010 CU4
10.50.1746.0
December 2010 CU5
10.50.1753.0