SharePoint 2010 Development Platform Stack

Diagram below depicts how SharePoint Foundation is built on Microsoft .NET Framework 3.5, ASP.NET, and Internet Information Services (IIS). SharePoint is also built on SQL Server.

Patterns & Practices SharePoint 2010 & 2007 Guidance Resources

Microsoft has released Patterns & Practices on SharePoint Guidance that are designed to help solution developers and architects make the right decisions and follow proven practices when building applications for SharePoint. The following are useful resources that you might want to explore:

• MSDN SharePoint Guidance
• CodePlex SharePoint Guidance
• Walkthrough of the Contoso Reference Implementation
• Setting up the Contoso RI
• How to use the configuration component?
• How to use the logging components?
• How to use the SharePoint Service Locator?

SharePoint 2010 Official Site and Useful Blogs Worth Checking Out

A great starting place to understand more about SharePoint would be the MSDN SharePoint Developer Center:

• http://msdn.microsoft.com/en-us/sharepoint/default.aspx

You may also want to check out the MSDN Office Developer Center:

• http://msdn.microsoft.com/en-us/office/default.aspx

Also, Channel 9 offers a number of training kits that you can download and walk through, for both SharePoint and other Microsoft technologies. The Channel 9 Learning Center is located here:

• http://channel9.msdn.com/learn/

With just these three sites, you’ll find a ton of developer resources.

Lastly, following are a few blogs worth checking out. You’ll certainly find more, but these have proven to be useful and informative over the years:

• SharePoint Team at http://blogs.msdn.com/sharepoint
• Andrew Connell at www.andrewconnell.com/blog
• Arpan Shah at http://blogs.msdn.com/arpans
• Paul Stubb at http://blogs.msdn.com/pstubbs
• Paul Andrew at http://blogs.msdn.com/pandrew
• Scot Hillier at www.shillier.com/default.aspx
• Sahil Malik at http://blah.winsmarts.com
• Wouter van Vugt at http://blogs.code-counsel.net/Wouter/default.aspx
• Todd Baginski at www.toddbaginski.com/blog
• Tim Heuer at http://timheuer.com/blog
• Steve Fox at http://blogs.msdn.com/steve_fox

SharePoint Guidance 2010 Hands On Lab Has Been Released

SharePoint Guidance 2010 Hands On Lab has just been released to CodePlex: http://spg.codeplex.com/ 

It consist of six labs:

• Add and Remove Application Setting in Feature Receiver and Retrieve them in Web Part
• Add and Remove Application Setting in Console Application and Use Hierarchy of them in Web Part
• Add, Update, Remove, Search Application Setting in Sandbox
• Read Application Setting in Sand Box Solution with ConfigProxy
• Register SharePoint Logger in Feature Receiver and Use Logger in Web Part
• Register Service in Feature Receiver and Display Service Instance in Web Part

What Developers Must Know About HTML5 and IE9

Interesting article from MSDN: Internet Explorer 9 Beta Guide for Developers.

Malaysia SharePoint User Group (MySpug), Where Are You?

