iTunes - Remember playback position

iTunes > Right-click song > 'Get Info' > 'Options' tab > Check 'Remember playback position' > OK.

Error: Mount-SPContentDatabase - SPUnrecoverableException

Problem:
I received an error when running the following cmdlet:
Mount-SPContentDatabase -Name SampleContentDB -DatabaseServer SampleDBServer -WebApplication http://intranet.samplecompany.com/

Error:
InvalidData: (Microsoft.Share...ContentDatabase:SPCmdletMountContentDatabase) [Mount-SPContentDatabase], SPUnrecoverableException

Resolution:
The drive was full. I cleared some space and then it worked.

XML - Should I Use an Element or an Attribute?

From MSDN...

Elements are used to encapsulate pieces of data, and attributes are generally used to provide accompanying information about an element, rather than to encapsulate raw data itself. Whether you actually use an element or an attribute is up to the needs of your application.

Use attributes if your information requires data of a simple type and:

•Your information requires a default or fixed value.
•Your information requires data that is metadata for an existing element
•If the size of your XML file is an issue, attributes tend to take up fewer bytes than elements

The following list describes the key differences between elements and attributes from a schema perspective:

•A schema can define whether the ordering of elements is significant, but attributes can occur in any order.
•Elements can be nested with the tag, which means one and only one of the listed elements can appear.
•Elements can occur more than once, but attributes cannot.

Source:
http://msdn.microsoft.com/en-us/library/7f0tkwcx(v=vs.71).aspx

_layouts web.config

Reminder: The following web.config file exists and must be updated for debugging purposes:
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\LAYOUTS\web.config

<configuration>
  <system.web>
    <customerrors mode="Off">
  </system.web>
</configuration>

Using URL Rewrite to Redirect

The following is performed at the web site level in IIS. See 'Resources' below for the 'URL Rewrite' download link, the user reference guide, and a couple other helpful links.
Match URL > Requested URL: 'Matches the Pattern' > Using: 'Regular Expressions' > Pattern:

*Note: Pattern: tests against the <path>, not the entire URL!
http(s)://<host>:<port>/<path>?<querystring>

So if you want to test if a string is in the beggining of the path, you would use ^. For example, if you want to redirect...
http://intranet.samplecompany.com/hr/Pages/default.aspx
... to ...
http://intranet.samplecompany.com/teams/hr/Pages/default.aspx
... you would use:
Pattern: ^hr/.*

Then, Action > Action type: 'Redirect' > Action Properties > Redirect URL:
http://intranet.samplecompany.com/teams/{R:0}
The {R:0} is a back reference variable. You can see it when you use the 'Test pattern...' button in the 'Match URL' section of the form.

*Tip: When using the 'Test pattern...' button > Input data to test:
Use the path, not the entire URL! Remember, the pattern tests against the path, not the entire URL!

*Note: It seems that when using 'Conditions', the path needs a leading forward slash. So for the 'Redirect URL' with no Conditions, one would use the pattern...
^hr/.*
... and the 'Redirect URL'...
http://intranet.samplecompany.com/teams/{R:0}

... but with Conditions, one would use the Condition pattern...
^/hr/.*
... and the 'Redirect URL'...
http://intranet.samplecompany.com/teams{C:0}

*Another Note:
If you attempt to browse to a non-existent page, you will get a 404 error. This is by design, because if the following link doesn't exist here...
http://intranet.samplecompany.com/hr/Pages/sample.aspx

... it's not going to exist here either...
http://intranet.samplecompany.com/teams/hr/Pages/sample.aspx


Resources:

• http://www.iis.net/download/urlrewrite
• http://learn.iis.net/page.aspx/465/url-rewrite-module-configuration-reference/#Rewrite_Rules_Overview?amp;clcid=0x409
• http://www.ableblue.com/blog/archive/2011/02/07/using-iis-url-rewrite-after-moving-to-sharepoint/
• http://regexlib.com/CheatSheet.aspx

CQWP - Date Example

ItemStyle.xsl <xsl:template>

<xsl:value-of select="ddwrt:FormatDateTime(string(@PublicationDate),1033,'MM.dd.yyyy')"></xsl:value-of>

Make sure to include the following in the <xsl:stylesheet> tag:
xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime"

Edit in Notepad

• Open C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML\DOCICON.XML
• <Mapping Key="txt" Value="ictxt.gif" EditText="Notepad" OpenControl="SharePoint.OpenDocuments"/>
• Reset IIS

Source: http://sladescross.wordpress.com/2010/04/26/sharepoint-adding-a-custom-document-template/

.NET - Select a ListItem

sampleDropDownList.ClearSelection();
ListItem sampleListItem = sampleDropDownList.Items.FindByValue(sampleValue);
if (sampleListItem != null)
{
    sampleListItem.Selected = true;
}

SQL Server - Change Result Set Size

Tools > Options... > SQL Server Object Explorer > Commands > Table and View Options > Value for Edit Top <n> Rows command > 300

The trust relationship between this workstation and the primary domain failed

Disconnect network connection > Log in with domain credentials > Reconnect network connection.

#SPSTCDC Schedule Announced

SharePoint Saturday The Conf Daily Schedule #SPSTCDC

How to grant the Remote Desktop Users group the "Allow log on through Terminal Services" user right

'Start' > 'Run...' > gpedit.msc > 'Local Computer Policy' > 'Computer Configuration' > 'Windows Settings' > 'Security Settings' > 'Local Policies' > 'User Rights Assignment' > double click 'Allow log on through Terminal Services' > 'Add User or Group...' > Remote Desktop Users > OK > OK

Windows Server 2008 R2: Enable Sound Over RDP

On the Remote Desktop > Start > Control Panel > Sound > Yes > OK.

On the Remote Desktop > Start > Search programs and files > type 'remote' > click 'Remote Desktop Session Host Configuration' > Connections (Middle Pane) > right-click 'RDP-Tcp' > Properties > 'Client Settings' tab > uncheck 'Audio and video playback' > OK > Start > Log off > Log On > You should hear sound through your client.

