Friday, February 27, 2009

Custom Cross-Site Lookup Column Add-On

I have a requirement for using MS provided fantastic 40 templates in a way where I have to use Site A's List column in Site B's List as a lookup within same Site Collection. And thanks to SharePoint Forum I found this feature which is available for free.

Wednesday, February 25, 2009

Incorporating a Master Page into a SharePoint site definition

This article will discuss the creation of SharePoint site definitions, which are templates for SharePoint sites that will automatically create the master page feature on the site when created

Tuesday, February 24, 2009

Information Rights Management with SharePoint

Information Rights Management (IRM) provides an additional layer of content security over that provided by more traditional access control lists (ACLs). IRM establishes usage limitations on a file rather than limiting access. For example, you may grant a user access to a file but you may not want them to change the file on the client computer or forward it to someone else. IRM provides this additional level of security.

Implementing IRM security in SharePoint Products and Technologies requires additional software that is not shipped with either Windows SharePoint Server 3.0 or Office SharePoint Server 2007. You must install the Microsoft Windows Rights Management Services Client, version 1, on every Web front-end server in your server farm. In addition,Microsoft Windows Rights Management Services (RMS) for Microsoft Windows Server® 2003, service pack 1.0 or later, must be available on your network.

You can implement IRM on document libraries. When IRM is enabled on a document library, and a document of a type that can be rights-managed is downloaded from the server to a client application, the SharePoint Products and Technologies server encrypts the document and adds an issuance license. When the document is uploaded back to the server, the SharePoint Products and Technologies server decrypts the file and stores it in the library in unencrypted form, as content is not encrypted in the SQL Server database. This enables features such as search and indexing to operate as usual on the files in the IRM-protected document library. The IRM permissions that are applied to a document when users upload it to a document library are based on each user's permissions for the content in the SharePoint Products and Technologies server security settings.

Microsoft Windows SharePoint Services 3.0 does not have the Microsoft® Office protector files that are required to automatically rights-protect a document when it is uploaded. You must use Office SharePoint Server 2007 to do this. More...


IRM Framework Architecture in Windows SharePoint Services
MOSS2007 and IRM – Step by Step Part 1
MOSS2007 and IRM – Step by Step Part 2
How do you apply IRM to a SharePoint List or Library?

Plan Information Rights Management
Video: IRM Use with SharePoint and Office



Free WebParts

Free SharePoint Web Parts (3rd Party)

BDC Column for SharePoint List

This custom column type provides a BDC Column type that can be created at the Site Column level and therefore used in Site Content Types. Out of the box this is not possible, and the ability to reuse BDC columns across sites and content has been identified as a common requirement. At this stage there are a number of things that are not yet implemented, including related fields, refreshing and nicer admin UI. Read more...

You can download the WSP from here...

Monday, February 23, 2009

SharePoint Web Part for Google Search

One of our client is insisting us to implement Google Search on their Internet based SharePoint Site.
Here I found one link which help to implement Google Search within your SharePoint site.

Friday, February 20, 2009

Guidline to Create a MOSS 2007 VPC image

If you do not have a MOSS server available to you, you can follow Tony Zink’s lengthy but excellent 20 step guide to creating a MOSS 2007 VPC image at here...

Controlling publishing features from onet.xml

This entry explains the different options when you configure the standard publishing features in onet.xml. If you are interested concerning the navigation options for the MOSS sites, check the previous post with details concerning the different options on configuring the navigation settings within the site.
Custom site definition for Publishing site

Displaying SharePoint Fields by Permission Level


There are situations where certain fields in lists or libraries need to be hidden or displayed according to the permission level of the logged in user. Since there is really no out-of-box way to assign permissions to fields, here’s a way to do it using conditional formatting in SharePoint Designer. This is my favorite SP Designer trick.

How to Display Multiple Document Libraries?

It seems that one of the most commonly asked questions on discussion boards and forums is “How can I display documents from multiple document libraries all in one list?” So, I decided to enumerate some of the available options to achieve this goal. They each have their pluses and drawbacks.
And here is the answer to that...

