Friday, August 29, 2014


Course Details

Prerequisites and Overview

An ideal candidate will have at least one year of experience with deploying and administering multiple SharePoint 2010 farms across a large enterprise. Because many customers skipped upgrading from SharePoint 2007, a candidate can also have at least 2 years of experience with SharePoint 2007 and knowledge of the differences between 2007 and 2010, particularly the Service Application model. A candidate can demonstrate the following skills:

Software management in a Windows 2008 R2 enterprise server or Windows Server 2012 environment.
Deploying and managing applications natively, virtually and in the cloud.
Administering Internet Information Services (IIS).
Configuring Active Directory for use in authentication, authorization and as a user store.
Managing an application remotely using Windows PowerShell 2.0.
Connecting applications to Microsoft SQL Server.
Implementing Claims-based Security.

Suggested Classes

55033 - SharePoint 2013 Site Collection and Site Administration
50547 - SharePoint 2010 Site Collection and Site Administration

MCSA: Windows Server 2012

20410 - Installing and Configuring Windows Server 2012
20411 - Administering Windows Server 2012
20412 - Configuring Advanced Windows Server 2012 Services

MCSA: SQL Server
10774 - Querying Microsoft SQL Server 2012
10775 - Administering Microsoft SQL Server 2012 Databases
10777 - Implementing a Data Warehouse with Microsoft SQL Server 2012

10961 – Automating Administration with PowerShell 3.0
10325 – Automating Administration with PowerShell 2.0

A+, Network+, Security+


SharePoint 2013 MCSE
What’s New in SP2013
70-331 Study Guide – SharePoint Study Group Wiki

Module 1 – Introduction

Evaluation Software for SharePoint 2013
General Planning for SharePoint 2013
Explore SharePoint 2013 New Features
Changes – SP 2010 to SP2013
Hybrid SP 2013
Compare SharePoint 2013 Versions

Module 2 - 4 - Designing Architecture

Hardware and Software Requirements
Manage lists and libraries with many items
Hybrid Solutions for SharePoint
Special Requirements for BI
Virtual Best Practices for SP 2013
On-premises virtualization in SP 2013
SQL capacity planning in SP2013
SQL 2014 Support – SP1 + April CU
SQL 2014 AlwaysOn
Database types and Descriptions


Install Guide – Three Tier Model
Tech Guides and Planning Worksheets - Downloadable Content for SharePoint 2013
DB Recovery Options
Recovery Models
High Availability Solutions for SQL
Topologies for SharePoint 2013
Extranet Topologies (2010 – looking for 2013)
Request Manager


Content Deployment for SharePoint 2013 is missing but here is 2010
Records management
Record center
Document management
Document center 

Module 5 - Installation and Configuration

Software Boundaries and Limits
Service Accounts

Prerequisite Installer
Prerequisite Issue – App Fabric 1.1
Missing Four Prerequisites

DisableLoopbackCheck. Lets do it the right way
Loopback vs. Back-Connection Hostnames
IISReset - One Web Application
When to Use IISReset
SQL Alias
SMTP Reference
Email Setup

Deploy OWA Server
OWA Hardware and Software Requirements
WOPI – Web Open Platform Interface
OWA High Available
OWA Licensing
Excel vs. Excel in WOPI

Workflow Server - How to Add More Computers to a Service Bus Far
People Picker in 2013


More from TheCloudEngineer
Streaming Video
Handling PDF in SharePoint

Module 6 - Web Applications and Site Collections

Managed Paths
Host-Named Site Collections – Good Table Comparing PBSC vs. HNSC (TechNet)
More on Host-Named Site Collections (Blog)

Moving from PBSC to HNSC
Warm-up Scripts
SP Shell Access
List of Site Templates
Manage site quotas and locks

Module 7 - Service Applications

Configure services and service applications in SharePoint 2013
Service Application Dependencies
Document Conversion
Service Applications Roadmap
Proxy Groups

Module 8 - Users and Permissions

Permissions Overview
Fine-grained permission reference for SharePoint Server 2013
Difference between Site Collection Primary/Secondary/Owner

Sign in as Different User

Module 9 – Authentication

Authentication Overview (excellent article with videos)
Configure authentication infrastructure in SharePoint 2013
FBA in SharePoint 2013
Kerberos authentication in SharePoint 2013
SAML-based claims auth with ADFS

