Friday 16 October 2015

Microsoft conferences 2015-2016

Here is the current 2016 event schedule, as provided by Chris Capossela, Executive Vice President and Chief Marketing Officer:
 
Build Spring 2016 in San Francisco
Convergence April 4-7, 2016 in New Orleans
WPC July 10-14, 2016 in Toronto
Microsoft Ignite September 26-30, 2016 in Atlanta
Convergence EMEA Barcelona, November 30 – December 2.
Microsoft Cloud Roadshows -
Looking forward to seeing you all in Barelona!!

Friday 9 October 2015

The project manager’s guide to planning a perfect project

Being a project manager is a tough job. There are constant demands on your time, people to keep on track, pressure to do a certain amount of work in what often seems like an impossibly short amount of time and much more.

But it’s also a necessary role that can bring extraordinary value to your company. In fact, according to a study by PricewaterhouseCoopers, more than 60 percent of project failures are linked to internal issues such as insufficient resources or missed deadlines—i.e., situations a project manager can help avoid. In addition, it’s a growing industry, as more and more companies realize the importance of solid project management.

Project-Manager-FI

Read More >>>>>

Friday 2 October 2015

Unlocking the Mystery of Patching SharePoint & Project Server

Real-world, best practice approach for patching SharePoint and Project Server 2010/2013.

Applies: SharePoint and Project Server 2010/2013. The post below assumes that the reader has administrative knowledge of maintaining a SharePoint farm.  Also observe the planning notes below.

Planning 

As always, before embarking on SharePoint/Project Server update on your production system, answer these two questions;

A) Is the update necessary? Is it solving an existing problem?

Do not simply rush into applying the latest updates just because it has been released!!

That said, do ensure that you are not too far behind on patching your environment, that you have an unsupported system. Remember that patching is not just about SharePoint and Project. You need to ensure that SQL Server (and related components) are also at a supported patch level.

B) Have you successfully tested the patch/update on development/test environment with a copy of live data prior to applying on the production system?

By testing, I do not just mean the successful patching of the servers, but ALSO ensure that the key business processes and solutions are tested thoroughly.

Here are some guidance notes – The Mystery behind patching;

Step (1) – Existing System Validation 

Run SharePoint Configuration Wizard (SCW) to validate existing farm configuration to validate the the existing state of the farm. If issues are encountered you need to resolve them first.

You need only run this on one of the Web/App servers, preferably the one hosting SharePoint Central Administration (CA).

Ensure all the core services are running after the validation.

Step (2) – Preparation 

On each of the web server(s) running SharePoint Server 2013, starting with the one hosting SharePoint Central Administration portal, stop the following Windows Services in this order:

  1. World Wide Publishing Service
  2. SharePoint Time Service
  3. SharePoint Server Search
  4. SharePoint Administration
  5. SharePoint Tracing Service
  6. SharePoint Search Host Controller*
  7. AppFabric Caching Service*

If Project Server is installed;

  1. Microsoft Project Server Calculation Service*
  2. Microsoft Project Server Event Service
  3. Microsoft Project Server Queue Service

Note: The reason why you need to stop the SPTimerV4 service first is because the SPTimerV4 service monitors the SPSearchHostController service. The SPTimerV4 service will start the SPSearchHostController service it if it finds that the SPSearchHostController is stopped. Therefore, if the SPTimerV4 service is running after you stop the SPSearchHostController service, the SPTimerV4 service might start the SPSearchHostController without you noticing it.

*Note: SP/PS2013 Services.

You may also be required to stop the following services during the patch installation.

image

In a multi Web/App server environment, this needs to be done on all the servers starting with the one hosting the CA.

Step (3a) – Update 

Install the update package on the server by following the instructions that come with the update package. In this step the package is extracted and updated files/components are installed.

Note: In a multi Web/App server environment, this needs to be installed on all the servers starting with the one hosting the CA. DO NOT run SharePoint configuration Wizard (Steps 4 & 5) until all servers are updated. Example on-premise environment with 6 web/apps servers is shown in fig below. 

image

You may be required to reboot the server, but do this only after this update has been applied on ALL the Web/App Servers in the farm, staring with the one hosting the CA portal.

Step (3b) – Update 

Restart the Windows Services in the following order:

  1. World Wide Publishing Service
  2. SharePoint Server Search
  3. SharePoint Time Service
  4. SharePoint Administration
  5. SharePoint Tracing Service  
  6. SharePoint Search Host Controller*
  7. AppFabric Caching Service*

If Project Server is installed;

  1. Microsoft Project Server Calculation Service*
  2. Microsoft Project Server Event Service
  3. Microsoft Project Server Queue Service

