IT Professional Training for SharePoint 2010

If you are new to SharePoint 2010 or are upgrading from 2007, there are a variety of courses and formats to help you gain the skills and knowledge you need to ensure a successful deployment, upgrade, or migration.


Exam 70-667 TS: Microsoft SharePoint 2010, Configuring

This exam is intended to validate the configuration skills needed to administer a SharePoint 2010 installation.

Exam 70-668 TS: Microsoft SharePoint 2010, Administrator

This exam validates the skills needed to administer SharePoint 2010.

Instructor Led Courses

10174A: Configuring and Administering Microsoft SharePoint 2010

The course teaches students how to install, configure and administer SharePoint, and also manage and monitor sites and users by using SharePoint 2010.


70-667 MCTS: Microsoft SharePoint 2010, Configuring

This exam is intended to validate the configuration skills needed to administer a SharePoint 2010 installation.  Certification received Microsoft Certified Technology Specialist.

70-668 MCITP: Microsoft SharePoint Administrator 2010

This exam validates the skills needed to administer SharePoint 2010. Certification received Microsoft Certified IT Professional.


Clinic 10279: What’s New in Microsoft SharePoint 2010 for IT Professionals

This two-hour clinic describes the various benefits that Microsoft SharePoint 2010 offers IT Pros. It describes improvements to the user interface, including the ribbon and enhanced Central Administration console. It also describes features that help you monitor your SharePoint site, such as large list resource throttling, Unattached Content Database Recovery, and the SharePoint Health Analyzer.


For additional information on MCM for SharePoint 2010 certification see also

For additional information on upcoming courses, exams, and eLearning opportunities, see also


Getting Started Screencast Series

A series of entry-level screencasts by Microsoft SharePoint MVPs that lets you take advantage of an 11-module e-learning course at no cost! The course covers everything you should know as a new SharePoint IT Pro, from basic features and terminology to how to build and maintain a server farm and manage performance.

SharePoint 2010 Advanced IT Professional Training

Training to help experienced SharePoint IT Pros improve their skills and gain a deeper understanding of the product.

Learning Snack, Monitoring and Troubleshooting SharePoint 2010

Learning Snack that shows you just how easy it is to manage your SharePoint environment.

Windows Server 2008 R2 Enterprise Edition and SharePoint Server 2010 Better Together Whitepaper

A recently published whitepaper is now available on TechNet that describes the benefits of deploying Microsoft SharePoint Server 2010 on Microsoft Windows Server 2008 R2 Enterprise Edition and scenarios in which its features can be applied.


Microsoft® SharePoint® Server 2010 is the business collaboration platform for the enterprise and the Internet. SharePoint Server 2010 has become a business-critical application and an integral part of business processes. To help IT infrastructures to remain flexible and scalable to help support, manage, and secure expanded functionality, an influx of additional users and locations, and increasingly robust applications such as SharePoint Server 2010, we recommend that you choose the Windows Server® 2008 R2 Enterprise operating system during initial deployment.

Download the whitepaper today…

SharePoint Site Recycle Bin for SharePoint 2010

The SharePoint Site Recycle Bin for SharePoint 2010 is available for download at

The SharePoint Site Recycle Bin is a SharePoint Foundation 2010 solution package that when deployed to a Microsoft SharePoint Foundation 2010 or Microsoft SharePoint Server 2010 server farm enables administrators to create a snapshot of subscriptions, site collections and Webs as they are deleted through the SharePoint user interface, the SharePoint Administration Tool, the SharePoint 2010 Management Shell, SharePoint 2010 Central Administration, or SharePoint Designer.

Gradual Site Delete in SharePoint 2010

Overlooked often in SharePoint 2010 is the new Gradual Site Delete capability which was designed to mitigate unplanned site collection outages that occurred as the result of lock escalation in Windows SharePoint Server 3.0 and Office SharePoint Server 2007 when a large site collection was requested for deletion.  Before we describe Gradual Site Delete, we should understand the problem space from previous versions of the product.

In Windows SharePoint Services 3.0 and Office SharePoint Server 2007 two (2) independent stored procedures were called as a result of a request for site collection deletion, proc.DropSite which removed the dbo.SiteMap entry for the site collection from the configuration database, and proc.DeleteSite which removed the site collection and its content from its respective content database.

In Windows SharePoint Services 3.0 and Office SharePoint Server 2007 proc.DeleteSite stepped through all the of the tables in the content database corresponding to the Id of the site collection to be deleted, as a result there were roughly 35 tables touched as a part of the operation which occurred as a single homogenous operation.

Delete operations in SQL Server implement a lock on the deleted rows and if the number of rows that are to be deleted is more than a threshold (by default 5000), SQL Server in many cases may assume it is more efficient to escalate these row locks to table locks. Lock-escalation in this scenario freezes the whole table from other legitimate user requests and has the potential to result in performance degradation to the extent of server unresponsiveness.

In SharePoint 2010, mitigation occurs through a tiered process, Gradual Site Delete.  When a site collection is deleted, the site collection entry (pointer) in dbo.SiteMap is removed from the configuration database and from dbo.Sites in the corresponding content database. For all purposes of user access to the site collection Url or its content the site collection no longer exists and is inaccessible, or otherwise, the Url is no longer reserved.

The site collection deletion is then queued into a new table (dbo.SiteDeletion) in the hosting content database where it is marked to be gradually deleted.

At this point in the operation, a new Timer Job Definition [Gradual Site Delete] executes on a daily schedule [configurable], and will continuously attempt to delete all the data for all the site collections in its queue (dbo.SiteDeletion). It will delete the data in small enough batches of a maximum of 1000 rows through multiple transactions to avoid lock escalation, and can be resumed in the event any failure occurs so that it can attempt the delete process again if needed.  Once the site collection is fully deleted the dbo.SiteDeletion entry is removed.

Gradual Site Delete is a selectable operation when working with Windows PowerShell and/or the Object Model in which it can be implemented or bypassed.  See the resources below for additional information on how to access Gradual Delete through the the Object Model or Windows PowerShell.


SPSite.Delete Method (

Remove-SPSite (