References:
How to enable sound over RDP in a Server 2008 R2 Hyper-V guest
Hyper-V Troubleshooting: Enabling Audio Over RDP

I will be speaking at SharePoint Saturday The Conference DC

I will guide you through the obstacles you will encounter as you attempt to put a SharePoint publishing portal up on the Internet. We will mix my recent experiences with audience experiences.

SharePoint 2010 Web Content Management (WCM) Obstacles​

Twitter: SPSTCDC

SP2010 MCM Pre-Reading List

Architecture and Planning

• Configure services (SharePoint Server 2010)
• Manage service applications (SharePoint Server 2010)
• Share service applications across farms (SharePoint Server 2010)
• Exchange trust certificates between farms (SharePoint Server 2010)
• Publish a service application (SharePoint Server 2010)
• Connect to a service application on a remote farm (SharePoint Server 2010)
• Set permission to a published service application (SharePoint Server)
• Add or remove a service application connection to a Web application (SharePoint Server 2010)
• Restrict or enable access to a service application (SharePoint Server 2010)
• Assign or remove administrators to a service application (SharePoint Server 2010)
• Delete a service application (SharePoint Server 2010)
• Enable URL filtering for Web Analytics (SharePoint Server 2010)
• Access Services administration
• Set up and configure Access Services (SharePoint Server 2010)
• How to use Access Services from a template (SharePoint Server 2010)
• Create an Access Services service application (SharePoint Server 2010)
• Delete an Access Services service application (SharePoint Server 2010)
• Use Access Services with SQL Reporting Services: Installing SQL Server 2008 R2 Reporting Services Add-In (SharePoint Server 2010)
• Use macros to automate tasks in Web objects in applications published to Access Services (SharePoint Server 2010)
• Business Data Connectivity service administration (SharePoint Server 2010)
• Manage external systems (SharePoint Server 2010)
• Manage BDC models (SharePoint Server 2010)
• Manage external content types (SharePoint Server 2010)
• Business Connectivity Services security operations (SharePoint Server 2010)
• Use tracing on the client (SharePoint Server 2010)
• Create external content types using SharePoint Designer 2010
• Application Registry Service administration (SharePoint Server 2010)
• Excel Services administration (SharePoint Server 2010)
• Manage Excel Services custom applications (SharePoint Server 2010)
• Ewa Namespace
• Excel Services REST API
• Manage Excel Services connections (SharePoint Server 2010)
• Manage Excel Services trusted locations (SharePoint Server 2010)
• Use Excel Services with Secure Store (SharePoint Server 2010)
• Manage Excel Services with Windows PowerShell (SharePoint Server 2010)
• Managed metadata administration (SharePoint Server 2010)
• Create, update, publish, or delete a managed metadata service application (SharePoint Server 2010)
• Create, update, or delete a managed metadata service connection (SharePoint Server 2010)
• Add and remove term store administrators (SharePoint Server 2010)
• Grant permission to access the managed metadata service (SharePoint Server 2010)
• PerformancePoint Services administration (SharePoint Server 2010)
• Configure PerformancePoint Services
• Create a PerformancePoint Services service application (SharePoint Server 2010)
• Configure the unattended service account for PerformancePoint Services
• Import Wizard: PerformancePoint Server 2007 content to SharePoint Server 2010
• Import PerformancePoint Dashboard 2010 content from a SharePoint Server 2010 server, site, or list
• Delete a PerformancePoint Services service application (SharePoint Server 2010)
• Enable trusted locations for PerformancePoint Services (SharePoint Server 2010)
• PerformancePoint Services application settings (SharePoint Server 2010)
• Manage PerformancePoint Services site and site collections (SharePoint Server 2010)
• Enable the PerformancePoint Services site feature (SharePoint Server 2010)
• Enable the PerformancePoint Services site collection feature (SharePoint Server 2010)
• Plan, design, and implement a PerformancePoint dashboard to show organizational performance
• Extend PerformancePoint dashboards by using MDX queries
• Enterprise search administration (SharePoint Server 2010)
• Manage farm-level search settings (SharePoint Server 2010)
• Configure farm-level proxy server settings (SharePoint Server 2010)
• Configure search time-out settings (SharePoint Server 2010)
• Configure SSL certificate warning settings (SharePoint Server 2010)
• Manage Search service applications (SharePoint Server 2010)
• Create a new Search service application (SharePoint Server 2010)
• Change the default content access account (SharePoint Server 2010)
• Change the contact e-mail address (SharePoint Server 2010)
• Configure proxy server settings for search (SharePoint Server 2010)
• Post-installation steps for search (SharePoint Server 2010)
• Manage crawling (SharePoint Server 2010)
• Manage crawl load (SharePoint Server 2010)
• Add, edit, or delete a content source (SharePoint Server 2010)
• Manage crawl rules (SharePoint Server 2010)
• Start, pause, resume, or stop a crawl (SharePoint Server 2010)
• Add a file type to the content index (SharePoint Server 2010)
• Delete a file type from the content index (SharePoint Server 2010)
• Reset the content index (SharePoint Server 2010)
• Install connectors (SharePoint Server 2010)
• Manage deletion of index items (SharePoint Server 2010)
• Best practices for using crawl logs (SharePoint Server 2010)
• Use search administration reports (SharePoint Server 2010) >
• Manage queries and results (SharePoint Server 2010)
• Manage search scopes (SharePoint Server 2010)
• Manage federated locations (SharePoint Server 2010)
• Search the enterprise from Windows 7 (SharePoint Server 2010)
• Remove URLs from search results (SharePoint Server 2010)
• Manage query suggestions (SharePoint Server 2010)
• Manage settings to improve search results (SharePoint Server 2010)
• Manage stop word files (SharePoint Server 2010)
• Manage thesaurus files (SharePoint Server 2010)
• Create a custom dictionary (SharePoint Server 2010)
• Configure authoritative Web pages (SharePoint Server 2010)
• Manage metadata properties for search (SharePoint Server 2010)
• Manage people search (SharePoint Server 2010)
• User Profile service application overview (SharePoint Server 2010)
• Plan user profiles (SharePoint Server 2010)
• Plan for profile synchronization (SharePoint Server 2010)
• Create, edit, or delete a User Profile service application (SharePoint Server 2010)
• Assign administration of a User Profile service application (SharePoint Server 2010)
• Assign administration of User Profile service features (SharePoint Server 2010)
• Remove an administrator from a User Profile service application (SharePoint Server 2010)
• Add, edit, or delete custom properties for a user profile (SharePoint Server 2010)
• Manage audiences (SharePoint Server 2010)
• Manage profile synchronization (SharePoint Server 2010)
• Configure profile synchronization (SharePoint Server 2010)
• Configure profile synchronization using a Lightweight Directory Interchange Format (LDIF) file (SharePoint Server 2010)
• Start profile synchronization manually (SharePoint Server 2010)
• Schedule profile synchronization (SharePoint Server 2010)
• Maintain profile synchronization (SharePoint Server 2010)
• Configure a profile synchronization connection in SharePoint Server 2010 (video)
• Configure a synchronization connection to a SQL Server database in SharePoint Server 2010 (video)
• Manage My Sites settings (SharePoint Server 2010)
• My Sites overview (SharePoint Server 2010)
• Plan for My Sites (SharePoint Server 2010)
• Set up My Sites (SharePoint Server 2010)
• Create and manage a My Site host location (SharePoint Server 2010)
• Add or delete a trusted My Site host location (SharePoint Server 2010)
• Add or delete links to Office client applications (SharePoint Server 2010)
• Add or delete personalization site links on My Sites (SharePoint Server 2010)
• Resolve accounts across multiple forests (SharePoint Server 2010)
• Managing personal and social features (SharePoint Server 2010)
• >Social tagging overview (SharePoint Server 2010)
• Social tagging overview (SharePoint Server 2010)
• Enable or disable personal and social features for users or groups (SharePoint Server 2010)
• Activate or deactivate the SocialRibbonControl farm-level feature (SharePoint Server 2010)
• Delete notes and tags (SharePoint Server 2010)
• Monitor search (SharePoint Server 2010)
• Enable search alerts (SharePoint Server 2010)
• Enable query logging (SharePoint Server 2010)
• Configure the Secure Store Service (SharePoint Server 2010)
• Manage the State Service (SharePoint Server 2010)
• Visio Graphics Service administration (SharePoint Server 201 0)
• Create a Visio Graphics Service service application (SharePoint Server 2010)
• Delete a Visio Graphics Service service application (SharePoint Server 2010)
• List all Visio Graphics Service service applications (SharePoint Server 2010)
• Create a Visio Graphics Service service application proxy (SharePoint Server 2010)
• Delete a Visio Graphics Service service application proxy (SharePoint Server 2010)
• List all Visio Graphics Service service application proxies (SharePoint Server 2010)
• Configure Visio Graphics Service global settings (SharePoint Server 2010)
• Configuring Visio Graphics Service trusted data providers (SharePoint Server 2010)
• User Profile Service administration (SharePoint Server 2010)
• Assign administration of user profiles (SharePoint Server 2010)
• User Profile Replication Engine overview (SharePoint Server 2010)
• Configure policy settings on user profile properties and personal and social features (SharePoint Server 2010)
• Configure a service application by using a Windows PowerShell script (SharePoint Server 2010)
• Configure the security token service (SharePoint Server 2010)
• Content Migration
• Content Migration Overview
• Content Migration Tasks
• How to: Migrate a Web Site From One Location to Another
• Migrating Security Information
• Logging Content Migration Events
• Content Migration XML Schema Reference
• DeploymentManifest Schema
• DeploymentExportSettings Schema
• DeploymentLookupListMap Schema
• DeploymentRequirements Schema
• DeploymentRootObjectMap Schema
• DeploymentSystemData Schema
• DeploymentUserGroupMap Schema
• DeploymentViewFormsList Schema