Note: In a multi Web/App server environment, this needs to be done on all server, ONLY after all the servers are updated (Step 3).

Step (4a)- Upgrade

Finally, Run SharePoint Configuration Wizard (SCW) to upgrade the system incl database schema.

I would recommend that you use the farm administrator account to install the update and run the SharePoint Products Configuration Wizard. If you use a different account, that account may not have the appropriate rights and permissions.

Note: You may need to run this a SECOND time to ensure successful completion.

In a multi Web/App server environment, this needs to be run on all the servers starting with the one hosting the CA.

If you encounter a failure when running SCW, you can try to force the upgrade using the following approach in Step (4b).

Step (4b)- Force Upgrade using b2b command

If for any reason, your upgrade fails, you can try forcing the upgrade using the following method.

Note: first review logs and assess the reasons for any failure. It may be some data or feature related issue. As always, approach the following with due care and attention and test thoroughly, prior to applying on live production system.

  1. Stop SharePoint Admin and Timer service
  2. Navigate to Drive:\ProgramData\Microsoft\SharePoint\Config\GUID and delete all the XML files from the directory. DONOT delete the cache.ini
  3. On Command prompt navigate to c:\program files\common files\microsoft shared\web server extensions\14\bin and run: stsadm -o execadmsvcjobs
  4. Open the cache.ini with Notepad and reset the number to 1. Save and close the file.
  5. Now start the SharePoint Admin and timer service and
  6. Finally, Run the following command using the CMD prompt (run as Admin) from 12\bin directory “psconfig -cmd upgrade –inplace b2b -wait –force”

Note: Sometimes you need to run the following SharePoint PS command if you have some data/feature issues; psconfig -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures

image

Note: it very important that while the above command is being run, the SharePoint Admin and timer service is running i.e. STARTED. I did encounter a couple of instances where these had stopped. You need to ensure these are running while the above command is run.

After you have a successful outcome as in figure above, I would recommend that you run the SharePoint Configuration Wizard again to verify all is ok.

Step (5)- Post Update Checks

After all that hard work, ensure that all is working as expected. Check the following in SharePoint Central Admin Portal;

a) Verify Version (via CA > System Settings > Servers in the Farm)

image

b) Database Upgrade Status (via CA > Upgrade and Migration > Check Upgrade status and Review Database Status)

image

c) Verify User Profile Service Application

Note: if this service is not running verify if the FIM Windows Services is running.

image

d) AD Connection (ensure you have used Admin rights and using the credential for USP Admin to review this)

If you have an issue with one the Service Application Database then you will need to run a command

(Get-SPDatabase | ?{$_.type -eq"Microsoft.SharePoint.BusinessData.SharedService.BdcServiceDatabase"}).Provision()

image

Verify if all the key Application pools and Websites are running on IIS

It is also advisable to verify the status of the SQL DB if all are online and verify the key content DB Versions.

That’s all folks!!

If need have any queries or need any assistance, you can reach out to me.

Unlocking the Mystery of Patching SharePoint & Project Server

Real-world, best practice approach for patching SharePoint and Project Server 2010/2013.

Applies: SharePoint and Project Server 2010/2013. The post below assumes that the reader has administrative knowledge of maintaining a SharePoint farm.  Also observe the planning notes below.

Planning 

As always, before embarking on SharePoint/Project Server update on your production system, answer these two questions;

A) Is the update necessary? Is it solving an existing problem?

Do not simply rush into applying the latest updates just because it has been released!!

That said, do ensure that you are not too far behind on patching your environment, that you have an unsupported system. Remember that patching is not just about SharePoint and Project. You need to ensure that SQL Server (and related components) are also at a supported patch level.

B) Have you successfully tested the patch/update on development/test environment with a copy of live data prior to applying on the production system?

By testing, I do not just mean the successful patching of the servers, but ALSO ensure that the key business processes and solutions are tested thoroughly.

Here are some guidance notes – The Mystery behind patching;

Step (1) – Existing System Validation 

Run SharePoint Configuration Wizard (SCW) to validate existing farm configuration to validate the the existing state of the farm. If issues are encountered you need to resolve them first.

You need only run this on one of the Web/App servers, preferably the one hosting SharePoint Central Administration (CA).

Ensure all the core services are running after the validation.

Step (2) – Preparation 

On each of the web server(s) running SharePoint Server 2013, starting with the one hosting SharePoint Central Administration portal, stop the following Windows Services in this order:

  1. World Wide Publishing Service
  2. SharePoint Time Service
  3. SharePoint Server Search
  4. SharePoint Administration
  5. SharePoint Tracing Service
  6. SharePoint Search Host Controller*
  7. AppFabric Caching Service*

