What options are available to backup my data in a SharePoint 2010?

I'm an experienced SQL Server DBA, but new to administering SharePoint 2007 databases. Our current SharePoint databases are very large and getting bigger every day. Based on my initial research the content database is the one I am going to focus on initially. In this tip we cover steps to take to best manage your SharePoint databases.

You cannot browse to the SharePoint server from the server SharePoint is installed on. You may get challenged for authentication or you receive a 401.1 page error.

This article outlines how to configure SharePoint Forms Based Authentication (FBA) to use Lightweight Directory Access Protocol (LDAP), typically used on a SharePoint Extranet.

This article outlines how to configure SharePoint Forms Based Authentication (FBA) to use user accounts stored in an SQL database, typically used on a SharePoint Extranet.

By default, MOSS 2007 configures every 1st level sub-site to have a tab (with link) on the horizontal navigation bar at the root level of the site collection. I would like to be able to nest some or all of these links under one tab heading, saving space for other tabs.

Wouldn't you like to hide some fields from a user when filling out a new item form for a list?

SharePoint is widely used for storing and maintaining content. Different groups of users access SharePoint, but what if an organization wants to provide granular customized access rights like read, write or delete for different users? In this tip, we cover how this can be accomplished.

In a recent tip, I discussed installing the Windows SharePoint Service and SharePoint Foundation 2010. Once you have completed the installation, you need to understand how to create a web application, site collections and sites. In this tip we will look at each of these components.

This article deals with SharePoint Custom Timer jobs. It outlines when to create Custom Timer Jobs, how to create a Custom Timer Job, how to debug it in Visual Studio and how to deploy it.

I created a document library but would like one or more business users to be able to maintain permissions, without giving them "full control" of the library or site.

When developing for SharePoint you may find your code does not execute due to the users permission levels.

On an Internet facing SharePoint site you want to enable anonymous access so your visitors do not need to authenticate against your membership provider.

When trying to upload numerous documents into a SharePoint library, a user does not see the "Upload Multiple Documents" link/selection that would allow them to upload more than one document at a time in a particular directory.

When a SharePoint list or library is added into a web part zone, whatever view I choose does not change when I update the view from the list or library settings.

After having implemented a new installation of MOSS 2007, I cannot figure out how to get Excel Services working. I have added the Excel Web Access web part, and linked to a MS Excel 2007 worksheet, but all I get is an error message that says "You do not have permissions to open this file on Excel Services". I also don't know how to display a specific part of the spreadsheet.

At certain times, we want to hide the details in user input forms, but also at the same time we want to maintain the data in the backend. In SharePoint we could use the list to store data. The default forms provided in the list like NewForm, Editform and others contain all metadata (fields). Now the problem is if you want to remove fields from the forms, either you need to remove columns from the list or you need to create new forms to replace the default forms.

By default, SharePoint document libraries display graphical icons representing various Microsoft Office Applications (i.e. Excel, Word, etc.). All non-Microsoft documents are represented with a plain white square. How do I display a special icon for other document types?

By default, SharePoint Lists provide default new, edit and display forms. Limitations include the requirement to show and edit all fields and the inability to customize formatting of the form.

Windows SharePoint Service is an add-on service of the Windows Server OS which provides collaborative development, content management, search features, etc., without any additional licensing. So how do we install this service, configure it and get started to leverage these powerful features?

Anticipating the arrival of SharePoint Foundation 2010, wouldn't it be great if we can setup a test environment so we can have a feel of what it is like working with the new version of SharePoint?

Getting ready for SharePoint Foundation 2010, let's review the installation prerequisites.

I have read that installing SharePoint 2010 Server requires a number of prerequisites. Before I spend a great deal of time looking for them all, is there a place where I can download them all at once? In this tip I show you a simple solution.

Looking for documentation and software related to SharePoint 2010? Check out this compiled list of SharePoint 2010 related documents and software.

SharePoint (WSS3 and MOSS 2007) blocks certain files types (by file extension) from being uploaded while allowing others. Is there a way I can manage what file types are allowed or blocked?

As SharePoint system administrator, I create all sites for users. This is true even when I turn over "Full Control" to a power user that will design and maintain the site, including setting up permissions. However, I still get the automated email messages from users that "request access" using the built-in access request form. Is there a way I can direct these email messages to go the power user in charge of the site?