Deployment overview (SharePoint Server 2010)

Multi Tenancy

• Enabling Multi Tenant Support in SharePoint 2010
• Multi Tenancy in SharePoint 2010 Part 2
• Multi Tenancy in SharePoint 2010 Part 3

Evaluation guide for SharePoint Server 2010 (white paper)

Farm topology management (SharePoint Server 2010)

• Add a Web or application server to the farm (SharePoint Server 2010)
• Add a database server to an existing farm (SharePoint Server 2010)
• Remove a server from the farm (SharePoint Server 2010)
• Rename a stand-alone server (SharePoint Server 2010) 
• Manage search topology (SharePoint Server 2010) 
• Search topology operations in SharePoint Server 2010 (white paper)
• Add or remove an index partition
• Add or remove a query component
• Add or remove a crawl database
• Add or remove a crawl component
• Add or remove a property database
• Add or remove a host distribution rule
• Automating Microsoft SharePoint 2010 with Windows PowerShell 2.0 (book excerpt) 

Fundamental site planning (SharePoint Server 2010) 

• Sites and site collections overview (SharePoint Server 2010)
• Plan sites and site collections (SharePoint Server 2010)
• Site navigation overview (SharePoint Server 2010)
• Plan site navigation (SharePoint Server 2010)
• Themes overview (SharePoint Server 2010)
• Plan for using themes (SharePoint Server 2010)
• Plan for multilingual sites (SharePoint Server 2010)
• Multilingual user interface overview (SharePoint Server 2010)
• Plan for the multilingual user interface (SharePoint Server 2010)

Logical architecture components (SharePoint Server 2010)

Manage farm administration settings (SharePoint Server 2010)

• Configure diagnostic logging (SharePoint Server 2010)
• E-mail integration (SharePoint Server 2010) 
• Configure incoming e-mail (SharePoint Server 2010) 
• Configure outgoing e-mail (SharePoint Server 2010) 
• Configure a mobile account (SharePoint Server 2010)
• Change the default content access account (SharePoint Server 2010) 
• Change the Central Administration Web site port number (SharePoint Server 2010) 