Federation scenarios
AD FS 2.0 Step-by-Step and How To Guides
How to Install and Configure ADFS 2.0 for SharePoint 2010 on Windows Server 2008 R2 (old 2010 reference)

Claims Identity Token Explained (old 2010 but good overview)
Identity Claims Encoding for SharePoint
Create Containers using ADSIedit
Using Facebook as Identity Provider (4 part series)

OAuth - Authorization and authentication for apps in SharePoint 2013
Oauth - Configure server-to-server authentication in SharePoint 2013

Module 10 – Security

Firewall Ports
SMTP Redirect
IRM – Information Rights Management
Hack SharePoint
Anti-Virus – Excluded Folders

Module 11 - MMS - Managing Taxonomy

MMS Planning
Good Overview MMS from
Good Detail Info from Community
Managed Navigation
Free General Business Taxonomy - WAND
Content Type Hub FAQ
Column Types

Module 12 - UPS - User Profiles

Must Do Checklist from Microsoft SharePoint Team
TechNet Info
Import Enabled Accounts Only
Import Photos from AD
old -
LDAP for AD Import
MSDN: Search Filter Syntax
LDAP Filter Syntax
RFC 4515 on LDAP Search Filters
AD Import Mappings
AD Properties – cool reference for AD mappings
Multi Forest - Office 365 does support multi forest, but recommends a single one
Exchange SP1 adds multi-forest

Module 13 - Enterprise Search

Search Administration
Scaling Search for SharePoint 2013
Query Rules Levels and permissions

Overview Result Types and Display Templates
Result Types
Site Column to manage property
Search Migration from 2010
FAST Migration
Custom Search Connectors
Lotus Notes Connector
Documentum Connect
Search Topology
Compare Foundation vs. Server
Search Troubleshooting Tool
Move Search Index

Module 14 - Monitoring, Maintaining and Performance

Diagnostic Logs
ULS Viewer
Data Collection Sets

Timer Jobs
Client Side Tracing BCD
Performance Analysis of Logs (PAL) Tool

Plan for caching and performance in SharePoint Server 2013

Extra SharePoint 2013 Topics

RBS in 2013
Email Scenarios
Content Type Change Control – sealed – unsealed
Managed Metadata Service Connection Properties
New SharePoint Active Directory Import Support (light and fast)
Permissions Control SharePoint Designer
Close Site Policy – New Concept in SharePoint 2013

Site Mailbox – SharePoint 2013
SQL Free Testing Tools
S2S Authentication

Wednesday, August 27, 2014


About This Course

Description - This five-day instructor-led course is intended for power users, who are tasked with working within the SharePoint 2013 environment. This course will provide a deeper,narrowly-focused training on the important and popular skills needed to be an administrator for SharePoint site collections and sites. SharePoint deployment or farm administration skills and tasks, which are required for IT professionals to manage SharePoint 2013, are available in separate Microsoft Official Courseware.
Audience - This course is intended for SharePoint site collection administrators, site administrators and power users who are tasked with working within the SharePoint environment.
Prerequisites - Before taking this course, students should be familiar with:
Windows client operating system – either Windows XP, Windows 7 or Windows 8
Microsoft Office 2007, Office 2010 or Office 2013
Microsoft Internet Explorer 7, 8 or 9
It is recommended students have familiarity with previous versions of SharePoint, though it is not a required prerequisite.
Objectives - After completing this course, students will be able to:
Design and implement a company portal structure using SharePoint 2013 objects including sites, libraries, lists and pages
Explain the role of security and permissions throughout SharePoint 2013
Implement guidelines for consistency in building a company portal to aid in the day-to-day administration of content in SharePoint 2013
Enhance the design of and content on a company portal using SharePoint 2013 themes and web parts
Explain the importance of governance for the planning and managing future growth of the SharePoint 2013 implementation
Identify options to integrate data from other systems as well as preserve existing data
Explain the role of social networking in SharePoint 2013 and its impact on collaboration

Module Overview

Modules 1-5 – Basic SharePoint Admin
Modules 6-12 – Advanced SharePoint Admin

Module 1: Getting Started with SharePoint 2013