By default, SharePoint (WSS3 and MOSS 2007) limits file sizes to 50mb. However I would like to change that number. Is there a way to change this configuration?

It's easy to find blogs and msdn documentation on creating Custom Timer jobs, but still developers face issues while deploying and running them on SharePoint farms due to lack of timer job development guidelines.

After migrating your SharePoint 2007 content database to your new x64 SharePoint 2010 farm you receive errors when trying to use or activate the SharePoint Publishing feature.

Wouldn't you like to be able to redirect users to the page of your choice after submitting a new item to a SharePoint list? In this tip we cover the steps.

People who are using SharePoint know that Central Administration (CA) must be running on one of the servers in the farm. So, the question is can we have CA running on more than one server in the farm? Maybe the main server that has CA installed is down, but we still need to access CA. In this tip I cover how this can be done.

Microsoft SQL Server Business Intelligence (BI) Professionals are generally well versed with either of these technologies: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS). But with Sharepoint Server continuously growing as a collaboration platform with it's increasing set of Business Intelligence features, MS BI Technology Stack considerably relies on Sharepoint for hosting and/or consuming SQL Server based BI deliverables. I find many SQL Server BI Professionals confused with the question of what are the Sharepoint based BI features one needs to have in vision to architect an end-to-end BI solution. In this article, we would look at an overview of Sharepoint BI feature

By default, whenever creating a new site with unique permission in MOSS 2007 or WSS3, the default group name "Members" seems confusing to me. The term member seems too ambiguous.

Many SharePoint portals implement and apply the MySite feature (the MySite feature is only available in MOSS 2007 and is not provided by WSS 3.0).  But how about branding the same look and feel of the parent site to MySite? Unfortunately Microsoft designed MySite to have a default format and does not allow custom branding to be effective for all private MySite users. In this tip we'll go through how to overcome this issue.

I am just getting started with SharePoint and noticed many security options and features. I can see that you can attached named users to sites, lists and libraries. I can even see there is some type of grouping system. But I don't know what to make of it all.

Sometimes there are requirements in a Variated Multi-Lingual SharePoint portal which require having a unified single source document library/list with its folder structure to be displayed across all webs (Sub Sites : ex: English, Arabic, French, etc...) but achieving this we will face two serious problems. We'll discuss them in detail through this two part article series.

Sometimes there are requirements in a Variated Multi-Lingual SharePoint portal which require having a unified single source document library/list with its folder structure to be displayed across all webs (Sub Sites : ex: English, Arabic, French, etc...) but achieving this we will face two serious problems. We'll discuss them in detail through this two part article series.

The "Open with Windows Explorer" option on a SharePoint document library does not open Windows Explorer.

With Windows Server 2008 R2 out in the market for quite a while, you may be asked to install Office SharePoint Server 2007 (MOSS 2007) on this OS platform. However, the available media for MOSS 2007 only contains Service Pack 1 and that it is not supported on a Windows Server 2008 R2 platform. How do you go about installing Office SharePoint Server 2007 on Windows Server 2008 R2?

Many Multi-Lingual SharePoint portals may require having the same List structure in its webs (Sub-Sites) [i.e. having a list in a primary language site (ex: English) which has a set of predefined columns and the need to have this list structure in a secondary language variated site (ex: Arabic) where each template has its own language variated template]. Also, there may be the need to extend a certain List quota (i.e. list items size) instead of using the default quota. Rob Fisch wrote a tip about "Managing SharePoint File Size Limits" which applies to any file (item) size under an entire web application using SharePoint Central Administration. I will explain how to extend a List items size without effecting other files in the site using

Take a look at some of the new features of the SharePoint 2010 Ribbon Bar.

A seemingly mysterious problem started occurring a couple of months after implementing a workflow solution. The workflow statuses (Completed, Approved, Rejected, etc) started disappearing. After doing a little research, it seems that, by default, the workflow status information is purged after 60 days.

In this tip we cover how to organize content using different types of libraries and also how a library is used in SharePoint.

Replace the SharePoint server hostname with a user friendly Host Header name.

How to receive email notifications when documents or items are added, changed or deleted.

The scope of this tip is to explain the usage of RunWithElevatedPrivileges() [RWEP] - a method for security elevation and in SharePoint.