If Project Server is installed;

  1. Microsoft Project Server Calculation Service*
  2. Microsoft Project Server Event Service
  3. Microsoft Project Server Queue Service

Note: The reason why you need to stop the SPTimerV4 service first is because the SPTimerV4 service monitors the SPSearchHostController service. The SPTimerV4 service will start the SPSearchHostController service it if it finds that the SPSearchHostController is stopped. Therefore, if the SPTimerV4 service is running after you stop the SPSearchHostController service, the SPTimerV4 service might start the SPSearchHostController without you noticing it.

*Note: SP/PS2013 Services.

You may also be required to stop the following services during the patch installation.

image

In a multi Web/App server environment, this needs to be done on all the servers starting with the one hosting the CA.

Step (3a) – Update 

Install the update package on the server by following the instructions that come with the update package. In this step the package is extracted and updated files/components are installed.

Note: In a multi Web/App server environment, this needs to be installed on all the servers starting with the one hosting the CA. DO NOT run SharePoint configuration Wizard (Steps 4 & 5) until all servers are updated. Example on-premise environment with 6 web/apps servers is shown in fig below. 

image

You may be required to reboot the server, but do this only after this update has been applied on ALL the Web/App Servers in the farm, staring with the one hosting the CA portal.

Step (3b) – Update 

Restart the Windows Services in the following order:

  1. World Wide Publishing Service
  2. SharePoint Server Search
  3. SharePoint Time Service
  4. SharePoint Administration
  5. SharePoint Tracing Service  
  6. SharePoint Search Host Controller*
  7. AppFabric Caching Service*

If Project Server is installed;

  1. Microsoft Project Server Calculation Service*
  2. Microsoft Project Server Event Service
  3. Microsoft Project Server Queue Service

Note: In a multi Web/App server environment, this needs to be done on all server, ONLY after all the servers are updated (Step 3).

Step (4a)- Upgrade

Finally, Run SharePoint Configuration Wizard (SCW) to upgrade the system incl database schema.

Note: You may need to run this a SECOND time to ensure successful completion.

In a multi Web/App server environment, this needs to be run on all the servers starting with the one hosting the CA.

If you encounter a failure when running SCW, you can try to force the upgrade using the following approach in Step (4b).

Step (4b)- Force Upgrade using b2b command

If for any reason, your upgrade fails, you can try forcing the upgrade using the following method.

Note: first review logs and assess the reasons for any failure. It may be some data or feature related issue. As always, approach the following with due care and attention and test thoroughly, prior to applying on live production system.

  1. Stop SharePoint Admin and Timer service
  2. Navigate to Drive:\ProgramData\Microsoft\SharePoint\Config\GUID and delete all the XML files from the directory. DONOT delete the cache.ini
  3. On Command prompt navigate to c:\program files\common files\microsoft shared\web server extensions\14\bin and run: stsadm -o execadmsvcjobs
  4. Open the cache.ini with Notepad and reset the number to 1. Save and close the file.
  5. Now start the SharePoint Admin and timer service and
  6. Finally, Run the following command using the CMD prompt (run as Admin) from 12\bin directory “psconfig -cmd upgrade –inplace b2b -wait –force”

Note: Sometimes you need to run the following SharePoint PS command if you have some data/feature issues; psconfig -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures

image

Note: it very important that while the above command is being run, the SharePoint Admin and timer service is running i.e. STARTED. I did encounter a couple of instances where these had stopped. You need to ensure these are running while the above command is run.

After you have a successful outcome as in figure above, I would recommend that you run the SharePoint Configuration Wizard again to verify all is ok.

Step (5)- Post Update Checks

After all that hard work, ensure that all is working as expected. Check the following in SharePoint Central Admin Portal;

a) Verify Version (via CA > System Settings > Servers in the Farm)

image

b) Database Upgrade Status (via CA > Upgrade and Migration > Check Upgrade status and Review Database Status)

image

c) Verify User Profile Service Application

Note: if this service is not running verify if the FIM Windows Services is running.

image

d) AD Connection (ensure you have used Admin rights and using the credential for USP Admin to review this)

If you have an issue with one the Service Application Database then you will need to run a command

(Get-SPDatabase | ?{$_.type -eq"Microsoft.SharePoint.BusinessData.SharedService.BdcServiceDatabase"}).Provision()

image

Verify if all the key Application pools and Websites are running on IIS

It is also advisable to verify the status of the SQL DB if all are online and verify the key content DB Versions.

That all folks!!

If need have any queries or need any assistance, you can reach out to me.