Managing privacy (SharePoint Server 2010)

Multi-Tenancy in SharePoint 2010 

Office Web Apps (Installed on SharePoint 2010 Products)

• Office Web Apps overview (Installed on SharePoint 2010 Products)
• Plan Office Web Apps (Installed on SharePoint 2010 Products)
• Deploy Office Web Apps (Installed on SharePoint 2010 Products)
• PowerPoint Broadcast Slide Show
• Understanding Broadcast Slide Show (Office Web Apps)
• Planning Broadcast Slide Show (Office Web Apps)
• Configure a Broadcast site (Office Web Apps)
• Configure Broadcast Slide Show performance (Office Web Apps)
• Configure Group Policy settings (Broadcast Slide Show)
• Manage Office Web Apps (Installed on SharePoint 2010 Products)
• Activate the Office Web Apps Feature on site collections
• Manage the Office Web Apps cache
• Configure the default open behavior for browser-enabled documents (Office Web Apps)
• Configure PowerPoint service application settings
• Configure Word Viewing service settings
• Configure Excel Services Application settings (Office Web Apps)

Plan alternate access mappings (Windows SharePoint Services)

Plan for collaboration sites (SharePoint Foundation 2010)

Plan for server farms and environments (SharePoint Server 2010)

• System requirements (SharePoint Server 2010)
• Hardware and software requirements (SharePoint Server 2010)
• Plan browser support (SharePoint Server 2010)
• URL path length restrictions (SharePoint Server 2010) 
• IP support (SharePoint Server 2010)
• Windows Server 2008 R2 and SharePoint Server 2010: Better Together (white paper)
• SQL Server 2008 R2 and SharePoint 2010 Products: Better Together (white paper) (SharePoint Server 2010)
• Business Productivity at Its Best: Microsoft Office 2010 and SharePoint Server 2010 Better Together (white paper) 
• Services architecture planning (SharePoint Server 2010) 
• Hosted environments (SharePoint Server 2010) 
• Model: Hosting architectures for SharePoint Server 2010 
• White paper: SharePoint 2010 for hosters (SharePoint Server 2010) 
• Virtualization planning (SharePoint Server 2010)
• Virtualization support and licensing (SharePoint Server 2010) 
• Hyper-V virtualization requirements (SharePoint Server 2010) 
• Plan virtual architectures (SharePoint Server 2010)
• Plan for virtualization (SharePoint Server 2010)
• Capacity management and high availability in a virtual environment (SharePoint Server 2010)
• SharePoint 2010 Virtualization Guidance and Recommendations (white paper)
• Plan authentication (SharePoint Server 2010) 
• Plan authentication methods (SharePoint Server 2010) 
• Plan the Secure Store Service (SharePoint Server 2010) 
• People Picker and claims provider planning (SharePoint Server 2010) 
• People Picker overview (SharePoint Server 2010)
• Custom claims providers for People Picker (SharePoint Server 2010) 
• Plan for Kerberos authentication (SharePoint Server 2010)
• Claims-based authentication with Microsoft UAG 2010 (SharePoint Server 2010)
• Microsoft IT implements a custom claims provider (case study)
• Implementing Claims-Based Authentication with SharePoint Server 2010 (whitepaper)
• Security planning for server farms (SharePoint Server 2010)
• Plan administrative tasks in a least-privilege environment (SharePoint Server 2010)
• Plan for administrative and service accounts (SharePoint Server 2010)
• Plan security hardening (SharePoint Server 2010)
• Plan automatic password change (SharePoint Server 2010)
• Plan security hardening for extranet environments (SharePoint Server 2010)
• Plan for host-named site collections (SharePoint Server 2010)
• Performance and capacity management (SharePoint Server 2010)
• Capacity management and sizing overview for SharePoint Server 2010
• Capacity planning for SharePoint Server 2010 
• Monitoring and maintaining SharePoint Server 2010
• Performance testing for SharePoint Server 2010
• SharePoint Server 2010 capacity management: Software boundaries and limits 
• Performance and capacity technical case studies (SharePoint Server 2010)
• Enterprise intranet publishing environment technical case study (SharePoint Server 2010)
• Enterprise intranet collaboration environment technical case study (SharePoint Server 2010)
• Enterprise intranet collaboration environment lab study (SharePoint Server 2010)
• Departmental collaboration environment technical case study (SharePoint Server 2010)
• Divisional portal environment lab study (SharePoint Server 2010)
• Social environment technical case study (SharePoint Server 2010)
• Microsoft SharePoint Server 2010 social environment: Lab study
• Performance and capacity test results and recommendations (SharePoint Server 2010)
• Storage and SQL Server capacity planning and configuration (SharePoint Server 2010)
• SQL Server and storage (SharePoint Server 2010) 
• Overview of SQL Server in a SharePoint environment (SharePoint Server 2010)
• Storage and SQL Server capacity planning and configuration (SharePoint Server 2010)
• Overview of RBS (SharePoint Server 2010)
• Plan for RBS (SharePoint Server 2010)
• Remote BLOB Storage in SharePoint Server 2010 (video) 
• Plan for business continuity management (SharePoint Server 2010) 

Plan for sites and solutions (SharePoint Server 2010)

• Planning for sites and solutions, Part1
• Planning for sites and solutions, Part 2

Plan site creation and maintenance (SharePoint Server 2010)

• Plan process for creating sites (SharePoint Server 2010)
• Plan site maintenance and management (SharePoint Server 2010)
• Plan quota management (SharePoint Server 2010)
• Reporting and usage analysis overview (SharePoint Server 2010) 

Planning and Leveraging SharePoint 2010 Service Applications 

Sandboxed solutions planning (SharePoint Foundation 2010) 

• Sandboxed solutions overview (SharePoint Foundation 2010)
• Plan sandboxed solutions (SharePoint Foundation 2010) 

