Overview: Windows SharePoint Services 2.0 SP2 Beta in Windows Server 2003 R2

Here is a overview of the features planned for WSS 2.0 Service Pack 2 .
Some of the new features:
-Support for IP-bound virtual servers
-Kerberos enabled by default
-Support for advanced extranet configurations:
—>SSL Termination
—>Host Header Modification
—>Port Translation

Item-level backup/restore

One of the most asked questions concerning SharePoint is backup and
recovery. One step further is restoring individual files that users
have deleted off the site.
Here is a list of backup/restore options for individual documents:

“Add a Recycle Bin to Windows SharePoint Services for Easy Document
Recovery” from MSDN


Backup for Microsoft Office SharePoint Products and Technologies”

– from Mart
Muller’s Weblog
using .fwp files created by smigrate (I have not
tested this!)

– from Bryant
Likes’ Blog
inserting a trigger and new table into the SQL
database (Microsoft may not support you after doing this! So be

Check template used on a site (without programming)

If you would like to know what template a site is using (very useful
when you must move that site to another server; the same template will
need to be on the destination server), you can check in the content
database where that site resides.
-Open the database in SQL Enterprise Manager, and return all rows from
the ‘Webs’ table of the content database.
-Find the site using the ‘FullURL’ column; the template being used is
in the ‘WebTemplate’ column.
-You can match this number with the descriptions in the XML files
located in the C:\Program Files\Common Files\Microsoft Shared\web
server extensions\60\TEMPLATE\1033\XML folder.

Copying/Moving Site Definitions

I thought it would be helpful to have the locations of the files that
makeup a site definition on a SharePoint server.
Why post this: several times, I have had to copy/move site
definitions, that I did not develop, to other servers.
Things to note:
–> c:\…\ means c:\Program Files\Common Files\Microsoft Shared\web
server extensions\60\TEMPLATE–> Each language pack uses a different folder name (i.e. 1033 = English)

Site definitions can use style sheets located here:

The style sheets can use images located here:

The site definition folder is located here:

The site definition XML file is located here:

There may be some images used by the site definition here:

what a good sharepoint subject matter expert ought to know… [ANSWERS]

I also found a post on Prince
Joel’s Weblog
with someone’s answers (I am not sure who gave the
answer). However, there are some things I disagree with, but most of
it is correct when thinking of SharePoint when it comes

what a good sharepoint subject matter expert ought to know…

I found these questions on Tim Heuer’s Weblog

What SharePoint consultants Ought to Know

Everyone who can spell SharePoint

* what is SharePoint?
* what is the difference between SharePoint Portal Server and
Windows SharePoint Services?
* what is a document library?
* what is a meeting workspace?
* what is a document workspace?
* what is a web part?

Mid-level SharePoint Consultant

* what is the difference between a document library and a form library?
* what is a web part zone?
* how is security managed in SharePoint?
* how are web parts developed?
* what is a site definition?
* what is a template?
* how do you install web parts?
* what is the difference between a site and a web?
* what are the differences between web part page gallery, site
gallery, virtual server gallery and online gallery?
* what is the GAC?
* what is a DWP?
* what is CAML?
* what are themes?
* what is presence?
* can web parts be connected? if so, how?
* what is a personal view and what is a shared view?
* what is an STP file?
* what is an FWP file?
* can you upload MP3’s to SharePoint?
* how does SharePoint support MS Outlook integration?
* how can you extend lists in SharePoint?
* explain the document versioning in SharePoint document libraries

Senior SharePoint Consultant

* where are web part resources contained?
* what are the different installation methods for deploying web
parts? and what are the pros/cons?
* what is a ghosted/unghosted page?
* how is site data stored?
* where is metadata for a web stored?
* what is an audience and describe the use?
* what are the trust levels and what is the default trust
associated with SharePoint?
* what are the two logging mechanisms for usage statistics?
* what functionality does owssup.dll provide for client side activities?
* what is the difference between a site owner and a site administrator?
* what is STSAdm and what can it be used for?
* can WSS search subsites?
* can you register alerts for users?
* are PDFs searchable?

SharePoint Architect

* what is a SharePoint farm?
* describe a large deployment
* how can you synchronize custom Active Directory attributes to SharePoint?
* if it is anticipated that our organization would need to store 1
terrabyte of documents, what is the recommended configuration and
storage requirement?
* describe the implementation of SharePoint and Project Server
* what are the BKMs for workflow and SharePoint?
* explain how you would deploy SharePoint on an extranet
* what is the BKM for maximum number of virtual servers configured
for SharePoint on a single box?
* what are the migration strategies for moving sites around?
* what are the archiving strategies?
* describe the search strategies
* can you implement forms-based authentication with SharePoint?
* describe how single sign-on works