Thursday, September 18, 2014

50547 - SharePoint 2010 Site Collection and Site Administration

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

Module 1 – SharePoint 2010 General Overview

More from The Cloud Engineer
2007 Office System Driver: Data Connectivity Components

Module 2 – SharePoint 2010 Environment – Getting Started

Site and site collection administration (SharePoint Server 2010)
Hints - Fix Issues Testing Multiple Sessions

Module 3 – SharePoint 2010 General Overview

Site and Solution Governance
AIIM (Association for Information and Image Management)
Card Sorting
Video on Usability Card Sorting for Website - Intellavia

Module 4 – Site Collections, Top Level Sites and Sites

Planning Navigation
SharePoint 2010 Limitations
Fab 40
Productivity Hub
How to insert sample text into a document in Word - =rand(6,8)

Module 5 – Creating Libraries and Lists
Content Approval Feature and the Approval Status of Items in a List or in a Document Library
Create Views
Advanced Views
Index Columns
! New Tag Info (old)

Module 6 - Managing Permissions for Users and Groups
Good Review on Security in SPF 2010

Module 7 - Site/Content Management and Collaboration
View Unique List ID
Records Center

Module 8 - Office 2010 Integration with SharePoint 2010
More from The Cloud Engineer

Set your browser to open files in a new window or tab

Module 9 - Creating Consistency Across Sites
Intro Content Types

Module 10 - Finding Information Using Views and Search
Latest on SharePoint
Card Sorting
AIIM (Association for Information and Image Management)
Keyword Syntax

Module 11 - Displaying Data with Web Parts in SharePoint 2010

More from The Cloud Engineer

Roadmap for creating and customizing Web Part Pages for a SharePoint site (2007 but good start)
Overview of Web Parts available in SharePoint Foundation 2010
Change the appearance of a Web Part

Module 12 - Document Management through Workflows

More from The Cloud Engineer
Workflows – Start Here

More from the Web
Workflow Resource Center
SharePoint Designer 2010
SharePoint Designer 2010 and Workflows
Workflow Quick Reference Guides for SharePoint Designer 2010
Workflow conditions in SharePoint Designer 2010: A quick reference guide
Workflow actions in SharePoint Designer 2010: A quick reference guide
Workflow Development in Visual Studio

Module 13 - SharePoint 2010 Social Computing and Collaboration
More from The Cloud Engineer

Module 14 - Administrating a SharePoint 2010 Site Collection and Site
More from The Cloud Engineer

Great Information Working Links
Zone Tabs
Title vs. Name!topic/microsoft.public.sharepoint.windowsservices/NuIdwj849vs%5B1-25%5D

Wednesday, September 10, 2014

55035A - Microsoft SharePoint Server 2013 for the Site Owner/Power User

About This Course

55035A - Microsoft SharePoint Server 2013 for the Site Owner/Power User


This class is designed for the owner of a Microsoft SharePoint Server site who needs to know how to create sites and lists, manage user access and customize lists and web part pages.

This class uses the Microsoft SharePoint Server 2013 Enterprise Edition version of SharePoint.


Students should have a working knowledge of SharePoint 2013 and basic SharePoint site and SharePoint list navigation skills.

Module Overview

Module 1: The Role of the Site Owner
Module 2: Users, Groups and Permissions
Module 3: Site and Site Collection Features
Module 4: Managing Sites and Pages
Module 5: Working with Lists and Libraries
Module 6: Advanced Document Management
Module 7: SharePoint Workflows
Module 8: Monitoring SharePoint Activity
Module 9: SharePoint Apps (Optional)
Module 10: The SharePoint Community Site (Optional)

Lab 1 (Review Lab)
Lab 2
Lab 3
Lab 4
Lab 5
Lab 6

Module 1: The Role of the Site Owner

Plan browser support in SharePoint 2013

SharePoint Versions

What’s New in SharePoint 2013

Discontinued Features

Changes from SharePoint 2010 to SharePoint 2013 (including deprecated features)

What's new in web content management for SharePoint 2013 publishing sites

What's new in social computing in SharePoint Server 2013

What's new in workflow in SharePoint Server 2013

What's new in search in SharePoint Server 2013