Alerts Based on Views

In SharePoint 2007, alerts can be set up based on filtered (specific) data, using views!
This applies to any SharePoint document library or list (contacts, calendars, tasks, etc.). The following example will include how this is done on a document library with custom fields.

This applies to any SharePoint document library or list (contacts, calendars, tasks, etc.). The following example will include how this is done on a document library with custom fields.

Example Case
  • An example hospital has different floors on their hospital. They have created a new field in the Patient Admissions list called “Floor”. Users are given a drop-down box of options for what floor a patient is admitted to. Users would like to know if they can set up Patient Admissions list alerts so that they are only notified when patients are admitted to THEIR floor. SURE THEY CAN!
  • First, the appropriate VIEWS need to be created, one for each “floor”. Create 4 new views for: 1 North, 1 South, 2 North, 2 South
  • The first view will have a filter of: Show the items when column Floor is equal to 1 NorthCreate the other 3 views with filtering for each of their appropriate floor names

Creating the Alerts.

  • On the Patient Admissions list, click and choose
  • In the Send alerts for these changes section, choose the very last option called “Someone changes an item that appears in the following view”
  • Then, in the drop-down box for that option, choose the name of the floor for which you’d like to receive alerts.
  • In summary, any data in any field of your list can be filtered into a View. Alerts can be created based on any *filtered* view, even “Personal” views.

Oh, and another good way to use this feature would be on an Announcements list. Each announcement would have a category, such as the department that the announcement is targeted to. Create a view for each category. This way, your users can set up their own alerts on the announcements list, and choose to only be alerted when a new one is added for their department.

The Best Workflow Tutorials

Just thought I’d let everyone know where I learned everything I know about workflows. This site is friggin awesome, and the tutorials are very detailed. You can tell that this guy, Stephen, put a lot of work into this.
http://office.microsoft.com/en-us/sharepointdesigner/HA102564171033.aspx
Then, just recently, by popular demand, he posted all of the associated files that he used in his demo!!
http://blogs.msdn.com/sharepointdesigner/archive/2009/01/27/visio-diagram-and-site-template-from-office-online-workflow-videos.aspx
It might take half a day, but I recommend that you go through all of his tutorials when you get a chance.

Wednesday, February 18, 2009

SharePoint Developer Tips & Tricks

Tip #1: Adding Intellisense When Editing XML Files in WSS v3 / MOSS 2007
All XML files, or just about every XML file I've run across so far, in Windows SharePoint Services (WSS) v3 & Mirosoft Office SharePoint Server (MOSS) 2007 is validated by SharePoint using the WSS schema file found in the 12 hive: %12HIVE%/TEMPLATES/XML/wss.xsd.
Adding an XML Schema To a Specific File In Visual Studio 2005I think it is fairly common knowledge to most developers that you can specify an XML schema for a specific file in Visual Studio. To do this, when you have the XML file open, go to the Properties toolpane and click on the ellipses for the Schema field select the Add button in the XSD Schemas dialog, browse to the wss.xsd file in the 12 hive (location listed above) and OK out of the dialogs. Click to learn more...

Tip #2: Add Command Line Shortcut to "12 Hive"
I'm not talking about creating a shortcut to the 12 Hive (the directory where just about everything WSS v3 is installed) on your desktop/Quick Launch. Like most people, I create a "12" toolbar on my Start Menu (as shown in the image to the right)... not talking about that either.
When you're in a command prompt, sometimes you need to navigate to the 12 Hive directory. But no one wants to type the directory path to c:\Program Files\Common Files\Microsoft Shared\web server extensions\12. Wouldn't it be easier if you could just type the following to get there?
c:\>cd\c:\>cd %12hive%c:\Program Files\Common Files\Microsoft Shared\web server extensions\12
Here's how u can achieve that:
1. Create a new file called SharePointCommandPrompt.cmd and insert the following text in it (if you're on a 64 bit system, you'll want to make the appropriate changes): @echo offecho Setting 12HIVE environment variable.set 12HIVE="C:\Program Files\Common Files\Microsoft Shared\web server extensions\12""C:\Program Files\Microsoft Visual Studio 8\VC\vcvarsall.bat" x86
2. After saving the file, create a new shortcut with the following target: %comspec% /k ""c:\[Path To The File You Just Created]\SharePointCommandPrompt.cmd""
3. To put a cherry on top, drag the shortcut onto your Quick Launch toolbar... should work like a champ!