Server and server farm administration (SharePoint Server 2010) 

• Backup and recovery (SharePoint Server 2010) 
• Prepare to back up and recover (SharePoint Server 2010)
• Backup and recovery best practices (SharePoint Server 2010) 
• Configuring permissions for backup and recovery (SharePoint Server 2010)
• Backup (SharePoint Server 2010)
• Recovery (SharePoint Server 2010)
• Restore pre-SP1 backups to an SP1 farm (SharePoint Server 2010)
• Database management (SharePoint Server 2010)
• Add a content database (SharePoint Server 2010)
• Attach or detach content databases (SharePoint Server 2010)
• Move site collections between databases (SharePoint Server 2010)
• Move content databases (SharePoint Server 2010).
• Rename or move service application databases (SharePoint Server 2010)
• Move all databases (SharePoint Server 2010)
• Scale out collaboration sites (SharePoint Server 2010)
• Run a farm that uses read-only databases (SharePoint Server 2010)
• Managing Multi-Terabyte Content Databases with SharePoint 2010 (white paper)
• Database maintenance for SharePoint Server 2010 
• Manage RBS (SharePoint Server 2010)
• Security and permissions (SharePoint Server 2010) 
• Configure custom permissions (SharePoint Server 2010)
• Change passwords used for administration accounts (SharePoint Server 2010)
• Configure automatic password change (SharePoint Server 2010)
• Configure automatic password change (SharePoint Server 2010)
• Change passwords for SQL Server services (SharePoint Server 2010)
• Change the password for the default content access account (SharePoint Server 2010)
• Configure People Picker (SharePoint Server 2010)
• Allow or prevent Contributors ability to edit scriptable Web Parts (SharePoint Server 2010) 
• How to configure AD FS v 2.0 in SharePoint Server 2010
• Service application and service management (SharePoint Server 2010)
• About service applications and services (SharePoint Server 2010)
• Manage service applications (SharePoint Server 2010)
• Manage services on the server (SharePoint Server 2010) 
• Web applications management (SharePoint Server 2010) 
• Create a Web application (SharePoint Server 2010) 
• Configure settings for a Web application (SharePoint Server 2010) 
• Cache settings operations (SharePoint Server 2010) 
• Extend a Web application (SharePoint Server 2010) 
• Unextend a Web application (SharePoint Server 2010) 
• Delete a Web application (SharePoint Server 2010) 
• View site collections in a Web application (SharePoint Server 2010) 
• Manage permissions for a Web application (SharePoint Server 2010) 
• Manage permission policies for a Web application (SharePoint Server 2010) 
• Health monitoring (SharePoint Server 2010)
• Monitoring overview (SharePoint Server 2010) 
• Configuring monitoring (SharePoint Server 2010) 
• Configure diagnostic logging (SharePoint Server 2010) 
• Configure usage and health data collection (SharePoint Server 2010) 
• Configure SharePoint Health Analyzer rules (SharePoint Server 2010)
• Configure SharePoint Health Analyzer timer jobs (SharePoint Server 2010) 
• Viewing reports and logs (SharePoint Server 2010) 
• View health reports (SharePoint Server 2010) 
• View Web Analytics reports (SharePoint Server 2010) 
• View diagnostic logs (SharePoint Server 2010) 
• View administrative reports (SharePoint Server 2010) 
• View timer job status (SharePoint Server 2010) 
• Monitor cache performance (SharePoint Server 2010) 
• Solving problems and troubleshooting (SharePoint Server 2010) 
• Viewing and resolving SharePoint Health Analyzer alerts (SharePoint Server 2010)
• Update alerts by using Windows PowerShell (SharePoint Server 2010) 
• Monitor health and performance of a virtual environment (SharePoint Server 2010) 
• Hyper-V performance FAQ R2
• Monitoring Hyper-V performance
• Hyper-V performance comparison: Microsoft Windows Server 2008 SP2 and R2 with Intel Xeon processor X5570- and E5450-based servers
• Windows Server 2008 R2 Virtual Hard Disk (VHD) Performance Paper
• Windows Server Performance Team Blog: Increase VMBus buffer sizes to increase network throughput to guest VMs
• Microsoft Hyper-V 2008 R2 IDE vs. SCSI Performance
• Benchmarking Hyper-V on Windows Server 2008 R2 x64
• Henk's tech blog: Archive for the 'SQL 2008 R2' Category

• Farm topology management (SharePoint Server 2010) 
• Add a Web or application server to the farm (SharePoint Server 2010) 
• Add a database server to an existing farm (SharePoint Server 2010) 
• Remove a server from the farm (SharePoint Server 2010) 
• Rename a stand-alone server (SharePoint Server 2010) 
• Manage search topology (SharePoint Server 2010)
• Search topology operations in SharePoint Server 2010 (white paper)
• Add or remove an index partition 
• Add or remove a query component 
• Add or remove a crawl database 
• Add or remove a crawl component 
• Add or remove a property database 
• Add or remove a host distribution rule 
• Availability configuration (SharePoint Server 2010)
• Configure availability by using SQL Server clustering (SharePoint Server 2010)
• Getting Started with SQL Server 2008 Failover Clustering
• Getting Started with SQL Server 2008 Failover Clustering
• Installing a SQL Server 2008 Failover Cluster
• Configure availability by using SQL Server database mirroring (SharePoint Server 2010)
• Sample script for configuring SQL Server database mirroring (SharePoint Server 2010)
• Track or block SharePoint Server 2010 installations 

Service application and service management (SharePoint Server 2010) ONLY focus on BI and Profile services

• About service applications and services (SharePoint Server 2010) 
• Manage service applications (SharePoint Server 2010) 
• Manage services on the server (SharePoint Server 2010) 

Share service applications across farms (SharePoint Server 2010) 

SharePoint Online Overview

Site and site collection administration (SharePoint Server 2010) 

