Monday, January 25, 2010

SQL Queries

TABLES:

1) Table name - programmer

name not null varchar2(8) name
dob not null date date of birth
doj not null date date of joining
sex not null varchar2(1) male or female
prof1 varchar2(8) known language 1
prof2 varchar2(8) known language 2
salary not null number(4) salary
Thursday, January 21, 2010

Singleton Pattern (Creational)

AIM:
Restrict instantiation of a class to one object and provide a global point of access to the object.
Class Diagram:


How to Increase the maximum size of list templates?

Problem / Issue:
Saving a list as template is an easy way of transferring data from one place to another in SharePoint. By default, however the maximum size of list templates in  WSS3.0 and MOSS 2007 is 10 MB.

If you try to save the list as template that is larger than this you will get the follwoing error.
The list is too large to save as a template. The size of a template cannot exceed 10485760 bytes.

How to print multi line text in InfoPath

Problem: If a multi line text box is used in an InfoPath form and in default print view only prints the text visible in the scroll box, not all the text contained within the field. So how do you make a print view so that all the text is printable?
Wednesday, January 20, 2010

Understanding Design Patterns

What is Design Pattern and why it is so important?

Before explaining what design pattern is, we will look into why we need to learn design patterns. As a software or application developer, we do write a lot of code every day to deliver the software/application. Most of the people write the code in different ways; someone writes all logic into one single file and someone separates that code into multiple files.
Tuesday, November 10, 2009

How to uncheck the send welcome email checkbox option globally?

In SharePoint, we have an option (checkbox) to send a welcome email to newly added users and this checkbox is checked by default. In my case this option is vary annoying since in most cases we don’t send an email to newly added users but sometimes i forgot to uncheck the checkbox. So i started looking into ways to ease my life.

First thing i want to find is,  was there any global setting to flip the checkbox? but there is none. So my next option is modify/edit the aclInv.aspx page which is in Layouts folder in SharePoint hive.

  1. Navigate to SharePoint Hive\TEMPLATE\LAYUTS folder.
  2. Find the aclInv.aspx file.
  3. This step is optional but I recommend to backup this file before making any changes.
  4. open the aclInv.aspx in editor.
  5. Search for “chkSendEmail”.
  6. Change Checked property from True to False.
  7. Save the page.

Repeat the same steps in all web front end servers.

Friday, February 20, 2009

What’s the Purpose of Shared Service Provider (SSP) in SharePoint (MOSS) 2007?

Most of you already know that SharePoint gives you the ability to crate and host multiple separate web applications,for example, intranet site, internet/Extranet, Team site, etc. In MOSS 2007, Microsoft comes with a new concept of Shared Services Providers(SSP). The idea behind this concept is to manage and share certain services centrally instead of each web application level. The best examples are Profiles and Search service. Using Profile service, you can import all of the user information from Active Directory once and then use  that data within different web applications. In the same way you can also setup the search service one time and then share it across multiple web applications. It make prefect sense, right?

 

The major services that are handled by SSP are,

  • Profiles
  • Search
  • Indexing
  • My Sites
  • Audiences
  • Excel Services
  • Business Data Catalog (BDC)

Another major advantage of SSPs is separation of roles. It is most common in medium to large server farms to have one group administrating the physical servers and another group maintain search/profiles. Since SSP is its own site collection, you can define a user access so that they can not access Central Administration site but they can access the SSP. Even in SSP you can limit then what they can access.

 

As a general rule, you use single SSP. But there are some scenarios you may want to create multiple SSPs. For example, you may need separate set of permissions and services for intranet site and extra net site. You have to be vary cautious about creating multiple SSPs.

 

Final Thoughts

Shared Service Providers (SSPs) are one of the great feature in MOSS 2007. Creations of SSPs should be part of your initial planning. In SSPs, You can grant permissions at a granular level or broad access.

 

I hope this was useful and you understand clearly what’s the purpose of SSPs?