To try it out, click the shortcut and type CD %12HIVE% at the command prompt. You should change directories to the root of the 12 Hive.

Tip #3: Access STSADM.EXE From any Directory in a Command Prompt
STSADM.EXE, the main administration utility for SharePoint, is still just a command line utility. You'll find it in %12HIVE%\BIN. To run it, you have to actually be in that directory... an inconvenience to me! Instead, add the directory to the PATH environment variable so you can type STSADM.EXE from any directory on your system. To do this:
1. Start -> All Programs -> Control Panel -> System

2. On the Advanced tab, click the Environment Variables button.
3. Select the variable Path and click the Edit button.
4. Add the following to the end of the Variable value field (don't forget the semicolon... the Path environment variable is a semicolon delimited string of directories):;C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN
5. OK out of all the dialogs.
Next time your system restarts, you'll be able to type STSADM.EXE at a command prompt from any directory on your system.
Tip #4: Overcome Save Site Template size limitation in SharePoint

Once I was working with a client and they mentioned that they were trying to save a site template and move it to another server while retaining the content but the size of the site prohibited this. By default there is a 10MB size limitation built in. Something clicked in my head because I recently found a fix that will increase the size limitation to whatever value you want to make it. Type the following using the STSADM utility
stsadm -o setproperty -propertyname max-template-document-size -propertyvalue 50000000
I think its pretty self explanatory with what you can do here… if you have a site that is in excess of 50MB you will use 75000000 or whatever number you come up with. But this is not the recommended practice by Microsoft.

Tuesday, February 17, 2009

Working with Reporting Services Using Microsoft Sharepoint

There are many instances in which the business process requires executive reports or some company performance reports to show up on intranet sites. Companies do use different portals to build their intranet sites. Microsoft’s SharePoint technology is one such tool. The main task is how we display the reports stored under SQL Reporting Services on the SharePoint site. Microsoft does provide two Web parts with SQL Reporting Services SP 2. In this section I will share information on using the current web parts provided by Microsoft and then explain what exactly happens behind the scenes to display the report. Click to learn more how???

Monday, February 16, 2009

SharePoint 2007 Maximum Limitations

This will tell you about MOSS-2007 figures and numbers which helps you for better performanc of SharePoint sites.

Workaround for Lookup field in SharePoint list templates

If you have ever tried to save a list as a template that contains a Lookup field for one of the columns, you have undoubtedly discovered that the template once implemented on another site will be unable to properly lookup a field for that column. Instead the column will have to be deleted and recreated for each instance of the list.
Todd Bleeker has posted a cool workaround for this issue that can be used on a singular basis (it is not for solving this problem with custom created list definitions). Thanks Todd!
FULL POST HERE
01. Browse to the source Web's lookup list and choose Modify settings and columns.
02. Copy the source lookup list GUID from the URL.
03. Browse to the destination Web's lookup list and choose Modify settings and columns.
04. Copy the destination lookup list GUID from the URL.
05. Save the source Web's list that contains a lookup column to the lookup list as a list template called [yourlist].stp.
06. Export the list template STP from the source list template gallery to the file system.
07. Rename the [yourlist].stp file to [yourlist].cab so Windows can open it.
08. Open the file, right click on the manifest.xml file and export it to
the file system.
09. Edit the manifest.xml file; find the source Web's lookup list GUID and replace it with the destination Web's lookup list GUID.
10. Save the manifest.xml file.
11. Open a VS.NET command prompt.
12. Run the makecab command as follows:
makecab manifest.xml [yourlist].stp
13. Import the new STP into the destination Web's list template gallery. You will need to delete it if it has previously been imported.
14. Create a new list based upon the new STP file.

The lookup column on the new list should retain all the data that was in
the source list.

Trend Reporting Against a SharePoint List

A programme manager I work with wanted to view trend information regarding the projects in his portfolio. His problem was that weekly reports were all well and good but with around a dozen projects under his wing he could not readily visualise where projected milestone delivery dates were, in general, getting worse or better.
To meet this requirement I knew that we had to create a 'snapshot' record on a regular basis, which would be completed by individual project managers. Some information would need to be recorded each week, with one variable field - the Forecast Date.

Hide/Show Navigation Panel on SharePoint Site

I am very thankful to Paul Grenier for all his articles for using JQuery with SharePoint.

Lot many time User will ask you: I never use that, can’t you just hide it?
Using JQuery, you can reply: Others may need it. I’ll give you check boxes to turn it on and off.

PreSaveAction to EditForm.aspx

The creators of that script added a “hook” for custom validation called PreSaveAction. This function gets called during the submit action but was never defined so we can create our own. We have a simple strategy: identify Tasks surfaced through our Linked Tasks web part and stop the submit action if Issue status = ‘Closed’ and number of Tasks > 0. Translating that “simple” logic into javascript takes patience and testing. Add the PreSaveAction to the EditForm.aspx page

Data View WebPart example

Although, the Data View Web Part is not part of the Web part galleries via WSS or MOSS, it is nonetheless one of the most important and useful webparts available. Just recently I had a real world business request and the DVWP came in handy.
Pat Iovanella has provided very nice example on that

Email and SharePoint Designer Workflow

Many business workflow scenarios call for us to send an email at different parts of the process.
Like many things with SharePoint Designer workflow, this is relatively easy to accomplish, but is sometimes harder than it would seem. In this article two tricky scenarios were addressed

Porting WorkFlow from One List to Another List

Every first-time SharePoint Designer workflow author faces this problem:
Design a workflow solution.Create a new workflow solution.Test it.Gain user acceptance and sign off.
At this point, everything is going swimmingly until it’s time to … 5. Move to production … full stop.Today, there is no End User friendly way to move a functioning SharePoint Designer workflow solution from

Porting a Simple SharePoint Designer Workflow One List to AnotherOverviewThis tutorial style article describes how to port a SharePoint Designer workflow from one list to another. It assumes a business case where we want to move a dead simple workflow from a development environment to a production

Searching Site Collections Using a Tabbed Search Center

It is now time to put all of our resources together to build a more complex search center that can be used to search multiple team sites housed in their own site collections. You will need to have MOSS standard edition to complete all of these steps.
Since this is a project needed to accomplish within his organization, Chris Quick had documented the steps as he complete them himself!

Employee of The Day Slide Show

Some time very clear and easy requirement pinch us for developing a new webpart as lake of knowledge of all the OOB WebParts or some don't care attitude caused that.
The requirement I came across is showing the employees on the portal's home page.
We found the easy steps to do that.
  1. Convert each slide to a .jpg image (can be done very easily using PowerPoint 2007)
  2. Create a Picture Library named ‘Meet the Team’
  3. Upload the images to the ‘Meet the Team’ library
  4. Move to the page where you would like the slide show link created
  5. Insert the ‘This Week in Pictures’ web part onto the page
  6. Modify the Shared Web Part
  7. Change Image Library Name from “This Week in Pictures Library” to “Meet the Team”

Customized views of a SharePoint Survey

This article try to mitigate the problems around survey views. It has documented two techniques: one describes how to surface data using just the UI; the other shows you an easy way to add a view using SharePoint Designer (SPD).

Dynamic Loading of Content on Mouse Hover

Few lists on your page and a central Preview Pane, you can display a variety of content without clicking the mouse.
If you have SPD, you can make your own simple ASPX pages then link to them so you can load them dynamically in your pages. The possibilities are endless, have fun with this one!
Click “Read more” for setup instructions and the code sample…

Display Preview Pane for Calendar View


Many of our basic “tools” are missing from the Calendar View. The preview pane works great on other lists, so this little ditty gives you one for the Calendar too.

To make this work, place the Calendar in a large Web Part Zone–large enough to display the Calendar View, edit the view on the web part (it will default to a list). Place this code snipped in a Content Editor Web Part to the side, in the smaller zone.

How to Display SharePoint Blog Post Archives

Most blog engines allow you to display a list of blog posts grouped by month. Unfortunately out of the box SharePoint blog sites do not give you that ability. Here is a simple solution on how to overcome that limitation.
Please note that it only works with the default SharePoint Blog site template.

Sunday, February 15, 2009

Accordion-style left navigation menu for SharePoint Sites

If you can copy/paste, you can see it in action. Since I used Google’s API to load jQuery, you don’t even need to download the library file.
First, look at your left nav. If you changed it from the out-of-the-box setup, make sure you have “headers” and “submenus” that make sense. Click to get the more idea on this...

Visual Indicators for the Masses: KPIs in WSS

All of us must measure something in order to see if we are meeting our goals. They can be financial goals, customer satisfaction goals, or amount of work done measurements. KPIs (Key Performance Indicators) are a way to quickly gauge how you are doing, not by having to go through and analyze measurements through a spreadsheet, but through some simple visual indicators.
Putting KPIs into your dashboard allows you and your team to get an immediate view into how you are doing on your goals and measurements.

SharePoint comes with really cool web parts for presenting key performance indicators, but these are only available in the Enterprise edition. If you are running Windows SharePoint Services or SharePoint Server Standard, it is not available.

The only limitation of this concept is that you can only build KPIs on top of data stored in SharePoint lists.

Improving the SharePoint print experience

The ability to print web pages has been available for years. Comparing it to the transition that most browsers have gone through, there is very little that has changed about how web pages are printed.
While moving the digital version of a page to its paper equivalent, important information is not accessible to the print job. Luckily you can quite easily provide your visitors with a richer printing experience using no more than a couple of lines of JavaScript. Click to find the answer how???

List the time range of an event in a Calendar

Any way to have MOSS list the time range of an event in a Calendar View of a list instead of just the start time? Need to create an after hours schedule that shows start and end times but don’t really want to buy Calendar Plus if I don’t have to.
This solution: Create a calculated column to display as ‘Month View Title’:

List View Web Parts with File Size

Do you like the ease of the OOB List View Web Parts but hate the way it displays file size? Yeah, me too. I’d like to see the file size in either KB or MB right next to the file and only for client application files (like .pdf, doc., and .xls). Click here to learn more

Friday, February 13, 2009

Implement MAP using SharePoint List

Option-1
Example of how we can implement MAP using SharePoint Lits
How to build same page?
Some more help on this...
Option-2
Using this web part you can display points and locations on a Google map and get directions to an from that point. You can either manually enter an individual point or select a list from your Sharepoint site that holds the information that is required - ie. a field for the Buidling Name, its Longitude and its Lattitude.

Implement MSN Live Search for SharePoint site

To add Live search results to your existing SharePoint page that contains the search results web part:
The first thing is to sign up an Application ID for and download the SDK from
http://search.msn.com/developer/default.aspx?FORM=PDDD2

Create Chart from SharePoint List Data

How do you create a Chart in SharePoint using List data? I tried different approaches and at the end I found a better solution. Chart Web Part which demonstrate Silverlight feature as well.
For a small demo you can also visit http://www.wssdemo.com/Pages/graph.aspx

How to Resize the Web Part

I would love to have all iframes dynamically resize to fit their contents. The browser’s security restricts us to only dynamically resizing iframes from our own server’s domain.

Integrating External Document Repositories with SharePoint Server 2007

This article show how to take external repositories (Documentum, Interwoven, etc) and surface them in SharePoint as if they were a document library. This project goes way beyond a few web parts to integrate capabilities such as workflow and custom metadata. There is also a Code Gallery project with the implementation. Although the project is not a full CMIS implementation, it is based on the CMIS specification. Here is a screen shot of an external repository surfaced in SharePoint using Silverlight as the UI.
SCOT HILLIER's article on MSDN

A Quicker Way to Create Custom SharePoint List Templates

Andrew Connell said: Ever tried to create a custom list template for a SharePoint 3.0-based site? Something you thought was likely to be not such a big task quickly turned in to a nightmare of XML and GUIDs, right? Creating custom list templates is not a trivial task... nor is it a terribly good story. It's pretty darn complicated and can be quite an undertaking. A Quicker Way to Create Custom SharePoint List Templates

Thursday, February 12, 2009

Poadcasting Toolkit for SharePoint

The PKS is an accelerator for social media, using podcasting and social networks to deliver the next-generation knowledge management solution. Built on top of Office SharePoint Server 2007 and using Silverlight 2, the PKS delivers an integrated experience with a wide variety of podcast-capable devices including computers, iPod mobile digital devices, Zune digital media players, and Windows Mobile-based phones. For more information about how PKS can be used in your company, please see the following resources:
Announcing open source Podcasting Kit for SharePoint - the power of social media for the enterprise
Visit GetSharp, 3Sharp’s external implementation of PKS to see a live site in action
Download PKS for free at Codeplex

WSRP for SharePoint

Web Services for Remote Portlets (WSRP) Toolkit for Office SharePoint Server 2007. The WSRP Toolkit for SharePoint provides sample code for producing WSRP conformant data from SharePoint lists and libraries. External portal platforms (e.g. BEA AquaLogic Portal, IBM WebSphere Portal, SAP NetWeaver Enterprise Portal etc.) can then render SharePoint data natively through their WSRP consumer portlets. The Toolkit is available now for download from the MSDN Code Gallery.
The WSRP Toolkit for SharePoint consists of the following assets:
Visual Studio sample projects that demonstrate two different approaches to producing WSRP conformant output from SharePoint lists and libraries
A whitepaper that provides details on the different architectural approaches of the two WSRP producer samples
Screen casts showing the two WSRP producer samples in action
The Toolkit demonstrates two possible methods of exposing SharePoint data through the WSRP interface and is intended to provide a starting point for customers who are interested in surfacing SharePoint data in non Microsoft portal environments. The first method focuses on maintaining high fidelity with the SharePoint user interface and the second method focuses on providing flexibility and control over the rendered output. We are releasing the source code for the two methods under the
Microsoft Public License (Ms-PL), allowing developers to customize the solution to meet their specific requirements.

Organisation Chart or My Site in SharePoint

A good webpart available for free on Codeplex which help you to display your organisation chart.
A very good presentation is also available which help you to understand how MySite works.

Converting ASP.NET site to SharePoint

There are a lot of ASP.NET web developers who are moving to SharePoint site creation. This article will explain in detail how an ASP.NET webpage developed in Visual Studio can be converted into a SharePoint site.
http://www.codeproject.com/KB/sharepoint/ASPNET_to_Sharepoint.aspx

Insert Data into SharePoint List with Lookup column

As a part of migration process, how can you insert a data in to the SharePoint Lists which will be having a lookup column???
Click Here to find out the answer :)
There is an adapter of SharePoint List for SSIS is also available.
If you don't want to go with adapter this is the way how you can create your own SSIS pacakage. Only drawback is it is not talking about inserting data in to lookup columns.