SharePoint Versions
If using IE 8 or IE 9 this feature requires Office 2013 to be installed. For all other browsers (IE 10, Firefox, Chrome, Safari), this feature works with any version of Office.

Only site collection administrators can view items in the second stage recycle bin. This is also called the Site Collection
Recycle Bin. This recycle bin has an added column to show who deleted the content in addition to when it was deleted.

Module 2: Planning a Company Portal Using SharePoint 2013

Governance Overview

Module 3: Creating a Company Portal

Types of Libraries
Types of Lists
Limit on Views – 50 using UI
Configure Quick Launch
Edit Links

Module 4: Creating Consistency across Sites

Create Columns
Column Types
Create Views
Lookup Columns
Content Types
Managed Metadata (MMS)
Content Organizer
List Templates
Library Templates

Module 5: Securing a Company Portal

Edit Permissions

Module 6: Customizing the Look of a Portal

Great Looking Sites
Web Part – Adding and Changing Web Parts
Content Search Web Part

Module 7: Extending a Company Portal

External Lists
Record Center
Searching and using keywords in eDiscovery
Plan and manage eDiscovery cases
Create and run eDiscovery queries
Add content to an eDiscovery case and place sources on hold

Module 8: Leveraging Web Content Management

Manage publishing sites
Work with a publishing approval workflow
About publishing-enabled site templates
Enable publishing features
Managed Metadata Navigation

Module 9: Bridging the Social Gap

Social Features
Onedrive for Business

Module 10: Finding Information Using Search

Overview of crawled and managed properties in SharePoint Server 2013
Search Schema Overview
Plan to transform queries and order results in SharePoint 2013
Query variables in SharePoint Server 2013

Module 11: Controlling and Planning for Growth

Governance Overview

Module 12: Administering a Company Portal Built on SharePoint 2013

What Does a SharePoint Site Collection Administrator do?
Site and site collection administration
Manage site collections


Storage Metrics
Find Content about SharePoint 2013
What’s New in SharePoint 2013
Discontinued Features

Monday, August 18, 2014

Tuesday, August 12, 2014


Course Details

20332 - Advanced Solutions of Microsoft SharePoint Server 2013

Prerequisites and Overview

Before attending this course, students must have:
  • Completed Course 20331: Core Solutions of Microsoft SharePoint Server 2013, successful completion of Exam 70-331: Core Solutions of Microsoft SharePoint 2013, or equivalent skills.
  • At least one year’s experience of mapping business requirements to logical and physical technical design.
  • Working knowledge of network design, including network security.
  • Experience managing software in a Windows 2008 R2 enterprise server or Windows Server 2012 environment.
  • Deployed and managed applications natively, virtually, and in the cloud.
  • Administered Internet Information Services (IIS).
  • Configured Active Directory for use in authentication, authorization and as a user store.
  • Managed an application remotely using Windows PowerShell 2.0.
  • Connected applications to Microsoft SQL Server.
  • Implemented Claims-based security.

Suggested Classes

20331 – Core Solutions of Microsoft SharePoint Server 2013
55033 – SharePoint 2013 Site Collection and Site Administration
50547 – SharePoint 2010 Site Collection and Site Administration

MCSA: Windows Server 2012

20410 – Installing and Configuring Windows Server 2012
20411 – Administering Windows Server 2012
20412 – Configuring Advanced Windows Server 2012 Services

MCSA: SQL Server10774 – Querying Microsoft SQL Server 2012
10775 – Administering Microsoft SQL Server 2012 Databases
10777 – Implementing a Data Warehouse with Microsoft SQL Server 2012

10961 – Automating Administration with PowerShell 3.0
10325 – Automating Administration with PowerShell 2.0

CompTIAA+, Network+, Security+


70-332 Study Guide – SharePoint Study Group Wiki

More from Tech Bytes
MCSE SharePoint 2013

Module 1 - SharePoint Server 2013 Architecture

Hardware and software requirements for SharePoint 2013
Software boundaries and limits for SharePoint 2013
Overview of mobile devices and SharePoint Server 2013
Create and configure communities in SharePoint Server 2013
Configure My Sites in SharePoint Server 2013
Changes from SharePoint 2010 to SharePoint 2013
SharePoint feature availability across on-premises solutions
Hybrid for SharePoint 2013
Technical Diagrams
SharePoint Versions

