Maximum SharePoint Content DB Capacity

100GB is not the limit, its actually a best practise. This post lists out few suggestions. The following represents Microsoft's guidance and best practices on content databases, as specified in various places on technet.microsoft.com:

1. Limit the content database size to 100GB; use multiple content databases if necessary.
2. Create multiple data files and spread them across multiple disks; only create files in the primary file group.
3. The number of data files should be less than or equal to the number of core CPUs; count dual core processors as two CPUs; count each processor that supports hyper-threading as one CPU.

Tricky Interview Questions – SharePoint

Information Architect

This will most likely be someone working for a consultancy company who will be tasked with gathering requirements and defining the goals for the SharePoint deployment. Then following that, defining the architecture for the deployment. This will include a knowledge of areas such as capacity planning, taxonomy, security and governance.

A question to ask this person in interview to test their knowledge is:

Programming with the SharePoint 2010 object model

In this exercise you will create a new console application that programs against the SharePoint Foundation 2010 object model to create new lists and add items to a SharePoint 2010 site. This will illustrate some on the aspects of the SharePoint Foundation 2010 object model as well as show some of the issues about which versions of assemblies to use when you do this type of programming.

1.   If you haven't already done so, you need to run the batch file named LabSetup01.bat to create the site located at http://intranet.contoso.com/sites/Lab01.

2.       Open the browser and navigate to the new site at http://intranet.contoso.com/sites/Lab01/default.aspx. You should see that this new site has been created as a blank site with no existing lists. In the following steps you are going to write a program that uses the SharePoint 2010 object model to create a few new lists in this site and to populate these lists with sample data.

Working with the SharePoint 2010 Ribbon and In-place Editing

In this exercise, you will complete work inside the top-level site of the site collection you created in the previous exercise at http://intranet.contoso.com/sites/Lab01A. You will begin by adding and viewing items inside of some of the lists that are automatically created as part of a new Team site so you can experience the new paradigm for in-place editing. After that, you will work with a Web Part Page so you can experience how the SharePoint 2010 user interface has changed the way users manage Web Parts.

1.       At this point you should be at the home page of the site created in the previous exercise at the URL http://intranet.contoso.com/sites/Lab01A/SitePages/Home.aspx. Note that the home page is not default.aspx but rather a wiki page named Home.aspx located inside a wiki page library named SitePages.

2.       Observe that the page Home.aspx already contains some generic content including large text block at the top of the page which reads "Welcome!". Go into edit mode for the wiki page by clicking the Edit Page menu within the Site Actions menu.

Creating a Site Collection in SharePoint Central Administration

Exercise 1: Creating a Site Collection in SharePoint Central Administration

In this exercise you will create a new SharePoint site collection using the SharePoint 2010 Central Administration site.

1.  Make sure you are logged in as the local administrator.

2. Navigate to the SharePoint 2010 Central Administration site. You can do this using the shortcut inside the Administrative Tools menu of the Windows Start menu. On this VM you can also get to the SharePoint 2010 Central Administration site by opening the browser and navigating to the following URL:

http://YourServerNameHere:2010/default.aspx

Building Collaborative Applications Without Code Using Office SharePoint Designer 2007

Event Overview

Learn how to use Microsoft Office SharePoint Designer 2007 to build productive and efficient solutions on Microsoft SharePoint Products and Technologies. In this webcast, we explain how you can use SharePoint Designer 2007 to create and deploy interactive Web solutions on the SharePoint platform—without writing any code. We also describe how to build reporting and tracking applications and collaborative workflows, and show you how to customize Microsoft Windows SharePoint Services application templates.

Presenter: Rob Mauceri, Principal Group Program Manager, Microsoft Corporation

Features of the Search Component of Office SharePoint Server 2007

1.    Write the features of the search component of Office SharePoint Server 2007?

The search component of Office SharePoint Server 2007 has been significantly enhanced by this release of SharePoint Products and Technologies. New features provide:
* A consistent and familiar search experience.
* Increased relevance of search results.
* New functions to search for people and expertise.
* Ability to index and search data in line-of-business applications and
* Improved manageability and extensibility.

