Browsed by
Tag: Versions

Updated PowerShell Profiles Creation Script

Updated PowerShell Profiles Creation Script



While enjoying Doug Hemminger’s presentation at the SharePoSH meeting tonight I realized that I hadn’t published an update to my How to: Automatically log your PowerShell session every time post, even though I had fixed some issues with the script more than 2 months ago. FYI, I still blame Todd Klindt for prompting me to write this thing in the first place by introducing me to start-transcript…

I updated the version of code in the previous post from v1.8 to v1.14 without posting about it, however the output formatting was poor.

The major changes from v1.8 to v1.15 are:

1.) Proper formatting of screen outputs
2.) Added PowerShell Active Directory modules
3.) Outputting a validated list of snap-ins & modules that are actually loaded instead of just printing on screen that the SharePoint module loaded even when it hadn’t
4.) Validation that the user is running in the context of an Administrator
5.) Removed unnecessary code & added proper commenting inline

You can find the updated code at on SkyDrive here.

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!!!!


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.

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 –
SharePoint 2007-
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
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
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
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode .rem
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode .kwrd
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode .str
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode .op
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode .preproc
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode .asp
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode .html
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode .attr
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode .alt
    .externalclassaf644619e5194a77b8e785ba7f262756 .csharpcode .lnum

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
May 2010 CU1
June 2010 CU2
August 2010 CU3
October 2010 CU4
December 2010 CU5