Tuesday, August 10, 2010

SP Server 2010 Capacity Boundaries Limits

To know SharePoint Server 2010 capacity boundaries click here:
Click here

Multilingual User Interface (MUI) in SharePoint 2010

SharePoint finally provides a decent out of the box multilingual user experience for collaboration scenario’s with the introduction of SharePoint Server 2010 and SharePoint Foundation 2010. After you installed the necessary language packs you will have the option to enable the multilingual user interface (MUI) on a per site basis using site settings .
Language Pack you can install using following thread:
Click here
Once you enable alternate languages, users will see a language picker control in the top right of the page where they can switch the site to the language of their choice - this is a huge improvement in comparison with 2007.

Business Connectivity Services (BCS) Using SQL & SharePoint Designer 2010

Using SQL Server
Step1: Create table in Sql data base.
Step2: Open SharePoint site in SharePoint Designer 2010.
Step3: Click on "External Content Type" in Left Nav bar.
Step4: Click "External Content Type" in ribbon control to create new external content type.
Step5: Fill "Name" property.
Step6: Click the line “Discover external data source and define operations” and in the new screen, click “Add Connection” and select “SQL”.
Step7: Fill Database server name and database name.
Step8: Right click on your table name and click on "All operation"(In DataSource Explorer)
Step9: Check identifier and click next button.
Step10: Select Sorting option and click next.
Step11:Click Finish buton.
Step12:Now go to Central Administration ==> Application Management ==> Service Application ==> Business Data Connectivity and click “Manage” from the top Ribbon
Step 13:Click “Edit” from the Ribbon and select “Configure” to configure the path for the “Profile Page” and click ok.
Step14:Generate the profile page for the External Content Type,by click on the dropdown ==> “Create/Upgrade Profile Page”.
Step15:Create “External List” to consume this data from SQL Server.
Step16: Select the “External Content Type ” and click “Create” to create the list.
Step17:Enjoy...