Bill Baer /bɛːr/

The Windows SharePoint Services 3.0 RTM Software Development Kit have been released to MSDN; for those looking for the Microsoft Office SharePoint Server 2007 Software Development Kit click here, each includes documentation, as well as code examples within the topics and contains the highest-priority documentation for developing on each platform. I’d be interested to hear what others are developing and how the information contained in the SDK’s contributed to that project.

USE SELECT DISTINCT t1.siteID,t2.webID, t2.title [accessLevel],t3.tp_login,CONVERT(DECIMAL(6,2),((CONVERT(DECIMAL,t4.diskUsed)/1024)/1024)) [diskUsed MB], t6.fullUrlFROM DBO.RoleAssignment t1 JOIN DBO.roles t2 ON t2.siteID = t1.siteID AND t2.roleID = t1.roleID AND t2.roleID = 1073741829 JOIN DBO.userInfo t3 ON t3.tp_siteID = t1.siteID AND t3.tp_id = t1.principalID JOIN DBO.sites t4 ON t4.[id] = t1.siteID JOIN DBO.perms t5 ON t5.siteID = t1.siteID AND t5.scopeID = t1.scopeID JOIN webs t6 ON t6.[id] = t5.webID

In a recent conversation with a colleague I was asked the differences between Windows SharePoint Services 2.0 and 3.0 incremental crawls and the availability of results and thought I would share and explain briefly the differences here: In Windows SharePoint Services 2.0 when an incremental crawl is run, SharePoint determines whether or not a document has changed and should therefore be included in the incremental crawl results. It does it by performing a hash of the document, if the hash is different between crawls, then so is the document and the document is readily; though, perhaps not immediately available to search results, but are available prior to any complete crawl being run successfully.

SharePoint WebCasts for December http://blogs.technet.com/eileen_brown/archive/2006/11/21/sharepoint-webcasts-for-december.aspx

40 Application Templates are current under development for Windows SharePoint Services 3.0 and the interest has substantially increased following the product release, particularly to microsoft.com. Many of the templates will be familiar from previous versions of Windows SharePoint Services to include Help Desk, Project Site, Knowledge Base, etc.; however, will incorporate features in the latest version of Windows SharePoint Services, I.e. workflow, mail enabled lists, etc. The new templates as released will be available with 20 productivity templates for installation (UI) by site administrators, available only in English and 20 server administration templates for installation by server administers available in English, French, Italian, German, Spanish, Portuguese, Japanese, Chinese Simplified, Chinese Traditional, Korean, and Hebrew.

A short, but exciting post - Windows SharePoint Services 3.0 is now available to users of Windows Server 2003! For information and download availability visit http://www.microsoft.com/technet/windowsserver/sharepoint/download.mspx. Microsoft Windows SharePoint Services is a versatile technology that organizations and business units of all sizes can use to increase the efficiency of business processes and improve team productivity. With tools for collaboration that help people stay connected across organizational and geographic boundaries, Windows SharePoint Services gives people access to information they need.

Technical Library Product Overview Discover what’s new in Windows SharePoint Services 3.0 and locate product information. Help & How-to Get help and answers to frequently asked questions and common scenarios. Planning & Architecture Get planning and architecture information for implementing Windows SharePoint Services 3.0 in your own environment. Development Find SDK’s, screencasts, and blogs. Deployment & Upgrade Guides Find installation and configuration resources to include recommended topologies and scenarios. Operations

Microsoft Office SharePoint Server 2007 does not allow more than one connection to a domain; if you’d like to configure a custom import, such as a specific user filter (&(objectCategory=Person)(objectClass=User)), you can create a single connection with the common search base (DC=foo,DC=bar) and add a more restricted user filter to limit the users imported.

Technical Library Product Overview Discover what’s new in Microsoft Office SharePoint Server 2007 and locate product information. Help & How-to Get help and answers to frequently asked questions and common scenarios. Resource Kit Resource kit for Microsoft Office SharePoint Server 2007 Supplemental Documentation Download supplementation documentation for Microsoft Office SharePoint Server 2007. Planning & Architecture Get planning and architecture information for implementing Microsoft Office SharePoint Server 2007 in your own environment.

The attached SQL scripts are intended as sample scripts and may require some modification to suit your individual environments; however, serve as a foundation and guidance in SQL scripting under Windows SharePoint Services 3.0. Retrieve active Content Databases from a WSS 3.0 Configuration Database Returns a list of all active Content Databases in the Windows SharePoint Services Configuration Database. USE <WSS_3.0_Configuration_Database> SELECT DISTINCT SiteMap.DatabaseId, Objects.Name FROM SiteMap INNER JOIN Objects