Grounding.co.za

Technology information for IT specialists
Welcome to Grounding.co.za Sign in | Join | Help
in Search

Neil's IW Space

Information Worker Blog's by Neil van Wyngaard

August 2008 - Posts

  • Sharepoint e-Books available for Download from Microsoft

    In my never ending research to understand Sharepoint better and increase my knowledge of the product, I came across a Microsoft web site that has free e-books available for download in MS Word format.

    Some of you might already know about it, but I am betting that many of you don't and therefore I thought that a quick blog about what is available and where to get it might be appropriate.

    Below is a list of the available books and the links to download them.

    Getting started

    Getting started with Office SharePoint Server 2007

    Download

    Covers basic information about the capabilities of and requirements for Microsoft Office SharePoint Server 2007

    July 2008

    Planning

    Planning and architecture for Office SharePoint Server 2007, part 1

    Download

    Covers topics such as planning sites, planning for certain features such as forms and search, and planning for managing documents and records.

    March 2007

    Planning and architecture for Office SharePoint Server 2007, part 2

    Download

    Covers topics such as determining hardware and software requirements, capacity planning, and planning for security.

    March 2007

    Governance guide for Office SharePoint Server 2007

    Download

    Governance is the set of policies, roles, responsibilities, and processes that you establish in your enterprise to guide, direct, and control how it uses technologies to accomplish business goals. The articles in this guide will help you determine the aspects of your Office SharePoint Server 2007 deployment to govern and include discussions of techniques for governing your enterprise’s SharePoint IT service and information architecture.

    July 2008

    Planning an extranet environment for Office SharePoint Server 2007

    Download

    Covers planning recommendations for deploying Office SharePoint Server 2007 in an extranet environment.

    June 2007

    Deliver accessible solutions (white paper)

    Download

    Provides information and guidelines about the issues that organizations face when delivering accessible Web solutions, including those built by using Office SharePoint Server 2007.

    June 2008

    Best practices for developing accessible Web sites (white paper)

    Download

    Provides information about designing and developing accessible Web sites in Office SharePoint Server 2007. This document is intended for users who are familiar with Office SharePoint Server 2007, ASP.NET, and .NET development.

    June 2008

    Deployment

    Deployment for Office SharePoint Server 2007

    Download

    Covers installing and configuring Office SharePoint Server 2007 in a new deployment.

    June 2007

    Upgrading to Office SharePoint Server 2007

    Download

    Covers upgrading to Office SharePoint Server 2007.

    June 2008

    Deploying Office SharePoint Server 2007 Service Pack 1

    Download as .doc

    Download as .pdf

    Changes in Office SharePoint Server 2007 SP1 and instructions for deploying the service pack.

    December 2007

    Installation guide for Office SharePoint Server 2007

    Download

    This guide provides the information you need to successfully install Microsoft Office SharePoint Server 2007 to a stand-alone computer or simple server farm.

    July 2008

    Design and build sites for Office SharePoint Server 2007

    Download

    This guide provides prescriptive guidance that can help you and your team build custom enterprise sites by using Microsoft Office SharePoint Server 2007 — such as company-wide portal sites or Internet presence sites.

    January 2008

    Operations

    Administering enterprise search for Office SharePoint Server 2007

    Download

    Includes guidance and procedures for configuring and maintaining search features in Office SharePoint Server 2007.

    September 2007

    Security

    Security for Office SharePoint Server 2007

    Download

    Describes how security is implemented in Office SharePoint Server 2007.

    July 2008

    Solutions

    Web publishing and planning guide for Office SharePoint Server 2007

    Download

    Covers features you can use to implement the structure, navigation, and appearance of Web sites and to control how your sites are authored, approved, and published.

    May 2007

    Records management guide for Office SharePoint Server 2007

    Download

    Covers general records management planning considerations and guidelines for configuring Office SharePoint Server 2007.

    May 2007

    Document management guide for Office SharePoint Server 2007

    Download

    Related Blogs

    New Microsoft Sharepoint 2007 Courses Available

    Official Microsoft Site: Downloadable content for Office SharePoint Server 2007

  • Basic steps on Implementing "Search" in Sharepoint

    In my daily work I come across many customers that have implemented MOSS themselves and are having problems in one form or another. Some sites are better than others, but they all seem to have one thing in common. None of them have implemented "Search" in any form in their deployments. They all claim to have a number of reasons for this, but the most common one is lack of knowledge.

    Although the "Search" aspect is a vast topic all by itself, I believe many people blow this out of proportion has they are all trying to build Utopia. Fortunately we do not live in Utopia, but in South Africa and therefore we can just implement the capabilities and it will most likely fulfil our needs as standard. I have therefore decided to write a simple blog about the basic steps required to implement "Search" in MOSS.

    Before we start, let's take a look at the benefits of doing this. I always believe the "Why" is more important than the "How"!

    • As Sharepoint grows and more and more content is added, it becomes increasingly difficult for users to find the information they need or even navigate their way through the structure. Search is an easy way of finding the information you need without knowing where it is.
    • Sharepoint is becoming the focal point for Microsoft's Search strategy as more and more applications integrate with Sharepoint and store their information on this platform.

    Now that we understand the Why! Let's take a look at the How!

    The following is a basic list of steps that I am going to follow to configure search in MOSS. If WSS there is not much you can do with search. It is already configured on it's own content databases.

    • Start the service - there is a separate service that comes with MOSS that enables searching.
    • Create an SSP - this will allow you to configure the search settings.
    • Configure the Search locations - this can be File servers, Web Sites, Sharepoint Sites, Mail Servers, Database servers, etc.
    • Schedule the search service - this will determine how often the data is refreshed.
    • Build a Search Centre - this is and enterprise Sharepoint template that we will use to test if the searching works.

    Time to start with the first step.

    Start the "Search" Service:

    Even though the "Search" service is configured via the SSP, it still needs to be started as a service. This can be done by navigating to the "Operations" tab in the Sharepoint admin console and then selecting "Services on Server".

    List Services

    The corresponding screen will display a list of all services configured in the farm. Select the "Start" hyperlink next to the service called "Office Sharepoint Server Search". This action will then open the configuration screen for the "Search Service".

    Search Service Properties

    There are quite a number of options that can be configured for this service, so let's take a look at them.

    • Query and Indexing - this allows you to dedicate a server for either searching or indexing if you have more than one SSP on a separate servers.
    • Contact E-mail address - who to contact when things go wrong
    • Farm Search Service Account - This is the account that will be used by default to index the crawl locations. This typically has to be a fairly high privileged account on the domain.
    • Index Server File location - this is were the catalogue files will be stored for the indexed information. These files can get quite large and therefore it is not a good idea to leave this on the "C:" drive.
    • Indexer Performance - the indexing component has the ability to run the CPU's at about a 100% if left unchecked. This is fine if you are indexing at night or on a different server, but if not, it becomes a good idea to throttle it a bit.
    • Web Front End and Crawling - if you have more than one server installed with a SSP component in the farm, you can select which server is going to take the hit when the indexing services kicks in.

    Create an SSP:

    I am not going to explain how to setup an SSP in this blog as I have already written articles about it. They can be found by following the links below:

    Installation Procedure for MOSS

    Overview of Shared Service Providers in Sharepoint

    Configure the Search locations:

    The "Search" service can be configured in more detail by navigating to the "Search Settings" section in the SSP admin console. There does not seem to be much to configure by purely looking at the links available until you select the "Search Settings" link itself.

    Search Options SSP

    There are a huge amount of options available to configure on this screen, much more than I can possible write about in one blog. I am therefore only going to focus on the bare basics of getting search up and running and I will cover the other areas in future blogs.

    Crawl Settings

    The area that i want to focus on is called "Content sources and crawl schedules". This section will allow us to specify what needs to be indexed and then we can also specify when.

    Content Sources

    The Sharepoint sites are added as a "Content Source" by default. This is based on the logical assumption that you would always like to search on the content already added into your Sharepoint deployment. This would include all "Web Applications" , "Site Collections" , "Sites" and all the content therein. This content source will also be dynamically updated as you create new sites and site collections.

    The real power of the "Sharepoint Enterprise Search" is the ability to go and index content lying external from Sharepoint and still use Sharepoint to go and find this information. This can be done by adding a "New Content Source" from the toolbar.

    Add Content Source

    There are a number of options that can be defined on this screen. Let's take a look at them:

    • Name: This is just a descriptive name used to uniquely identifying the source.
    • Content Source Type: These are the locations where Sharepoint can go and crawl content
      1. Sharepoint Sites - other Sharepoint "Web Applications" that store their data in content databases
      2. Web Sites - other web sites that are not built on Sharepoint technology.
      3. File Shares - UNC path names to network servers and shares.
      4. Exchange Public Folders - used with the older versions of Exchange. The new version does not use public folders.
      5. Business Data - connections formed to external databases already connected via the BDC(Business Data Connector)
    • Start Addresses: This depends on the content source type and can be anything from UNC path names to HTTP locations for web sites.
    • Crawl Settings: this settings allows you to control the depth of the crawl. Sub folders and sub sites.

    Here are some tips about defining source locations:

    • Rather create multiple source locations than putting all the path's in one single location. It makes it easier for the index service and it is also easier to build search scopes later when they are split.
    • Keep the depth of the crawl to a minimum. Only index what you need.

    Schedule the Search Service for the crawl:

    Using the "Manage Content Sources" page, you can select "Schedule" from the individual content sources drop down menu.

    Schedule Content Source

    This will allow you to define a full and incremental crawl schedule:

    • Full Crawl - this will populate or re-populate the entire search catalogue from the beginning. This can be very time consume and processor intensive.
    • Incremental Crawl - this will only compare what has changed with what has been indexed and update the changes. This is typically scheduled on a regular basis.

    Remember that the catalogue files location in defined during the creation of the SSP. Make sure they do not use the default and sit on the C: drive as they tend to consume a lot of disk space.

     Build a Search Centre:

    Now that the "Search Engine" has been defined so to speak. We need to configure the user front end so that searches can be performed by the end-users. This requires us to build a "Search Centre" using the standard enterprise templates provided by MOSS.

     Create Search Centre

    Once the "Search" centre has been define. Searches can be performed using the search box provided at the top of each Sharepoint site, or the user could navigate to the "Search Centre" itself if required.

    Search Box

    The search results are then returned in a list with hyperlinks and a brief description of the content listed. Selecting the link will take you to the content desired.

    Search Results

    This will then conclude the basic steps in setting up searching in MOSS.

    Related Blogs:

    Microsoft Search Strategy

    Installation Procedure for MOSS

    Overview of Shared Service Providers in Sharepoint

    Posted Aug 20 2008, 05:38 AM by Neil with 5 comment(s)
    Filed under:
  • SQL databases used in Sharepoint

    There are quite a number of databases generated during a Sharepoint install and depending on the "Farm" configuration there might be more or less. A lot of SQL DBA's get quite annoyed when all these databases suddenly appear in their system and they have no idea what each database does or why it is there.

    I have therefore decided to explain what databases get created during a MOSS install and what the purpose is behind each. A WSS install generates less databases and therefore I decided to focus on a MOSS install as this generates the most.

    Lets start by taking a look at a screen shots of the databases generated and then I will explain the purpose of each.

    List All DB's

    Below is a list of the databases generated by Sharepoint, the names may differ per deployment, but the purpose remains the same:

    • Config Database for the Farm - Sharepoint_Config - stores configuration information about the servers deployed in the farm , their individual configurations settings and some security information. Without this database there is no Sharepoint.
    • Content database for the Admin Console - Sharepoint_AdminContent_GUID - sharepoint uses its own technology to render the web based admin console for Sharepoint. Therefore it needs it's own content database to stored the configuration settings for the web parts used. The actual data configured using this console is stored in the config database for the farm. The name for this database is system generated and cannot be controlled during the installation process and therefore it ends with a GUID.
    • Config database for the SSP (Shared Service Providers) - BPS_SharedServices_DB - during the configuration process a SPP is defined to configure all the Shared Services used by Sharepoint. All the Configuration settings for these services are stored in this database. The name of the database can be controlled during the creation process and should be descriptive of the purpose.
    • Content database for the SSP Console - BPS_SSP_Content - just like the admin console the SSP also needs a web site to allow you to configure the shared services and these also use web parts and lists. Therefore the SSP also needs its own content database to store these settings.
    • SSP Search database - BPS_SharedServices_Search_DB - this database is used by the Enterprise search service to store metadata about the information crawled including security information. This is typically used for information stored external from Sharepoint.
    • WSS search database - WSS_Search_sps-dc1 - this database is used by the WSS core components to store metadata about content stored inside the Sharepoint web application content databases. This is created during the installation process.
    • Web Application Content - Office_Content - this is the content database for the first user based web site in Sharepoint. Before the users can actually use Sharepoint a "Web Application", Site Collection and Site must be built. This database stores all the information generated within this web application.
    • Additional content databases - Office_Content_2 - new content databases can be created to host additional "Site Collections" and "Web Applications" and there could be hundreds of these.

    The other databases that are left over in the snapshot is used by other applications that do not have a direct influence on Sharepoint, but can be used in conjunction with the product.

    • SQL Server system databases and sample databases
    • Project Server 2007 databases
    • Live Communication Server 2005 databases.
    • Reporting Services databases.

    Related Blogs:

    Installing MOSS with a remote SQL Server

    Connecting an External Database to Sharepoint using the BDC

    Installation Procedure for MOSS

    Sharepoint Server Topologies

  • Microsoft Releases SQL Server 2008

    After a long delay and some initial problems, Microsoft has final fix and released the new version of SQL Server 2008 previously called "Katmai". This is quite important out of a Sharepoint perspective as well as the new features in SQL Server can only enhance the performance of MOSS and WSS.

    Here is a quick breakdown of the new features and some links for more info.

    image

     

    image

    Here is a list of the different versions being released:

    SQL Server 2008 Enterprise. SQL Server 2008 Enterprise is a comprehensive data management and business intelligence platform that provides enterprise-class scalability, data warehousing, security, advanced analytics and reporting support for running business-critical applications. With this edition, it is possible to consolidate servers and perform large-scale online transactional processing.

    SQL Server 2008 Standard. SQL Server 2008 Standard is a complete data management and business intelligence platform that provides best-in-class ease of use and manageability for running departmental applications.

    SQL Server 2008 Workgroup. SQL Server 2008 Workgroup is a reliable data management and reporting platform that delivers secure, remote synchronization and management capabilities for running branch applications. This edition includes core database features and is easy to upgrade to the Standard or Enterprise edition.

    SQL Server 2008 Web. SQL Server 2008 Web is designed for highly available, Internet-facing Web-serving environments running on Windows Server. SQL Server 2008 Web provides the tools necessary to support low-cost, large-scale, highly available Web applications or hosting solutions for customers.

    SQL Server 2008 Developer. SQL Server 2008 Developer allows developers to build and test any type of application with SQL Server. This edition features all of the functionality of SQL Server Enterprise but is licensed only for development, test and demo use. Applications and databases developed on this edition can easily be upgraded to SQL Server 2008 Enterprise.

    SQL Server 2008 Express. SQL Server 2008 Express is a free edition of SQL Server that features core database functionality including all of the new SQL Server 2008 data types, in a small footprint. This edition is ideal for learning and building desktop and small server applications, and for redistribution by ISVs.

    SQL Server Compact 3.5. SQL Server Compact is a free embedded database designed for developers and is ideal for building stand-alone and occasionally connected applications for mobile devices, desktops and Web clients. SQL Server Compact runs on all Microsoft Windows platforms, including the Windows XP and Windows Vista operating systems, and on Pocket PC and smartphone devices.

    Reference Blogs:

    The Data Platform Insider.

    SQL Server MS Site

    Posted Aug 09 2008, 12:39 AM by Neil with no comments
    Filed under: ,
  • Using SyncToy to synchronize offline Sharepoint documents on Vista

    One of the main problems that users have with Sharepoint is the ability to synchronize their documents on Sharepoint with offline copies on their PC's. There are a number of ways in which to solve this problem ranging from Outlook 2007 to Groove 2007, but all of them cost additional money in the form of licensing. Fortunately Microsoft has released a free add-on tool for Vista and XP that can solve this problem for Free!!!!

    SyncToy is not a new power tool, but until the release of beta 2 of this product, I struggled to get this to work. In fact on XP I still fail to get this to work consistently, but on Vista it seems to be fine. I will therefore explain how to set up a sync between Sharepoint and Vista using SyncToy in the rest of this blog.

    There are a number of steps involved in getting this to work:

    1. Download and install SyncToy 2 Beta. I will provide a download link at the end of this blog.
    2. Create a Site on Sharepoint with some documents in a document library.
    3. Create a folder on your local machine to stored the synchronized documents.
    4. Map a drive letter to Sharepoint using "Web DAV". This is the difficult part.
    5. Setup and Sync pair using SyncToy.
    6. Run the tool to Synchronize the documents.

    Now that I have outline the steps. Let's start at step 2.

    Create Sharepoint Site:

    Before we can sync any documents to a PC, we need some type of source in Sharepoint. This can be easily achieved by creating a new site in Sharepoint with a document library.

    Sharepoint Site

    Add some documents to the library so that we can verify that the sync was successful later on. The type of document is completely irrelevant.

    Create Folder on the PC

    This step is a simple matter of navigating using "Windows Explorer", right clicking and creating a new folder.

    New Folder

    In this case I am naming it "Proposals". It is generally a good idea to be descriptive of the information that you are trying to sync.

    Map a Drive Letter to the Sharepoint Site

    Still using "Windows Explorer", right click on "My Computer" and select the option called "Map Network Drive".

    Map Network Drive

    Select a drive letter and type the path to the Sharepoint site into the text box called "Folder". If your current account used to log onto the PC does not have permissions to the site, you can provide alternative credentials by selecting the option called "Different user name". Commit the mapping by selecting "Finish".

    Creating the Sync Pair using SyncToy

    Launch the SyncToy program. I am assuming that you have already downloaded and installed it.

    Sync Toy Welcome

    On the "Welcome" screen you will find an option called "Create New Folder Pair". Select this to start the process of setting up the mapping between the PC and Sharepoint.

    New Folder Pair 1

    On the first screen of this wizard, select the local folder on your PC for the "Left Folder" and the new drive letter we mapped to Sharepoint earlier for the "Right Folder". This does not work with "Network Places" mapped using "Web DAV". That is why we had to map a drive letter to the Sharepoint site. Click "Next".

    New Folder Pair 2

    On the second screen, select the method that will be used to sync the two locations. If you want to keep the documents the same on both locations then the option will have to be "Synchronize" which is also the default. Click "Next"

    New Folder Pair 3

    The last screen is used to give the sync pair a logical name. Give it a descriptive name based on what you are trying to sync and commit the changes. It takes a while for the sync pair to be establish, so give it some time.

    Run the Sync

    Now that the sync pair has been created, we need to run the process to do the actual sync.

    Pair Complete

    This process can be started by selecting the "Run" button on the "Welcome" screen once the sync pair as been created.

    Run Sync

    SyncToy will indicate the progress using a progress indicator bar in green and a summary list noting the successes and failures. Once this is complete, close SyncToy and verify the results by navigating to the local folder on the PC.

    Result

    If everything worked according to plan, copies of all the documents in Sharepoint should now reside in the folder on the PC. Every time you need to sync the folder again, simply start SyncToy and run the process again. It is probably possible to automate the sync, but I have not investigated it thus far.

    Download Link for SyncToy 2 Beta:

    http://www.microsoft.com/downloads/thankyou.aspx?familyId=c26efa36-98e0-4ee9-a7c5-98d0592d8c52&displayLang=en

    Referenced Blogs:

    http://smallvoid.com/article/winnt-webdav-network-drive.html

    Related Blogs:

    Offline Sharepoint documents in Groove

    The importance of Outlook 2007 as a user interface into Sharepoint

    Posted Aug 02 2008, 05:55 AM by Neil with 4 comment(s)
    Filed under: ,
More Posts
Add to Technorati Favorites
Powered by Community Server (Commercial Edition), by Telligent Systems
Afrigator