There is one tool also available who can help you in data migration from Database to SharePoint Lists. Data-Synchronisation-Studio

In addition, here is a good blog to describe how to use BDC to connect to Oracle Databases

User Control in SharePoint

If you want to use UserControls in SharePoint web parts you can use SmartPart
But you can also build a web part that load a UserControl yourself

SharePoint Pre-Sales Help

I devoted some of my time in pre-sales activity for SharePoint as well.

Using ASP.NET 2.0 code behind in SharePoint

I am working on a migration project from ASP.NET to SharePoint and this article saves my time
Andrew Connell again...

Videos for SharePoint

Some of the best videos I found which will be very helpfull for the MOSS Developers.
Visual How Tos
SharePoint Screencasts
Video on Demand from EndUserSharePoint

How Do I ScreenCast

Anonymous user can Search on Public Site

If you have a public Sharepoint site (MOSS 2007 or WSS 3.0) that is accessible to anonymous users and you’re not using custom scopes, you probably already noticed that every time users try to search they get a user prompt. To get pass this prompt you must enter valid username, otherwise you’ll get famous “Access Denied” page. So much for anonymous access, right?

Anyway, the problem is with OSSSearchResults.aspx page, specifically with one of the inheritance reference that ASPX page. I’m talking about the part of the code that sets the inheritance of the page from the generic application page base class, which is not really required for this page to function properly.
To allow anonymous users to search your publicly available sites you need to remove that inheritance from the code, so find part of the code inside the tag that states “Inherits="Microsoft.SharePoint.WebControls.LayoutsPageBase" and remove that part of the code (not the whole line, just the part that inhertis the application page base.) OSSSearchResults.aspx page is usually stored at C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS on your SharePoint server. Make sure you backup the file before making any changes!