Today, I realise that MySpug (http://spugmalaysia.org) web site no longer exist – rather a sad news to all SharePoint end-users, IT pros and developers in Malaysia.

MySpug was launched in mid 2009 and surprisingly I knew nothing about their existence until today! That’s sound weird, eh? considering that I’ve been working around SharePoint since version 2001. My friend said they had organised quite a number of activities and talks in Malaysia (but I didn’t get any invitation *sigh* – why?? communication break down?? publicity??). I am not sure whether MySpug is still active though – I will have to find out.

Come on and Matthew Khaw and Patrick Yong!

Command To Start and Stop Windows Services For SharePoint

If you like me who prefer Windows 7 x64 as your SharePoint 2010 development environment, most probably the following batch files would be useful to start and stop Windows Services for SharePoint when required:

Start Windows Services For SharePoint

REM Start SharePoint 2010 Services : http://sharepointmalaya.blogspot.com

Echo Starting Services Required To Run SharePoint 2010

NET START MSSQL$SHAREPOINT
NET START IISADMIN
NET START W3SVC
NET START SPAdminV4
NET START SPTimerV4
NET START SPTraceV4
NET START SPUserCodeV4
NET START SPWriterV4
NET START OSearch14

pause

Stop Windows Services For SharePoint

REM Stop SharePoint 2010 Services : http://sharepointmalaya.blogspot.com

Echo Stoping Services Required To Run SharePoint 2010

NET STOP OSearch14
NET STOP SPWriterV4
NET STOP SPUserCodeV4
NET STOP SPTraceV4
NET STOP SPTimerV4
NET STOP SPAdminV4
NET STOP W3SVC
NET STOP IISADMIN
NET STOP MSSQL$SHAREPOINT

pause

SharePoint STSADM Backup and Restore Commands

The following are examples of different STSADM commands you can use to back up and restore various components of your SharePoint environment.

A full farm backup followed by a restore:

stsadm -o backup -url http://app01/ -directory \\app01\sharepointbackups -BackupMethod Full -Quiet
stsadm -o restore -url http://app01/ -filename \\app01\sharepointbackups –Overwrite

Back up and restore configuration information only:

stsadm -o backup -url http://app01 -directory \\app01\sharepointbackups -configurationonly -quiet
stsadm -o restore -url http://app01 -filename \\app01\sharepointbackups -configurationonly –quiet

Back up and restore a service application:

stsadm -o backup -directory \\app01\sharepointbackups -quiet -backupmethod full -item "Excel Services"
stsadm -o restore -directory \\app01\sharepointbackups -item "Excel Services" –quiet

Back up and restore a site collection:

stsadm -o backup -url http://app01/portalsitecollection -filename \\app01\SharePointBackups\portalsitecollection.bak -overwrite
stsadm -o restore -url http://app01/portalsitecollection -filename \\app01\SharePointBackups\portalsitecollection.bak –overwrite

Export and import a subsite, list, or library:

stsadm -o export –url http://app01/sites/contosoportal/Shared%20documents –filename \\app01\sharepointbackups\SD.bak -quiet -overwrite
stsadm -o import –url http://app01/sites/contosoportal/Shared%20documents –filename \\app01\sharepointbackups\SD.bak -quiet

See also example of performing a SharePoint 2010 Backup and Restore using Powershell.

SharePoint PowerShell Backup and Restore Commands

The following are examples of different SharePoint PowerShell commands you can use to back up and restore various components of your SharePoint environment.

A complete farm backup followed by a restore:

Backup-SPFarm –Directory \\App01\SharePointBackups -BackupMethod Full
Restore-SPFarm –Directory \\App01\SharePointBackups -RestoreMethod New

Back up and restore a service application:

Backup-SPFarm –Directory \\App01\SharePointBackups -BackupMethod Full –Item "Excel Services"
Restore-SPFarm –Directory \\App01\SharePointBackups -RestoreMethod New –Item "Excel Services"

Back up and restore farm configuration information only:

Backup-SPConfigurationDatabase –Directory \\App01\SharePointBackups
Restore-SPFarm –Directory \\App01\SharePointBackups –RestoreMethod Overwrite –ConfigurationOnly

Back up and restore your SharePoint content databases:

Backup-SPFarm –Directory \\App01\SharePointBackups -BackupMethod Full –Item ContosoPortal
Restore-SPFarm –Directory \\App01\SharePointBackups -RestoreMethod New –Item ContosoPortal

Back up and restore a site collection:

Backup-SPSite –Identity http://App01/Sites/ContosoPortal -Path \\App01\SharePointBackups\PortalSiteCollection.bak -Force
Restore-SPSite –Identity http://App01/Sites/ContosoPortal -Path \\App01\SharePointBackups\PortalSiteCollection.bak –Force

Export and import a subsite, list, or library:

Export-SPWeb –Identity http://App01/Sites/ContosoPortal/ -Path \\App01\SharePointBackups\SharedDocuments.bak -Itemurl "Shared Documents" -Force
Import-SPWeb –Identity http://App01/Sites/ContosoPortal/ -Path \\App01\SharePointBackups\SharedDocuments.bak –Force -IncludeUserSecurity

See also example of performing a SharePoint 2010 Farm Backup and Restore using STSADM.

My Useful SharePoint 2010 Resources

Understanding the Basics of Collaboration in SharePoint 2010

• Microsoft SharePoint Designer team blog at http://blogs.msdn.com/sharepointdesigner/
• “Gartner Predicts That by 2013, More Than 25 Percent of the Content That Workers See in a Day Will Be Dominated by Pictures, Video or Audio” at http://www.gartner.com/it/page.jsp?id=834213
• “SharePoint Formulas in Calculated Columns” at http://blogs.msdn.com/mcsnoiwb/archive/2008/05/04/sharepoint-formulas-in-calculated-columns.aspx
• “Changes in SharePoint Designer 2010” at http://technet.microsoft.com/en-us/library/cc179083.aspx
• “Creating Workflows with SharePoint Designer 2010” video at http://www.bing.com/videos/watch/video/getting-started-sharepoint-2010-creating-workflows-with-sharepoint-designer/10ts7flgd
• Office 2010 at http://www.microsoft.com/office/2010/en/default.aspx
• SharePoint 2010 Technologies Page at http://sharepoint2010.microsoft.com/Pages/default.aspx
• System requirements and what’s new in Microsoft SharePoint Foundation 2010 at http://technet.microsoft.com/en-us/sharepoint/ee263910.aspx#tab=1
• System requirements and what’s new in Microsoft SharePoint 2010 at: http://technet.microsoft.com/en-us/sharepoint/ee263917.aspx

Understanding the Architecture of SharePoint 2010

• SharePoint 2010 SDK at http://msdn.microsoft.com/en-us/library/ee557253(office.14).aspx
• “Microsoft in the Enterprise” guide at http://download.microsoft.com/download/B/8/8/B8804100-DA41-4771-BE70-FE878ED51AAB/2009-2010.MSFTintheEnterprise.ResourceGuide.11.09.pdf

Optimizing SQL Server for a SharePoint 2010 Implementation

• SQL Server 2005 features: http://www.microsoft.com/sqlserver/2005/en/us/top-30-features.aspx
• SQL Server 2008 features: http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx

Installing SharePoint 2010

• 64-bit edition of Windows Server 2008 R2 Standard, Enterprise, or Datacenter editions and WCF hotfix at http://go.microsoft.com/fwlink/?LinkID=166231
• 64-bit edition of Windows Server 2008 Standard, Enterprise, or Datacenter editions with Service Pack 2 (SP2) and the WCF hotfix at http://go.microsoft.com/fwlink/?LinkID=160770
• “SharePoint Server 2010 Hardware and Software Requirements” at http://technet.microsoft.com/en-us/library/cc262485(office.14).aspx#section4/
• KB article “How do I open the firewall port for SQL Server on Windows Server 2008?” at http://support.microsoft.com/kb/968872

Using Windows PowerShell to Perform and Automate Farm Administrative Tasks

• “SharePoint Automation Source Code” at http://stsadm.codeplex.com/
• “SharePoint Management, PowerShell scripts” at http://sharepointpsscripts.codeplex.com/
• “PowerShell SharePoint Provider” at http://www.codeplex.com/PSSharePoint/
• “What’s New in Windows PowerShell” at http://technet.microsoft.com/en-us/library/dd378784.aspx
• “Windows PowerShell” information at http://en.wikipedia.org/wiki/Windows_PowerShell
• “Scripting with Windows PowerShell” on the Microsoft TechNet Script Center at http://technet.microsoft.com/en-us/scriptcenter/dd742419.aspx
• Windows PowerShell bloggers at http://pipes.yahoo.com/powershell/englishbloggers
• “Windows PowerShell” free ebook at Microsoft at http://blogs.msdn.com/mapo/archive/2007/07/17/windows-powershell-free-ebook-at-microsoft.aspx
• “Mastering PowerShell,” by Dr. Tobias Weltner, a free eBook at http://blogs.msdn.com/powershell/archive/2009/07/17/free-powershell-v1-book-from-the-makers-of-powershell-plus.aspx
• Windows Management Framework (Windows PowerShell 2.0, WinRM 2.0, and BITS 4.0) at http://support.microsoft.com/default.aspx/kb/968929
• “Heading Off Malicious Code” at http://technet.microsoft.com/en-us/magazine/2008.01.powershell.aspx
• “ALLSigned: Signing Your PowerShell Scripts” blog post by Zach Rosenfield at http://sharepoint.microsoft.com/blogs/zach/Lists/Posts/Post.aspx?ID=53
• Remote Server Administration Tools (RSAT) is available at http://www.microsoft.com/downloads
• “What’s New in Group Policy” at http://technet.microsoft.com/en-us/library/dd367853.aspx
• Windows Server 2008 (R2) Blog by Kurt Roggen [BE]: http://trycatch.be/blogs/roggenk/archive/2009/06/08/installing-windows-7-rsat-unattended.aspx
• “PowerShell remoting between two workgroup machines” at http://blogs.msdn.com/wmi/archive/2009/07/24/powershell-remoting-between-two-workgroup-machines.aspx
• “Multi-Hop Support in WinRM” at http://msdn.microsoft.com/en-us/library/ee309365(VS.85).aspx

Organizing Information

• Mark Schneider’s SharePoint Taxonomy and Governance Blog at http://sharepointplan.com
• “SharePoint Survey: How Organizations are Staffing Their SharePoint Teams” at http://sharepoint.mindsharpblogs.com/Bill/archive/2010/03/06/SharePoint-Survey[coln]-How-Organizations-are-Staffing-Their-SharePoint-Teams.aspx
• Governance Resource Center for Microsoft Office SharePoint Server 2007 at http://technet.microsoft.com/en-us/office/sharepointserver/bb507202.aspx
• Dublin Core Metadata Initiative (DCMI) at http://www.dublincore.org
• Oline community for the Darwin Information Typing Architecture OASIS Standard at http://dita.xml.org
• Taxonomy Warehouse at http://taxonomywarehouse.com
• MIKE2.0, The Open Source Standard for Information Management, at http://mike2.openmethodology.org
• AIIM at http://www.aiim.org

Collaboration and Portals

• “Manage a wiki using SharePoint” at http://go.microsoft.com/fwlink/?LinkId=168889

Search Server 2010 and FAST Search: Architecture and Administration

• Microsoft Enterprise Search Blog at http://blogs.msdn.com/enterprisesearch
• “Create a custom dictionary (SharePoint Server 2010)” at http://technet.microsoft.com/en-us/library/cc263242.aspx
• “Microsoft SharePoint 2010 Indexing Connector for Documentum” at http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=32d0980a-4b9a-4b0d-868e-9be9c0d75435
• “Regular Expression Basic Syntax Reference” at http://www.regular-expressions.info/reference.html
• “Newly published content for FAST Search Server 2010 for SharePoint” at http://technet.microsoft.com/en-us/library/ff686963.aspx

Using Windows PowerShell to Manage Search Services and FAST Search

• “SP+PS 2010: PowerShell to Create a Service Application” at http://sharepoint.microsoft.com/blogs/zach/Lists/Posts/Post.aspx?ID=50
• “Supporting –WhatIf, –Confirm, –Verbose—in SCRIPTS!” at http://blogs.msdn.com/powershell/archive/2007/02/25/supporting-whatif-confirm-verbose-in-scripts.aspx

Customizing the Search Results and Search Center

• “Managed metadata input file format (SharePoint Server 2010)” at http://technet.microsoft.com/en-us/library/ee424396(office.14).aspx
• “Regular Expression Basic Syntax Reference” at http://www.regular-expressions.info/reference.html
• Expresso 3.0 at http://www.ultrapico.com/Expresso.htm

Administering Web Content Management and Publishing

• Microsoft SharePoint 2010 at http://sharepoint2010.microsoft.com
• IIS Media Services Readme with links to “Bit Rate Throttling” at http://go.microsoft.com/fwlink/?LinkId=131775

Securing Information

• “Access Control in Active Directory” at http://technet.microsoft.com/en-us/library/cc785913(WS.10).aspx
• “Add-SPShellAdmin” TechNet article at http://technet.microsoft.com/en-us/library/ff607596.aspx
• “Set permission to a published service application (SharePoint Foundation 2010)” at http://technet.microsoft.com/en-us/library/ff700210.aspx

Aggregating External Data Sources

• “Business Connectivity Services: Sample XML and Code Examples” at http://msdn.microsoft.com/en-us/library/ee559369(office.14).aspx
• “Business Connectivity Services security overview (SharePoint Server 2010)” at http://technet.microsoft.com/en-us/library/ee661743.aspx
• “Permissions in Business Connectivity Services” at http://blogs.msdn.com/bcs/archive/2009/11/24/permissions-in-business-connectivity-services.aspx
• “Duet Enterprise for Microsoft SharePoint and SAP” at http://blogs.msdn.com/bcs/archive/2009/11/24/duet-enterprise-for-microsoft-sharepoint-and-sap.aspx

Web Parts and Their Functionality in SharePoint 2010

• ULS Viewer down load at http://code.msdn.microsoft.com/ULSViewer
• RSS Advisory Board, RSS 2.0 Specification, at http://www.rssboard.org/rss-specification

Publishing SharePoint 2010 to Mobile Devices

• “Editing Domain-Based GPOs Using ADMX files” at http://technet.microsoft.com/en-us/library/cc748955(WS.10).aspx
• Forefront Unified Access Gateway (UAG) documentation at http://technet.microsoft.com/en-us/library/ff358694.aspx

Business Intelligence, Reporting Services, and PerformancePoint Services

• Microsoft SQL Server 2008 Reporting Services at http://www.microsoft.com/sqlserver/2008/en/us/reporting.aspx
• “Planning a Deployment Mode” at http://msdn.microsoft.com/en-us/library/bb326345.aspx
• “Reporting Services Log Files” at http://msdn.microsoft.com/en-us/library/ms157403.aspx
• “Configuration Files (Reporting Services)” at http://technet.microsoft.com/en-us/library/ms155866.aspx
• SQL Server 2008 R2 Reporting Services Add-in for SharePoint 2010 download at http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45&displaylang=en

Upgrading to SharePoint 2010

• “Migrate an Existing Server Farm to a 64-Bit Environment (Office SharePoint Server 2007)” at http://technet.microsoft.com/en-us/library/dd622865.aspx
• Migration and Upgrade Resource Center for Office SharePoint Server 2007 at http://go.microsoft.com/fwlink/?LinkID=104403
• “Migrate a stand-alone installation to a server farm installation (Office SharePoint Server 2007)” at http://technet.microsoft.com/en-us/library/cc262325.aspx