Roger Haueter

Modern Workplace Strategist | Microsoft Most Valuable Professional

SQL database maintenance plan for SharePoint

To keep SharePoint running with optimal performance, it's recommended to run the following maintenance tasks for your SharePoint databases:

  • Check database integrity
  • Defragment indexes by reorganizing or rebuilding them
  • Set the fill factor for a server

Those tasks may performed by Transact-SQL commands or using the Database Maintenance Wizard.

Check database integrity
DBCC CHECKDB checks the integrity of all objects in a database. It's recommend to run DBCC CHECKDB instead of DBCC CHECKALLOC, DBCC CHECKTABLE and DBCC CHECKCATALOG commands. DBCC CHECKDB identifies the widest range of possible errors and is therefore safer to run in a production environment. Because of heavy load it's not recommended to run this check during production hours.
Read more


SharePointDsc Version 2.0 has arrvied

Right on time for Christmas the major release of SharePointDsc Version 2.0 has arrived. This release contains many improvements and fixes. Please refer to https://github.com/PowerShell/SharePointDsc/blob/dev/CHANGELOG.md for the full change log.

The following changes will break 1.x configurations that use these resources:Read more


Lifecycle Policy update regarding the end of SharePoint 2013 mainstream support

The general Microsoft mainstream support for SharePoint 2013 will end by April 10, 2018. But don't panic! Your SharePoint farm will still be working. It actually keeps receiving security updates. Read more


SharePoint 2016 Cumulative Updates: December 2017

The December 2017 Cumulative Updates contain fixes and improvements for SharePoint Server 2016 and Office Online Server 2016.

Installation instructions

  • Create a SharePoint Farm Backup.
  • Download all SharePoint Server packages.
  • Extract the previously downloaded files with a double-click.
  • Click "Continue"
  • Define the path in which you would like to extract the installation binaries and click OK. Use the same destination path for the other files.
  • Run the extracted EXE file as administrator.
  • Accept the license terms and click "Continue".
  • Repeat the previous two steps for the other EXE files in this folder.
  • Apply the updates to each SharePoint server in the farm.
  • As soon as the installation of the cumulative update has finished on all servers, run the SharePoint Configuration Wizard successively on each SharePoint server in the farm.

Update KB4011576 for SharePoint Server 2016: December 12, 2017
This fix contains updates for language-independend files. It also updates the configuration database schema and the SharePoint build number.
Download
Description of the SharePoint Server 2016 update package
Read more


SharePoint 2013 Cumulative Updates: December 2017

The December 2017 Cumulative Updates contain numerous hotfixes and improvements for SharePoint Foundation 2013, SharePoint Server 2013, Project Server 2013 and Office Web Apps Server 2013. The cumulative update package is multilingual and contains updates for all languages.

Before you start
Since June 2014 the Cumulative Updates for SharePoint products releases on a monthly basis.
Since May 2015 the server proofing tools are included in the cumulative updates.
This cumulative update includes all patches since the Service Pack 1 release, but not the Service Pack 1 itself. You must install the Service Pack 1 before installing this cumulative update. Read how-to install Service Pack 1.
Because of the file size the cumulative update package has been divided in three parts; ubersrv.exe, ubersrv_1.cab and ubersrv_2.cab. You have to put them all in the same folder.

Installation instructions

  • Create a SharePoint Farm Backup.
  • Download all SharePoint Foundation and SharePoint Server packages.
  • Extract the previously downloaded files with a double-click.
  • Click "Continue"
  • Define the path in which you would like to extract the installation binaries and click OK. Use the same destination path for the other files.
  • Run the extracted EXE file as administrator.
  • Accept the license terms and click "Continue".
  • Repeat the previous two steps for the other EXE files in this folder.
  • Apply the updates to each SharePoint server in the farm.
  • As soon as the installation of the cumulative update has finished on all servers, run the SharePoint Configuration Wizard successively on each SharePoint server in the farm. This step is required if your farm level is lower than July 2015 CU.
  • Restart the User Profile Service on affected servers.

Hotfix KB4011588 for SharePoint Foundation 2013: December 12, 2017
Download
Description of the SharePoint Foundation 2013 update package
Read more