Making those changes will not only allow anonymous users to search the SharePoint content, but also will keep the SharePoint search secure, meaning that anonymous users will only be able to search the part of the SharePoint they have permissions to view.

Dual Authentication for SharePoint

This article will help to understand how we can apply dual authentication on a single SharePoint site.
This is the first article I read on Andrew Connell's blog and after that I never stop following him.

Comperision on MOSS-2007 Vs. WSS 3.0

Lots of time we faced questions related to what is there in MOSS-2007 which is not available free with WSS 3.0. This article will help you to find out the clear comparison on that.

Multilingual site in SharePoint

On one fine day morning I was asked by my manager to implement Multilingual for one of the site. I was bit worried and started searching and thanks to google I come across one of the best article which will help you to implement multilingual for SharePoint sites.
I came across one editor as well which will help you for SharePoint Variations.

Site Collection in SharePoint

There is a real confusion around the word Site Collection in SharePoint. I tried to find out the answer for that and I found this article

Customizing Search Result

Lots of time I come across the requirement of how we can customize out of box search result page and I find the answer here...

What is Feature Stapling in SharePoint

Feature Stapling allows you to create a feature and then associate it with any site definition without ever touching the site definition files themselves. Your feature will be executed when the site is being provisioned. To know more Click Here

Six-part series on ASP.NET Master Pages and SharePoint