Module 2 - Designing Business Continuity Management Strategies

Updated - Supported high availability and disaster recovery options for SharePoint databases (SharePoint 2013)
High availability and disaster recovery concepts in SharePoint 2013
Request Manager in SharePoint Server 2013

Request Management in SharePoint Server 2013 – Two Part Series
Request Management Issues
Failover Timeout Value
SharePoint 2013 and SQL Server Always On - High Availability SharePoint
SQL Versions

Module 3 – Service Applications

SharePoint 2013 service applications - Technical diagrams for SharePoint 2013

Operations for SharePoint 2013
Site and Solution Administration 2010 (Oldie but a goodie - still applies to 2013)
Service Application Dependencies

Module 4 - BCS - Business Connectivity Services

SSS – Secure Store Service
BCS – Business Connectivity Service

Module 5 - People

Server-to-server authentication and user profiles in SharePoint Server 2013
AD Import – Step by Step
UPA – Step by Step
Oldie but Goodie
AD Import Mappings
Cleanup Obsolete Users and Groups and more in this article …
Maintain user profile synchronization settings in SharePoint Server 2013

Module 6 - Productivity and Collaboration

Oauth - Configure server-to-server authentication in SharePoint 2013
Error - “We’re still collecting the latest news…”
Azure Workflow Manager
SharePoint Designer 2013 – Workflow
Co-authoring administration in SharePoint 2013
Good Co-authoring Overview in SharePoint 2013
Overview of co-authoring in SharePoint 2013 (limit max users)
Project Server 2013 - Install and configure for Project Server 2013

Module 7 - BI - Business Intelligence

What’s New in Business Intelligence
Compare Excel Services vs Excel using WOPI

Power BI for Office 365
Power Query, enabling customers to easily search and access public data and their organization's data, all within Excel (formerly known as "Data Explorer"). Power Map, a 3D data visualization tool for mapping, exploring and interacting with geographic and temporal data (formerly known as product codename "Geoflow"). Power Pivot for creating and customizing flexible data models within Excel.
Power View for creating interactive charts, graphs and other visual representations of data.
Introducing Power BI for Office 365
Power BI FAQ

Module 8 - Enterprise Search

Search Reports
Query spelling suggestions
Linguistic search features in SharePoint Server 2013
Query Spelling Suggestions
Query Suggestions
Continuous Crawls - The default interval every 15 minutes. Shortest interval possible every 1 minute.
Search Query Tool

Module 9 - ECM - Enterprise Content Management

Shredded Storage
Overview of eDiscovery and in-place holds in SharePoint Server 2013
Record Center – File Plans
Composite Solutions

Module 10 - WCM - Web Content Management

New Publishing Templates in SharePoint 2013
Cross Site Publishing
Master Page Preview File – More on oslo.preview seattle.preview
Design Manager – MSDN
Design Channels – MSDN
Configure Search Web Parts in SharePoint Server 2013
Configure refiners and faceted navigation in SharePoint Server 2013
SharePoint 2013 Design Manager device channels
More on Device Channels
Good Article on Mobile Device Design (5 parts)

Module 11 - Managing Solutions

Installation and Deployment of a Farm Solution in SharePoint 2010
Upgrading a Farm Solution in SharePoint 2010
Un-installation and Retraction of a Farm Solution
Sandboxed Solutions – Metrics

Module 12 - Apps

Install and manage apps for SharePoint 2013

SharePoint app model - Download the SharePoint 2013: App Overview for IT Pro
Configure an environment for apps for SharePoint (SharePoint 2013)
Manage the App Catalog in SharePoint 2013
App permissions in SharePoint 2013

Multiple domain functionality to Apps - March PU – Note reverse proxy requirement
Fab 40 Apps

Module 13 – Governance

Site Policy
Best Practices
Governance Planning
Operations for SharePoint 2013

Module 14 - Upgrading and Migrating

Tech Center
Planning worksheet – Download

Database-Attach Checklist

Upgrade site collections to SharePoint 2013
Manage Site Collection Upgrades
Run site collection health checks in SharePoint 2013
Introduction to Upgrade – Bill Baer
Why SharePoint 2013 Cumulative Update takes 5 hours to install?

Upgrade Tools

Extras - Appendix