What's new for mobile devices in SharePoint 2013

Discontinued features and modified functionality in Microsoft SharePoint 2013

Module 2: Users, Groups and Permissions

SharePoint Simplified

Module 3: Site and Site Collection Features

Administer sites and site collections in SharePoint 2013

Module 4: Managing Sites and Pages

New Team Site Template

Module 5: Working with Lists and Libraries

Add App to SharePoint 2013

Module 6: Advanced Document Management

Create and apply information management policies

Module 7: SharePoint Workflows


Module 8: Monitoring SharePoint Activity

Monitor sites and site collections in SharePoint 2013

Module 9: SharePoint Apps (Optional)


Add App to SharePoint 2013

Module 10: The SharePoint Community Site (Optional)

Overview of communities in SharePoint Server 2013


Storage Metrics

Find Content about SharePoint 2013

Monday, September 8, 2014

SharePoint 2010 Designer (Basic) - Course 50354

Course 50354 Scope:
This class is designed for business or IT Professionals that need to modify the OOTB (out of the box) SharePoint experience using the free tool SharePoint Designer 2010.  Developers need to focus on classes based on not-so-free Visual Studio product.

Module 1 - Overview

Module 2 - Changes

Download SharePoint 2010 32 bit version (free)
Download SharePoint 2010 64 bit version (free)

Module 3 - Designer Interface

Master Page and Content Placeholders

Module 4 - Data Views

Linked Data Sources

Module 5 - External Content Types

BDC Editors
CRUD - Create Read Update Delete

Module 6 - Workflows

Workflow Overview
Understanding Workflows
Daily Weekly Monthly Workflow
Workflow Conditions Reference
Workflow Actions Reference
If a workflow is paused it will wait dehydrated until the condition is met and will then continue. You can find more info here.
and here and more here
Workflow Versioning
Workflow Variables

More from
Understand approval workflows in SharePoint 2010
Workflow conditions in SharePoint Designer 2010: A quick reference guide
Workflow actions in SharePoint Designer 2010: A quick reference guide
Introduction to designing and customizing workflows
Use the task process editor for approval workflows


Check for Empty Dates

Get Rid of Revert to Template



Browser Support

SharePoint 2010: Beginning with SharePoint Designer

Development vs. Production

Drop-off library issues

Copy workflows

PowerShell and Workflows (posh)

What Lists have workflows (posh)


CSS Tutorials
Great help here from w3schools and check out the samples in the garden.

The ability to design in Visio and then import in to SP Designer is great. Have a look at the links below they will help to get you started.
The following article provides a great walkthrough for you to follow in creating/importing a workflow in to SharePoint 2010 -

InfoPath Form vs. Custom Web Part

Add Color to your Issue Tracking

Wednesday, September 3, 2014

Great Tools

Outlook 2010 and together


Great Remote Connect Management Tool – RDP, VNC, ICA, SSH , Telnet, HTTP/HTTPS, rlogin, and Raw Sockets

Family Safety

Check out this great list of open source apps for windows - Updated from my own workstation.

SharePoint Only

webalizer iis/german

Update – Windows 8/Server 2012

ISO is now part of windows

Here is more great free utils - most are open

M├ętamorphose : A Great File -n- Folder Renamer

Free Undelete

MP3 Spliter

Open Source differencing and merging tool

Open disk usage viewer

Desktop Search
Everything - Locate files and folders by name instantly.

Video transcode

Audio Converter

Here are some great tools that are not open but still worth mentioning.

Magic ISO

Folder Size

Everything search engine - Great tool that locates files and folders by name instantly.

Sysinternals App

Great RDP Manager from Microsoft
Do you hate losing your CD's or DVD, can't find them or if you do they are scratched. If so then convert over to CD or DVD images using ISO file format.  I use disc magic to access these files and it makes CD or DVD management is a breeze.


Don't you hate getting the message that the file is locked and you can't delete due to bad code from some app you download for free.  Guys from sysinternal recommend this free tool - Handle.

Unlocker is also good tool, search google with the following link

since the old link below is broken :(

HDD Scan - Doesn't appear to be virus of same name.  (maybe?)

VB tools with source code

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