Author: Joey Li

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

 

Configure State Service Application in SharePoint 2016

$databaseServer = "{SERVER_NAME}\SHAREPOINT"
$databaseName = "SessionStateService"
$svcAppName = "State Service Application"
$svcAppProxyName = "State Service Application Proxy"

$database = New-SPStateServiceDatabase -Name $databaseName -DatabaseServer $databaseServer
$svcApp = New-SPStateServiceApplication -Name $svcAppName -Database $database
New-SPStateServiceApplicationProxy -ServiceApplication $svcApp -DefaultProxyGroup -Name $svcAppProxyName
Initialize-SPStateServiceDatabase -Identity $database

Building your first ASP.NET Core MVC app with Visual Studio

  1. Get Started
    • ASP.NET Core Web Application (.NET Core)
  2. Adding Controller
  3. Adding View
    • Layout Page
      • Views/Shared/_Layout.cshtml
      • @RenderBody()
    • Passing Data from the Controller to View
      • ViewData dictionary
  4. Adding Model
    • Scaffolding a controller
      • MVC Controller with views, using Entity Framework
    • Update the database
      • dotnet ef migrations add [migration name]
      • dotnet ef database update
    • Strongly typed models and the @model keyword
  5. Working with SQL Server LocalDB
    • Seed the database
  6. Controller Methods and Views
    • Protect your controller from over-posting
    • Validate AntiForgeryToken
  7. Adding Search
  8. Adding New Field
  9. Adding Validation
    • System.ComponentModel.DataAnnotations
  10. Examining the Details and Delete Methods

See Also