• Manage site collections (SharePoint Server 2010) 
• Create a site collection (SharePoint Server 2010) 
• Delete a site collection (SharePoint Server 2010) 
• Restore a deleted site collection (SharePoint Server 2010)
• Configure a connection to a portal site (SharePoint Server 2010) 
• Manage a connection to a document repository or a records center (SharePoint Server 2010) 
• Manage site collection storage limits (SharePoint Server 2010) 
• Manage blocked file types (SharePoint Server 2010) 
• Add or remove site collection administrators (SharePoint Server 2010) 
• Create, edit, and delete quota templates (SharePoint Server 2010) 
• Lock or unlock site collections (SharePoint Server 2010) 
• View all site collections (SharePoint Server 2010) 
• Manage sites (SharePoint Server 2010) 
• Manage unused Web sites (SharePoint Server 2010) 
• Restore a deleted site (SharePoint Server 2010)
• Configure Web Analytics service application (SharePoint Server 2010) 
• Manage Web Parts (SharePoint Server 2010) 

Site and solution administration (SharePoint Server 2010) 

• Sandboxed solutions administration (SharePoint Server 2010) 
• Enable sandboxed solutions on the farm (SharePoint Server 2010) 
• Configure load balancing for sandboxed solutions (SharePoint Server 2010) 
• Block or unblock a sandboxed solution (SharePoint Server 2010) 
• Configure sandboxed solutions service tiers (SharePoint Server 2010)
• Configure resource points for sandboxed solutions (SharePoint Server 2010) 
• Document management administration (SharePoint Server 2010) 
• Co-authoring administration (SharePoint Server 2010) 
• Configure versioning for co-authoring (SharePoint Server 2010)
• Configure versioning for co-authoring (SharePoint Server 2010)
• Configure the co-authoring versioning period (SharePoint Server 2010)
• Configure the maximum number of co-authoring authors (SharePoint Server 2010)
• Disable co-authoring (SharePoint Server 2010)
• Configure Information Rights Management (SharePoint Server 2010)
• Content deployment administration (SharePoint Server 2010) 
• Configure content deployment settings
• Manage content deployment paths and jobs
• Manage Quick Deploy jobs
• View content deployment job reports and history 
• Workflow administration (SharePoint Server 2010)
• Manage workflows (SharePoint Server 2010)
• Monitor workflows (SharePoint Server 2010)
• Configure global workflow settings (SharePoint Server 2010)
• Enable or disable declarative workflows (SharePoint Server 2010)
• Allow non-authenticated users to participate in workflows (SharePoint Server 2010)
• Disable preservation of workflow history (SharePoint Server 2010)
• Deploy a workflow as a WSP file (SharePoint Server 2010)
• An end-to-end process using InfoPath 2010 forms, Visio 2010, and SharePoint Designer 2010 for workflows
• Create reusable workflows using SharePoint Designer 2010 and attach to content types
• Create a site workflow and modify its form using InfoPath Forms 2010
• InfoPath forms administration (SharePoint Server 2010) 
• Configure InfoPath Forms Services (SharePoint Server 2010) 
• Manage administrator-approved form templates (SharePoint Server 2010) 
• Manage data connection files for InfoPath Forms Services (SharePoint Server 2010) 
• Configure Web service proxy for InfoPath Forms Services (SharePoint Server 2010) 
• Create an Enterprise wiki (SharePoint Server 2010) 
• Enterprise wiki planning (SharePoint Server 2010)
• Managed metadata service application overview (SharePoint Server 2010)
• Web content management operations (SharePoint Server 2010) 
• Manage document conversions (SharePoint Server 2010) 
• Configure Document Conversions Load Balancer and Launcher Services (SharePoint Server 2010) 
• Enable document converters for a Web application 
• Variations management 
• Use the variationsfixuptool operation (SharePoint Server 2010)
• Manage automatic propagation of variation pages
• Mobile administration (SharePoint Server 2010) 
• Configure mobile views (SharePoint Server 2010) 
• Configure external access for mobile devices (SharePoint Server 2010)
• SharePoint workspace administration (SharePoint Server 2010)
• Deploy a client tool for taking SharePoint content offline (video)

Site and solution governance (SharePoint Server 2010) 

• Governance overview (SharePoint Server 2010) 
• Governance features (SharePoint Server 2010) 
• Establishing and governing a SharePoint service (SharePoint Server 2010) 
• Implementing and governing information architecture (SharePoint Server 2010) 
• SharePoint Development and Governance Using COBIT 4.1: A Practical Approach (book excerpt)
• Introduction (SharePoint Development and Governance Using COBIT 4.1)
• Introduction (SharePoint Development and Governance Using COBIT 4.1)
• COBIT and SharePoint
• SharePoint Governance--Scope Phase
• SharePoint in the Cloud (SharePoint Development and Governance Using COBIT 4.1)
• SharePoint 2010 Governance Planning (white paper) 
• Implementing Governance in SharePoint 2010 (white paper) 

Understanding SharePoint 2010 Topology

Resource Center - Governance in SharePoint Server 2010  

Business Connectivity Services

• BCS PowerShell: Introduction and Throttle Management
• BDCMetadata Schema
• BusinessConnectivity Services in SharePoint 2010 and Office 2010
• Consuming External Data with Business Connectivity Services in SharePoint 2010
• Creating a Business Data Connectivity Model
• Deploying BCS Simple Solutions
• Designing a Business Data Connectivity Model
• Differences Between Using the .NET Assembly Connector and Writing a Custom Connector
• HOW TO: Create a Searchable SharePoint 2010 BDC .NET Assembly Connector Which Reads From A Flat File
• HOW TO: Programmatically create a SharePoint 2010 External Content Type
• HOW TO: Registeran External Content Type with the SharePoint Search Service to make the data searchable
• Integrating Business Data into SharePoint
• Microsoft Business Connectivity Services
• Business Connectivity Services Overview
• Business Connectivity Services Fundamentals
• What Is Included in Business Connectivity Services?
• Understanding Business Connectivity Services
• Building Solutions with Business Connectivity Services
• Business Connectivity Services: How-tos and Walkthroughs
• Business Connectivity Services: Sample XML and Code Examples
• Business Connectivity Services Programmer's Reference
• Business Connectivity Services Class Libraries
• Business Connectivity Services: FAQ
• Microsoft Business Connectivity Services Model
• Plan for Business Connectivity Services (SharePoint Server 2010)
• Business Connectivity Services overview (SharePoint Server 2010)
• Business Connectivity Services security overview (SharePoint Server 2010)
• Business Data Connectivity service administration overview (SharePoint Server 2010)
• Plan Business Connectivity Services client integration (SharePoint Server 2010)
• Monitoring and Diagnostic logging in Business Connectivity Services overview (SharePoint Server 2010)
• Plan to upgrade to Business Connectivity Services (SharePoint Server 2010)
• Resource Center-Business Connectivity Services in SharePoint Server 2010
• Working with Complex Data Types in Business Connectivity Services