Planning worksheets for SharePoint 2013
Overview of SharePoint 2013 Multilingual Features
Distributed Cache (info and downloadable content)

Monday, July 14, 2014

10174 SharePoint 2010 Installation and Config

General Class and SharePoint Info
Class Prerequisites
What's New
Learning Plan for 70-667 Exam  MCTS

Module 1 - Installation

More from The Cloud Engineer
Installation Tips
Great Looking SharePoint Sites

More on Installation
Details and links to Hardware and software requirements (SPS 2010)
Compare SharePoint Editions
Client - Browser Level 1 and 2 (chrome and Firefox have issues with datasheet view)
Good Browser Compatibility List
IPAD support
64 bit browser issues
Datasheet view fix for 64 bit office
NTLM vs. Kerberos
DNS issues
Account permissions and security settings
Latest Updates
Planning for Multiple Languages
InfoPath localization
SharePoint Licensing
Capacity Planning for SharePoint
Loopback Issues
Local Codes
Sorry no Server 2012

Module 2 - Creating Intranet
More from The Cloud Engineer
Site Collection Design - Site Collection or Subsite - that is the question
Create Site Collection in a separate DB without using PowerShell - tricky
More on Creating Intranet
Plan sites and site collections
Create a Web Application (SharePoint Server 2010)
Create a site collection (SharePoint Server 2010)
Delete a site collection (SharePoint Server 2010)
SharePoint 101: Managed Paths
Good Chapter on Managed Paths
Define managed paths (SharePoint Server 2010)
SharePoint Server 2010 Capacity Management: Software Boundaries and Limits (updated)
Central Site for all SharePoint 2010 Capacity Planning (great start)
Database types and descriptions” (SharePoint Server 2010)
Rename DB to remove GUID
Storage and SQL Server capacity planning and configuration (SPS 2010)
MSDN Tables and Views
Split Content DB
Move Service Applications

Module 3 - Administration
More from The Cloud Engineer
Change the Central Administration Web site port number” (SPS 2010)
Setadminport: Stsadm operation” (Office SharePoint Server)
Choose administrators and owners for the administration hierarchy” (SPS 2010) at
Wake-on-LAN info
Missing Central Admin Links?

More on Administration
Found some great PowerShell scripts here for SP2010
About Windows PowerShell
Understanding the Windows PowerShell Pipeline”
PS Thread Options
“Viewing Object Structure (Get-Member)”
Stsadm to Windows PowerShell mapping
PowerShell vs. STSADM (unofficial list of missing commands)
Remote PS
PowerShell Hints
PowerShell Profiles

Module 4 - Content Management
More from The Cloud Engineer
Office Integration for SharePoint 2010
Managed Metadata Service
More on Content Management
Metadata Services (good example using conf room) ( good overview diagram) (Planning worksheets) ( good intro with detailed descriptions of icons)
Manage Permissions
Datasheet View Issues for 64-bit Office
Client Features for Office 2003 2007 or 2010 (pdf)
Microsoft Office 2010 with Different Versions of Microsoft SharePoint


More from The Cloud Engineer

RBS - Remote Blob Storage Overview

List Column types and options
List Throttling - Good Article

Module 5 - Authentication
More from The Cloud Engineer

More on Authentication
Security and Authentication for SharePoint Server 2010
Good overview of authentication
Double Authentication http/https issues
Secure Store

Module 6 - Security
Good Review on Security in SPF 2010
What is Limited Access

Information Rights Management
Step by Step IRM

Module 7 - Customization
More from The Cloud Engineer
Fab 40 update - Notice that Techsol is working to convert Fab 40 to 2010

Lotus Notes Integration

Great Looking SharePoint Sites
Developer Dashboard

Sandbox Solutions
More from The Cloud Engineer

More on Sandbox Solutions
Compare Farm vs Sandbox Solution
Sandbox Architecture
Good article to clarify GAC vs Sandbox and lists Solution Restrictions
Deploying Sandbox via PowerShell
Sandbox or no Sandbox that is the question
Appears that iisreset is an optional component of SharePoint Solution
More on SharePoint Projects

Troubleshooting Tools
Developer Dashboard
Fiddler - Web Debugger
Visual Route Trip Analyzer
Firebug and Firebug Lite for IE6+, Firefox, Opera, Safari and Chrome

