About Me

My photo
a Dynamic and Energetic guy.....

Monday, June 27, 2016

Configuration of Multi-Lingual SharePoint Sites

When we need to display our SharePoint portal with different languages we can enable site variations, that is an in-built feature comes with SharePoint. For that first we need to identify necessary languages for the proposed SharePoint site. In this case I will configure Arabic language along with English.
First we need to download Arabic Language Pack for SharePoint.

Then we have to install language pack for application servers + web front end servers.

We can verify whether the relevant LANGUAGE PACKS are installed via central administration.

In central administration àManage Patch Status under “Upgrade and Migration” section
Then we have to go to relevant site collection and,
Site Settings àVariation Labels

There we can see current labels (in this case, English) and I’m going to create new label for Arabic.

We will go through a 5 step wizard and it starts by picking the necessary language. We will get a drop down with the available languages. Then we have to pick a LOCALE also for the required Language.
Then we have to assign a NAME to LABEL. It will append to the URL (here http://spsvr:ar-sa)

There we have to specify “Display Name” and “Hierarchy Creation”. We can choose,
·         Publishing sites, List and pages OR
·         Publishing pages OR
·         Root site only

In step 3, we have to specify how we can set whether users to translate the whole SharePoint site. Machine translation is also possible if “Machine Translation Service” is running on servers.

We can check it via Central Administration à Services on Server

Then we have to go the step 4, that is the CONTENT changing mechanism and Page Update behavior. There we can set either,
1) User can manually sync update
2) Automatically update sites using SharePoint timer jobs

After all, steps we can verify all the settings in the Steps 5. Then Finish the wizard.

We can see our latest Site variations in the
Site settings à Variation Labels as “ar-sa

When we go to Site settings à Variation Logs, we can see important messages. That is about SharePoint timer jobs.

 So it is better to go and check newly created SharePoint timer jobs,
It is called “Variations Create Hierarchies Job definition” and it will do the content translation.

We have to wait our SharePoint timer jobs do the backend work.
That will create of new SITES for new Multi-linguals. In this scenario we can see newly create Sub-Site called “Arabic (Saudi Arabia)” under root site collection.

When we go to the site we can Pages are created and waiting for PUBLISH.

After that we have to Approve Page to view normal users.

Then we can navigate to language SITE that we want.

We can click the RIBBON and check the content.

We can also take necessary actions within the site with ARABIC language.

It is a cool feature that comes with SharePoint to enable MULTI-LINGUAL sites.

Monday, June 13, 2016

Search a SQL TABLE within ALL SQL Databases

When we want to find a TABLE among all DATABASES there is no such query.
In that case we have to JOIN SYS.TABLES and SYS.SCHEMAS.
We can use following SQL Script to FIND tables Named as 'SOCIAL'.

DECLARE @AllTables table (DbName sysname,SchemaName sysname, TableName sysname)
     @SearchDb nvarchar(200)
    ,@SearchSchema nvarchar(200)
    ,@SearchTable nvarchar(200)
    ,@SQL nvarchar(4000)
SET @SearchDb='%'
SET @SearchSchema='%'
SET @SearchTable='%SOCIAL%'
SET @SQL='select ''?'' as DbName, s.name as SchemaName, t.name as TableName from [?].sys.tables t inner join sys.schemas s on t.schema_id=s.schema_id WHERE ''?'' LIKE '''+@SearchDb+''' AND s.name LIKE '''+@SearchSchema+''' AND t.name LIKE '''+@SearchTable+''''

INSERT INTO @AllTables (DbName, SchemaName, TableName)
    EXEC sp_msforeachdb @SQL
SELECT * FROM @AllTables ORDER BY DbName, SchemaName, TableName

Can see the RESULTS.

Sunday, June 12, 2016


                                         SharePoint is implemented and developed for the content management. With the loads of content including documents, images and videos the SharePoint bare a lot of data. Then it is essential to find the data in speed manner with usability. For that SharePoint introduces SEARCH itself. On the other hand Microsoft invested a lot of money to build their own search engine, so called FAST Search. Until SharePoint 2010, the search mechanism was purely based within SharePoint and had limitations. With the implementation of SharePoint 2013, the FAST search also integrated and bundled FREE with SharePoint.
SharePoint Search is introduced with a lot of usable features for content users. The Search is categorized as,
1)      Everything
2)      People
3)      Conversions
4)      Videos

With the introduction of PEOPLE section, the end users can search employees using their Active directory features. To enable PEOPLE search, the SharePoint portal should be provisioned with User Profile Synchronization. After the enablement of Sync service, the Active Directory information will be fetched to the SharePoint and will be crawled, searchable with user inputs. 
With SharePoint 2013 the Search results page has been modified and enhanced with, 
1) Doc Preview
2) Result Categorization
3) Author wise categorization
4) Modified date categorization

Set Up A Search Center

First Search Service Application Should be provisioned via Central Administration. There we have to specify search service account,
And app pool for Search Service application and another app pool for Search Processing.

After that we have to create a Search Center Site Collection to link with SharePoint portal,

Finally, we have to link newly created Search Center Site with the content portal to facilitate end users to connect and find data,

Search Center Administration

After we have configured SharePoint Search Centre via Central Administration, Administrators can verify the “Search Administration” and the status.

 The “Search Application Topology” is consists of, 
1) Admin (Service Application)
2) Crawler
3) Content Processing
4) Analytics Processing
5) Query Processing
6) Index Partition, modules. 
All elements should be in GREEN status to crawl the items in the SharePoint repository and processing with search center. With the configuration SharePoint creates 4 databases for Administration, analytics reporting, Crawling and linking information. We can allocate a dedicated server for SharePoint Search within the FARM to reduce the load to other application servers.
First we have to set data sources that needs to bind with SharePoint Search. With new features we can assign different data sources to crawl with SharePoint and display results within portal. (SharePoint Sites, My-Sites, Internet Sites)

Also we can set crawling intervals for INCREMENTAL and FULL crawling. This will use a lot of resources, hence the interval should be decided after analysis of exact data availability. If frequently updating site, then crawling can be 2 hours.

Administrators can start any CRAWL at any time via “Search Administration” page. The crawling will take few minutes to few hours depends on the content and number of sites set in the CONTENT SOURCES section. After a crawl, we can view the crawl log and statistical information. It give last 24 hours, last 7 days and last month statistics with number of ITEMS dealt with the crawl. Number of scanned items, deleted items between last 2 crawls can be viewed using stats report. Administrators can view item-wise status and time intervals.

Search Rules

After configured Search Center, admins can create RULES to exclude items. It can be se via Crawl Rules.
Normal Search Result
When we search “SharePoint” word within portal, we will see results including my uploaded document “What is SharePoint”.

When we apply Crawl Rule, to EXLUDE items from a document library as follows,
Do the crawling, we can see search results with EXCLUDED items.

We can EXCLUDE search items using, 
1) URLs
2) Key Terms
3) Specific words while using elevated privileges.

Crawl Reports

With the enhanced Search analytics, SharePoint can produce reports with different schema. The 
1) Crawl Rate
2) Crawl Latency
3) CPU and Memory Load
4) Crawl Queue can be viewed with date filters.

It is little about SharePoint Search and its features.

My Masters