Author: Joey Li

Configure Workflow for SharePoint 2016

1. Configure App Management Service

$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

2. Configure Site Subscription Service

$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

3. Install Workflow Manager via Web Platform Installer 5.0

4. Configure Workflow Manager via Workflow Manager Configuration Wizard

5. Configure SharePoint 2016

$siteUrl = "http://localhost"
$workflowHostUrl = "http://localhost:12291"

Register-SPWorkflowService -SPSite $siteUrl -WorkflowHostUri $workflowHostUrl -AllowOAuthHttp




Globalization and Localization

Globalization is the process of designing apps that support different cultures. Globalization adds support for input, display, and output of a defined set of language script that relates to specific geographic areas.

Localization is the process of adapting a globalized app, which you have already processed for localizability, to a particular culture/locale.


SharePoint Team Site Best Practices

Step-by-step Creating SharePoint Team Site

  1. Plan Overall Site Architecture
  2. Plan Site Collection Structure
  3. Plan on Web Parts that will make up the Team Site
    • Common Web Parts for Team Site
  4. Decide the Layout of the Team Site
    • Two columns w/ header
  5. Create the Team Site
  6. Configure the Web Parts
    • Create a “Compact View” for each Web Part
  7. Add the Web Parts to the Site
  8. Setup Security for the Site
    • Use Security Groups
  9. Setup Quick Launch Navigation
    • Never present the Site Contents link on the navigation menu
    • Remove “Recents”
  10. Create a Site Template
The best practice is to keep the SharePoint Site structure as flat as possible.
It is best practice to define all custom columns (metadata properties) at the very top site (Site Collection).
The best practice is to never break the inheritance of security from the site the web parts sit on.

Common Web Parts for Team Site

  • Document Library
    • Configure it w/ metadata, instead of folders
  • Calendar
    • Sync to Outlook
    • Color-code
  • Tasks
    • For Project Team
  • Contact List
  • Announcements
  • Links
    • *Promoted Links*
  • Discussion Board
  • Issue Tacking


Advanced Configuration

  • SharePoint Project Dashboard
  • Sync SharePoint Task List w/ MS Project
  • Project Risk Register in SharePoint
  • SharePoint External Sharing
  • Change Request Log in SharePoint
  • Calednar Color Coding
  • Calendar Sync w/ Outlook


See Also



Delete SQL Server Management Studio Remembered Credential

Delete the file below according to your SQL Server Management Studio version.

Version Path
SQL Server 2016 C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\13.0\SqlStudio.bin
SQL Server 2014 C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\12.0\SqlStudio.bin
SQL Server 2012 C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0\SqlStudio.bin
SQL Server 2008 C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

See Also