Business Continuity Management

• Business Continuity Management Features in SharePoint 2010 
• Data Protection and Recovery 
• Backing Up and Restoring
• Overview of Backing Up and Restoring Data in SharePoint Foundation
• Programming with the SharePoint Foundation Backup/Restore Object Model
• SharePoint Foundation and the Volume Shadow Copy Service
• Overview of SharePoint Foundation and the Volume Shadow Copy Service
• SharePoint Foundation VSS Writer
• VSS Requestors and SharePoint Foundation
• Creating a VSS Requestor for Use with SharePoint Foundation
• Using a VSS Requestor with SharePoint Foundation
• How to: Back Up While the Web Application Is Still Running
• Fine-grained Data Restoration from Unattached Database
• Programmatic Administration of Database Mirroring and Failover
• Programmatic Administration of Database Snapshots
• Database Mirroring Overview 
• Getting Started: Backups 
• High Availability Solutions Overview 
• Log Shipping Overview 
• Optimize TempDB performance 
• Plan for availability (SharePoint Server 2010) 
• Plan for backup and recovery (SharePoint Server 2010) 
• Plan for business continuity management (SharePoint Server 2010) 
• Plan to protect content by using recycle bins and versioning (SharePoint Server 2010)
• Recovery (SharePoint Server 2010) 
• Resource Center-Business Continuity Management for SharePoint Server 2010
• Selecting a High Availability Solution 

Business Intelligence

• Business Intelligence Features in SharePoint 2010 (video) 
• Business intelligence planning 
• Choose the right business intelligence technology to suit your style (white paper) 
• Creating Custom BI Solutions with PerformancePoint Services 
• Creating Custom Solutions with Excel Services 
• Excel Services 2010 Overview 
• Excel Services administration (SharePoint Server 2010) 
• Excel Services User-Defined Functions 
• Exposing Business Intelligence with SharePoint 2010 (video) 
• Hardware and Software Requirements (PowerPivot for SharePoint) 
• PerformancePoint Services administration
• Plan for PerformancePoint Services (SharePoint Server 2010) 
• Plan for Visio Services (SharePoint Server 2010) 
• PowerPivot for SharePoint (MSDN) 
• PowerPivot for SharePoint (TechNet) 
• PowerPivot Concepts
• Reporting Services with SharePoint Integration 
• Resource Center-Business Intelligence in SharePoint Server 2010 
• Visio Graphics Service administration (SharePoint Server 2010) 

Capacity Management

• Capacity management and sizing for SharePoint Server 2010  
• Resource Center-Capacity Management for SharePoint Server 2010

Enterprise Application Development

• Accessing SharePoint 2010 Lists Using LINQ to SharePoint (Video)
• Application Lifecycle Management in SharePoint 2010 (Video)
• Best Practices with SharePoint Foundation
• Conceptual Overview of SharePoint Foundation
• Creating Sandboxed Solutions (Video)
• Deploy customizations - overview (SharePoint Server 2010)
• Developing, Deploying, and Monitoring Sandboxed Solutions in SharePoint 2010
• Enterprise Development with SharePoint Server
• Essential SharePoint Programming Tasks
• Feature Framework and Solution Deployment Improvements (video)
• Feature Schema
• Get Started Developing on SharePoint 2010(video)
• IT Pro Tools for Customizing SharePoint 2010(video)
• List Enhancements and Customizations in SharePoint 2010(video)
• Managing Data with LINQ to SharePoint 
• Managing SharePoint 2010 Customizations for the IT Pro (video) 
• Packaging and Deployment 
• patterns & practices SharePoint Guidance(labs)
• Redeploying Customizations and Solutions in SharePoint Foundation 2010 and SharePoint Server 2010
• Services Architecture and Extensibility(video)
• Setting Up the Development Environment for SharePoint 2010 on Windows Vista, Windows 7, and Windows Server 2008
• SharePoint 2010 Advanced Developer Training(video)
• SharePoint 2010 Development Platform Overview(video)
• SharePoint Foundation 2010 General Reference
• SharePoint Server Developer Center
• SharePoint in the MSDN Library
• SharePoint Foundation Building Blocks
• SharePoint Foundation Development In Depth 
• SharePoint Foundation Development Tools 
• SharePoint Server 2010 General Reference(SDK)
• Site Types: WebTemplates and Site Definitions 
• Solution Schema 
• User Interface Improvements and Extensibility in SharePoint 2010(video)
• Using the Client Object Model and REST to Access SharePoint 2010(video)
• Visual Studio 2010 SharePoint Developer Tools Overview(video)

Enterprise Content Management

• Customizing Enterprise Content Management in SharePoint 2010(video) 
• Document Management Capabilities and Features in SharePoint 2010(video) 
• Document management planning (SharePoint Foundation 2010) 
• Enterprise Content Management
• Enterprise Content Management in SharePoint 2010(video) 
• Enterprise content management planning (SharePoint Server 2010) 
• Governing Content Types, Policies, and Taxonomy Services in SharePoint 2010(video)
• Managed metadata administration (SharePoint Server 2010) 
• Plan managed metadata (SharePoint Server 2010) 
• Records Management in SharePoint 2010(video) 
• Resource Center - Enterprise Content Management in Microsoft SharePoint Server 2010
• Resource Center-Enterprise Collaboration in SharePoint Server 2010 
• Resource Center-Records Management in SharePoint Server 2010 
• SharePoint Document Management 