2.    What are the benefits of Microsoft Office SharePoint Server 2007?

* Provide a simple, familiar, and consistent user experience.
* Boost employee productivity by simplifying everyday business activities.
* Help meet regulatory requirements through comprehensive control over content.
* Effectively manage and repurpose content to gain increased business value.
* Simplify organization-wide access to both structured and unstructured information across disparate systems.
* Connect people with information and expertise.
* Accelerate shared business processes across organizational boundaries.
* Share business data without divulging sensitive information.
* Enable people to make better-informed decisions by presenting business-critical information in one central location.
* Provide a single, integrated platform to manage intranet, extranet, and Internet applications across the enterprise.

3.    Will SharePoint Portal Server and Team Services ever merge?

The products will come together because they are both developed by the Office team.

Office SharePoint Server 2007 & more

1.    Are there any browser recommendations?

Yes. Microsoft recommends using the following browsers for viewing and editing Windows SharePoint Services sites: Microsoft Internet Explorer 5.01 with Service Pack 2, Microsoft Internet Explorer 5.5 with Service Pack 2, Internet Explorer 6, Netscape Navigator 6.2 or later.

2.    What security levels are assigned to users?

Security levels are assigned by the administrator who is adding the user. There are four levels by default and additional levels can be composed as necessary.
* Reader - Has read-only access to the Web site.
* Contributor - Can add content to existing document libraries and lists.
* Web Designer - Can create lists and document libraries and customize pages in the Web site.
* Administrator - Has full control of the Web site.

3.    How secure are Windows SharePoint Services sites hosted by Microsoft?

Microsoft Windows SharePoint Services Technical security measures provide firewall protection, intrusion detection, and web-publishing rules. The Microsoft operation center team tests and deploys software updates in order to maintain the highest level of security and software reliability. Software hot-fixes and service packs are tested and deployed based on their priority and level of risk. Security related hot-fixes are rapidly deployed into the environment to address current threats. A comprehensive software validation activity ensures software stability through regression testing prior to deployment.

Top 20 Question & Answers SharePoint

1.    What is Microsoft Windows Services?

Microsoft Windows Services is the engine that allows administrators to create Web sites for information sharing and document collaboration. Windows SharePoint Services provides additional functionality to the Microsoft Office System and other desktop applications, as well as serving as a plat form for application development. SharePoint sites provide communities for team collaboration, enabling users to work together on documents, tasks, and projects. The environment for easy and flexible deployment, administration, and application development.

2.    What is the relationship between Microsoft SharePoint Portal Server and Microsoft Windows Services?

Microsoft SharePoint Products and Technologies (including SharePoint Portal Server and Windows SharePoint Services) deliver highly scalable collaboration solutions with flexible deployment and management tools. Windows SharePoint Services provides sites for team collaboration, while Share Point Portal Server connects these sites, people, and business processes—facilitating knowledge sharing and smart organizations. SharePoint Portal Server also extends the capabilities of Windows SharePoint Services by providing organizational and management tools for SharePoint sites, and by enabling teams to publish information to the entire organization.

3.    Who is Office SharePoint Server 2007 designed for?

Office SharePoint Server 2007 can be used by information workers, IT administrators, and application developers.
is designed

SharePoint Basic Question & Answers Part 1

1.    What is SharePoint?

Portal Collaboration Software.

2.    What is the difference between SharePoint Portal Server and Windows SharePoint Services?

SharePoint Portal Server is the global portal offering features like global navigation and searching. Windows SharePoint Services is more content management based with document libraries and lists. You apply information to certain areas within your portal from Windows SharePoint Services or directly to portal areas.

3.    What is a document library?

A document library is where you upload your core documents. They consist of a row and column view with links to the documents. When the document is updated so is the link on your site. You can also track metadata on your documents. Metadata would consist of document properties.