This links will help on how we can use ASP.NET master page within SharePoint
  1. Introduction to Master Pages.
  2. Examining the out of the box Master Pages in SharePoint.
  3. Developing a custom Master Page for SharePoint.
  4. Deploy a Master Page for a production ready system.
  5. Customizing the Application.master Page.
  6. Incorporating a Master Page into a SharePoint site definition

A six-part series on getting the most out of SharePoint Designer 2007

This link will provide a Demo for how you can use SharePoint Designer.
http://office.microsoft.com/en-us/help/HA102199841033.aspx

I also found a good article on SharePoint Designer here...

Everything You Need to Know about BDC

I am still waiting for the article to finish all its 8 parts on SharePoint Magazine... meanwhile I found, There are two approaches for working with BDC: creating the XML schemas manually or employing SharePoint's Object Model to programmatically interact with the LOB system.

This is one of the good article I found on SharePoint Magazine. This article containing 8 parts. I am listing 5 out of 8 as others are still not published.

Part 1, BDC Technical Architecture
Part 2, Application Definition File (ADF) and its Development
Part 3, Developing an ADF to Connect to Web Services
Part 4, Using BDC Web Parts to Consume BDC Data and Embedding BDC Data in Lists
Part 5, configure Enterprise Search to crawl BDC data.
Part 6, importing User Profiles from BDC
Part 7, BDC Object Model


How you can Connect Lookup Fields?

This link will give you a better idea how you can have a kind of Parent-child relations with two lookup columns. Eg. Country & State

http://blogs.msdn.com/leonidly/archive/2007/06/24/connected-lookup-field.aspx
Connected Lookup Code

Dynamic Connected Lookup for SharePoint

Create a Feature: Master Pages for Site Collections