Enterprise Search

• Developing Custom Search Solutions with SharePoint 2010 
• Enterprise search administration (SharePoint Server 2010) 
• FAST Protocol Documentation http://msdn.microsoft.com/en-us/library/ee629339.aspx
• Planning and architecture (FAST Search Server 2010 for SharePoint) 
• Resource Center-Enterprise Search in Microsoft SharePoint Server 2010
• Search Capabilities and Features in SharePoint 2010 
• Searching New Content in SharePoint Server Search 
• SharePoint Enterprise Search 
• Working with federation (Search Server 2008) 

Forms

• InfoPath forms administration (SharePoint Server 2010) 
• InfoPath Forms Services 
• Plan InfoPath Forms Services (SharePoint Server 2010) 

Monitoring & Operations

• Deployment scenarios (SharePoint Server 2010) 
• Initial configuration (SharePoint Server 2010) 
• Prepare for deployment (SharePoint Server 2010) 
• Resource Center-Installation and Deployment for Microsoft SharePoint Server 2010
• Windows PowerShell in the SharePoint Management Shell 
• Timer job reference (SharePoint Server 2010) 
• Windows PowerShell for SharePoint Server 2010 reference 
• Mastering PowerShell 
• Effective Windows PowerShell 

Performance Testing & Tuning

• Cache settings operations (SharePoint Server 2010) 
• Handling Large Folders and Lists 
• Health and Performance 
• Measuring .NET Application Performance 
• Plan for caching and performance (SharePoint Server 2010) 
• SharePoint Logging For Developers 
• Testing .NET Application Performance 
• Tuning .NET Application Performance 
• Working with Large Lists in Office SharePoint Server 2007 
• Writing Efficient Code in SharePoint Server 

Profiles/Social

• Configure profile synchronization (SharePoint Server 2010) 
• Customizing My Sites and Social Features in SharePoint 2010 
• Plan for My Site Web sites (SharePoint Server 2010) 
• Plan for social computing and collaboration (SharePoint Server 2010) 
• Planning and Deploying SharePoint Server 2010 User Profiles for My Site Web Sites
• Resource Center-Social Computing in SharePoint Server 2010 
• User Profile Service administration (SharePoint Server 2010) 
• User Profiles and Social Data 
• Using Social Capabilities in SharePoint 2010 

Security

• Account permissions and security settings (SharePoint Server 2010) 
• Administrative and service accounts required for initial deployment (SharePoint Server 2010)
• Assign or remove administrators to a service application (SharePoint Server 2010)
• Claims How Tos 
• Configure claims authentication (SharePoint Server 2010) 
• Configure Kerberos authentication (SharePoint Server 2010)
• Configure the Secure Store Service (SharePoint Server 2010) 
• Configuring Kerberos Authentication for Microsoft SharePoint 2010 Products
• Information Rights Management in SharePoint Foundation 
• Manage Excel Services authentication 
• Manage permission policies for a Web application (SharePoint Server 2010)
• Plan authentication methods (SharePoint Server 2010) 
• Plan Excel Services authentication (SharePoint Server 2010) 
• Plan for PerformancePoint Services security (SharePoint Server 2010) 
• Plan security hardening (SharePoint Server 2010) 
• Plan the Secure Store Service (SharePoint Server 2010) 
• Plan Visio Services security (SharePoint Server 2010) 
• Restrict or enable access to a service application (SharePoint Server 2010)
• Security and permissions (SharePoint Server 2010) 
• Security and Protection (PowerPivot for SharePoint) 
• Security In SharePoint 2010 
• Security planning for sites and content (SharePoint Server 2010) 
• SharePoint Foundation Security 
• Using the New SharePoint 2010 Security Model - Part 1 
• Using the New SharePoint 2010 Security Model - Part 2 

Storage Planning & Maintenance

• Database management (SharePoint Server 2010) 
• Database types and descriptions (SharePoint Server 2010) 
• Databases used by SharePoint have fragmented indices 
• Manage Remote BLOB Storage (SharePoint Server 2010) 
• Plan for remote BLOB storage (RBS) (SharePoint Foundation 2010) 
• Reorganizing and Rebuilding Indexes 
• Resource Center - SQL Server and SharePoint Server 2010 Databases 
• SQL Server and storage (SharePoint Server 2010) 
• Storage and SQL Server capacity planning and configuration (SharePoint Server 2010)

Upgrades

• Implementing and Validating Upgrade Plans for SharePoint 2010
• Preparing to Upgrade to SharePoint 2010
• Resource Center-Upgrade and Migration for Microsoft SharePoint Server 2010
• SharePoint 2010 Upgrade Overview
• SharePoint Products and Technologies customization policy (white paper)
• Testing Upgraded SharePoint 2010 Solutions
• Upgrading Code from SharePoint Server 2007 to SharePoint Server 2010
• Upgrading to SharePoint Server 2010
• Using AAM URL redirection as part of the upgrade process (SharePoint Foundation 2010) (white paper)

Web Content Management

• Plan for large Pages libraries (SharePoint Server 2010)
• Plan Web content management (SharePoint Server 2010)
• Resource Center-Web Content Management in SharePoint Server 2010
• Web content management operations (SharePoint Server 2010)

Workflow

• Estimate Performance and Capacity Requirements for Workflow in SharePoint Server 2010
• Plan workflows (SharePoint Server 2010) 
• Workflow administration (SharePoint Server 2010) 
• Workflow Enhancements in SharePoint 2010 
• Workflows in SharePoint Foundation 

Source: http://www.dynamicevents.com/upload/MCM-MCA/MCM/SharePoint/MCMSharePointPre-Reads.pdf