SharePoint Designer
SharePoint Designer Security
Manage SharePoint Designer
Changes to SharePoint Designer
Control SharePoint Designer

Module 8 - Service Applications
More from The Cloud Engineer
Service Accounts
Advanced Timer Jobs
Long List of SharePoint Service Application Configuration and Admin

More on Service Applications
Share service applications across farms
In a Nutshell: SharePoint 2010 Service Applications
Default Timer Jobs

Module 9 - User Profile and My Sites
More from The Cloud Engineer

More on Social
Planning for Social
MySite Branding
Add User Photos Automatically
SAP Integration

Organizational Browser

User Profile Service
Great article from Harbar

Module 10 - Search
More on Search

Search Options from Microsoft
Secure your search results even more ...
PDF info (you need to add both ifilter and icon)
Good Overview from SharePoint George
Getting Started with Enterprise Search in SharePoint 2010 Products (pdf)
FAST Filter Pack
Office Filter Pack
Free SOA (Search Engine Optimization) Tools
Performance and capacity management
Step-by-Step: Provisioning the Search Service Application
AAM and Server Mapping
Search Syntax or Building Search Queries

Module 11 - Office Web App
More from The Cloud Engineer
Service Administration - Great list of links

More on Office Web Apps
Office Web Apps overview
Office Web App Blog
Office Web Apps platform comparison
Configure the default open behavior for documents
SharePoint 2010 compatibility with Office 2007

Co-authoring (i.e. Simultaneous Editing) in Word 2010
More on Co-authoring
Web Application Printing in SP1
Office Web App SP1
New Document

Module 11 – BI

Module 11 - Enterprise Service Applications

Site and solution administration

Module 11 - Access Services
More from The Cloud Engineer

Module 11 - Excel Services
Comparison to Office Web Apps

More from The Cloud Engineer

Module 12 - Enterprise Install

More from The Cloud Engineer
Install Tips and Tricks

Email Settings

Farm Configuration Scripts

Module 12 - Upgrade
More from The Cloud Engineer
More on Upgrade

Upgrade Paths - good article on in-place versus database attach upgrade with step by step
Supported and unsupported upgrade
TechNet Resource on Upgrade
2003 to 2010 is an two step upgrade without third party tools{72C1C85B-1D2D-4A4A-90DE-CA74A7808184}&pID=441
Article compares several upgrade methods and techniques and huge table to compare
Database Attach
InfoPath Migration
Introduction to search-first migration

Module 12 - Updates (Service Packs and CU)
More from The Cloud Engineer

Latest on SP1
Now SP 2 is out – July 2013
Updates for SharePoint 2010 Products (great article on CU and SP)
Prepare for Update
SharePoint 2010 build level and version numbers
Mystery Behind SharePoint Patches
Latest on Updates (Blog)

Detailed Update Overview
Todd Klindt Build List

Module 13 - Business Continuity

More from The Cloud Engineer
SharePoint Server 2010 - 10 Steps to Disaster Recovery
Document your SharePoint Site

DPM Guide

Using SQL Snapshots for backup
SharePoint Backup Guide
Backup Scheduling - Great reference
Move content databases

Setup SharePoint Farm using NLB and SQL Cluster
Part 1 - Prepare Windows Cluster
Part 2 - Install and configure SQL Cluster
Part 3 - Install and Configure NLB on WFE
part 4 - Install and configure SharePoint farm (3-tier)
Module 14 – Performance
More from The Cloud Engineer

SharePoint Server 2010 performance and capacity test results and recommendations
SharePoint Health Analyzer rules reference
Configure Diagnostic Logging
Developing, Deploying, and Monitoring Sandboxed Solutions in SharePoint 2010
Web Analytics
SharePoint Diagnostic Studio 2010
Free chapter from a great book on Monitoring SharePoint 2010
Add Auditing to SharePoint Foundation
Auditing Basics and Creating Custom Audit Log Entries

Module 15 - SharePoint Online and Office 365
More from The Cloud Engineer

Microsoft Resources
TechNet SharePoint 2010 TechCenter
Getting Started Series for SharePoint 2010 IT Professionals
SharePoint 2010 TechNet Forum
Latest Updates - Patches
SharePoint Posters

Student Links
More from The Cloud Engineer
Visio Shapes
Vendor and Book Links