Month: November 2016

Configure User Profile Service Application in SharePoint 2016

$accountName = "CONTOSO\joeylicc"
$svcAppPoolName = "UserProfileServiceApplicationPool"
$svcAppName = "User Profile Service Application"
$profileDbName = "User_Profile"
$profileSyncDbName = "User_Profile_Sync"
$socialDbName = "User_Profile_Social"
$svcAppProxyName = "User Profile Service Application Proxy"

$account = Get-SPManagedAccount $accountName
$appPool = New-SPServiceApplicationPool -Name $svcAppPoolName -Account $account
$svcApp = New-SPProfileServiceApplication -Name $svcAppName -ProfileDBServer $dbServer -ProfileDBName $profileDbName -ProfileSyncDBServer $dbServer -ProfileSyncDBName $profileSyncDbName -SocialDBServer $dbSever -SocialDBName $socialDbName -ApplicationPool $appPool
New-SPProfileServiceApplicationProxy -Name $svcAppProxyName -ServiceApplication $svcApp

See Also


Configure Subscription Settings Service Application in SharePoint 2016

$accountName = "CONTOSO\joeylicc"
$svcAppPoolName = "SubscriptionSettingsServiceApplicationPool"
$svcAppName = "Subscription Settings Service Application"
$dbName = "SubscriptionSettings"

$account = Get-SPManagedAccount $accountName
$appPool = New-SPServiceApplicationPool -Name $svcAppPoolName -Account $account
$svcApp = New-SPSubscriptionSettingsServiceApplication -Name $svcAppName -DatabaseServer $dbServer -DatabaseName $dbName -ApplicationPool $appPool
New-SPSubscriptionSettingsServiceApplicationProxy -ServiceApplication $svcApp

See Also

Configure App Management Service Application in SharePoint 2016

$accountName = "CONTOSO\joeylicc"
$svcAppPoolName = "AppManagementServiceApplicationPool"
$svcAppName = "App Management Service Application"
$dbName = "AppManagement"
$svcAppProxyName = "App Management Server Application Proxy"

$account = Get-SPManagedAccount $accountName
$appPool = New-SPServiceApplicationPool -Name $svcAppPoolName -Account $account
$svcApp = New-SPAppManagementServiceApplication -Name $svcAppName -DatabaseServer $dbServer -DatabaseName $dbName -ApplicationPool $appPool
New-SPAppManagementServiceApplicationProxy -Name $svcAppProxyName -UseDefaultProxyGroup -ServiceApplication $svcApp

See Also


SharePoint Document Center Site

A Document Center site works for both of these scenarios.

  1. Authoring environment
  2. Content archive

Key Features

  • Metadata Navigation
    • Provides each list in the site with a settings pages for configuring that list to use metadata tree view hierarchies and filter controls to improve navigation and filtering of the contained items
    • Site settings > Site Collection Administration > Site Collection features > Metadata Navigation and Filtering
    • Default: Active
    • List Settings > General Settings > Metadata navigation settings
  • Document IDs
    • Assign IDs to document in the Site Collection, which can be used to retrieve items independent of their current location
    • Site settings > Site Collection Administration > Site Collection features > Document ID Service
    • Default: Active
    • Site settings > Site Collection Administration > Document ID settings
  • Document Versions
    • List Settings > General Settings > Versioning settings
    • Default: Create major versions
    • Default: Keep 500 major versions
  • Content Types
    • List Settings > General Settings > Advanced settings
    • Default: Allow management of content types?
    • List Settings > Content Types
    • Default: 1) Document, 2) Link to a Document &  3) Document Set
  • Content Organizer
    • Create metadata based rules that move content submitted to this site to the correct library or folder
    • Site settings > Site Collection Administration > Site Collection features > Content Organizer
    • Default: Inactive

See Also


Best Practices for SQL Server in SharePoint

  • Use a dedicated server for SQL Server
  • Do not enable auto-create statistics on SharePoint content databases
  • Set max degree of parallelism (MAXDOP) to 1
  • Create DNS aliases that point to the IP address for all instances of SQL Server
  • NTFS Allocation Unit Size = 64 KB
    • format d: /FS:NTFS /Q /A:64K /Y
  • Collation = Latin1_General_CI_AS_KS_WS
  • Maximum Server Memory = 16 GB / 16,384 MB

Database Sizing

tempdb Initial Size Autogrowth
Rows Data 500 MB 500 MB
Log 125 MB 70 MB
  • Recovery model : Simple


model Initial Size Autogrowth
Rows Data 500 MB 500 MB
Log 125 MB 70 MB
  • Recovery model : Full
  • Auto Create Statistics : False
  • Auto Update Statistics : False

See Also


SharePoint 2016 System Requirements

Install SharePoint 2016 (Single Server Farm)

Hardware Requirements
  • Pilot, user acceptance test (Including Development or evaluation installation)
  • RAM : 16-24 GB
  • Processor : 64-bit, 4 cores
  • Hard disk : 80 GB for system drive; 100 GB for additional drives
Software Requirements
  • Prerequisite : Windows Server 2012 R2 update : April 2014
  • 64-bit edition of Microsoft SQL Server 2014 Service Pack 1 (SP1)
    • SQL Server Express is not supported
  • 64-bit edition of Windows Server 2012 R2 Standard or Datacenter

See Also


What’s new in SharePoint 2016

  • Hybrid
    • OneDrive Redirection
    • Sites you follow in one place
    • Hybrid Cloud Search
    • App Launcher and UI Changes
  • Infrastructure and Performance Improvements
    • MinRoles
      • Multi-Server Farm
        1. Front-end
        2. Application
        3. Distributed Cache
        4. Search
        5. Custom
      • Single-Server Farm
    • Zero Downtime Patching
    • Removed 5000 View Threshold – Sort of
    • Increased File Size for Uploads
    • Fast Site Creation
  • New Compliance Center
  • New Collaboration Experience
    • Durable Links
    • Site Folders

See Also


Learning Git

Git is a software that allows you to keep track of changes made to a project over time. Git works by recording the changes you made to a project, storing those changes, then allowing you to reference them as needed.

  1. A Working Directory where you’ll be doing all the work creating, editing, deleting and organizing files.
  2. A Staging Area where you’ll list changes you make to the working directory.
  3. A Repository where Git permanently stores those changes as different versions of the project.
git init -- creates a new Git repository
git status -- inspects the contents of the working directory and staging area
git add -- adds files from the working directory to the staging area
git diff -- shows the difference between the working directory and the staging area
git commit -- permanently stores file changes from the staging area in the repository
git log -- shows a list of all previous commits
git checkout HEAD filename -- discards changes in the working directory
git reset HEAD filename -- unstages file changes in the staging area
git reset SHA -- can be used to reset to a previous commit in your commit history
git branch -- lists all a Git project’s branches
git branch branch_name -- creates a new branch
git checkout branch_name -- used to switch from one branch to another
git merge branch_name -- used to join file changes from one branch to another
git branch -d branch_name -- deletes the branch specified
git clone -- creates a local copy of a remote
git remote -v -- lists a Git project’s remotes
git fetch -- fetches work from the remote into the local copy
git merge origin/master -- merges origin/master into your local branch
git push origin branch_name -- pushes a local branch to the origin remote

See Also