Tuesday, November 30, 2010

How to Disable Large List Resource Throttling in SharePoint 2010

Users of a site may require access to all the items in a list, even if that list’s views contain more items than have been allotted for the web application in Central Administration. The Resource Throttling options available allow administrators to set a block of time each day during which large list resource throttling does not occur. 

During this time, any user will be able to access the list and any views on that list without the list being throttled by the server. It is possible that during this time the server may take a performance hit while rendering huge amounts of data or if multiple users are accessing a large list simultaneously. Therefore, it is advisable to set the time window during off-peak hours, or when traffic to the server is at a minimum.

Setting the time block during which list throttling will not occur is done in Central Administration in the Resource Throttling options for each web application. The steps below outline the process for setting the daily time window:

  1. From the Central Administration homepage, click Application Management.
  2. Click Manage Web Applications.
  3. Select a Web application from the list.
  4. In the Ribbon, click the dropdown under General Settings.
  5. Click Resource Throttling.
  6. In the Daily Time Window for Large Queries section, check the box to enable the time window.
  7. Choose the hour that the time window should start, and select the number of hours it will remain open.

It is important to keep in mind the performance impact this could have on the servers, so set the time window accordingly. 

Another option available for some users (generally developers) who have certain privileges is to use the object model override to access the items in the list. This can be accomplished using Windows PowerShell or Visual Studio and allows users with proper rights access to a larger subset of items at a time, even if resource throttling is enabled. However, even with the object model override, users will still be restricted to the limit set for administrators and auditors. 

You should note the following when using the list throttling capabilities of SharePoint Server 2010:
The local server Administrator account is not affected by the list throttling settings. Therefore, the server Administrator has full, unrestricted access to the list. 

The Daily Time Window is not necessarily a hard cut-off time for access to the list. For example, if a user is accessing a large view of the list that is taking a long time to render, the list will finish loading even if the end of the Daily Time Window has been reached. Then, the list will be throttled once again.

Source: FROM Microsoft E-Learning

Monday, November 29, 2010

What about Web Analytics Reports in SharePoint 2010

If you are web master of web administrator, now you want to handle the traffic and bandwidth of your site, you may use Google Analytic. Everyday or everyweek (even for monthly) you will get the number of unique visitor, hits and the details of bandwidth of your site.

For now, you don't need to do that and even not necessary to  use extern service on your site. SharePoint 2010 supported a new feature to manage your site for web master. In fact, this feature has not supported full the control like Google Analytic, but in a simple way, you know at least the visitor worked on your site and to do something on it.

From the left menu, click on Monitoring -> Web Analytics Reports

For each site, SharePoint shows the traffic, search engine and inventory. When the customer use the search engine on your site, SharePoint crawls all the keywords, number of queries, the number of queries on day,...it's very helpful to web master or administrator who manage the site.

However, SharePoint does not collect the number of user browsing your site on what of browser, or the information of user using URL referer or directly from your site. Hope that, this may help you manage the site on SharePoint 2010 better.

In fact, you can customize this report or develop the report with much more functionalities. SharePoint 2010 will show the graphic UI for your report in the Customize Category.

Click on Customize Reports at the left bottom of the summary page. it redirects to a document library, here is the report list. It's hidden.

All information of report summary are here, now you could add more reports or everything you want.
The details of each report can be displayed as a graphic like this:

Yeah, that's perfect!

In the next post, I will show you how to add more the custom report and show it as UI graphic like SharePoint 2010.

Wednesday, November 24, 2010

How to change the limitation of number items in BDC using PowerShell

This is a good link to learn about using PowerShell Mangement (SharePoint Designer) with BDC in SharePoint 2010.


In Lionelro's topic, he explained and show you what about limitation of number items in BDC when you are using SharePoint Designer and PowerShell. However, I want to show you a short term to change the default limitation using PowerShell.

Start PowerShell Management

Run these scripts:

$dbRule = Get-SPBusinessDataCatalogThrottleConfig -ScopeDatabase -ThrottleType Items -ServiceApplicationProxy$bdcProxy 

#Default and Maximum must be provided together. This increases the limit for external lists to 3000.
Set-SPBusinessDataCatalogThrottleConfig -Identity $dbRule -Maximum 1000000 -Default 3000

Just execute above commands it will change the default limitation of number items when you get the data from BDC.

Good luck.

How to fix error "Cannot connect to the configuration database"

When you try to view your Microsoft Windows SharePoint Services 2.0 Web site, you receive the following error message: Cannot connect to the configuration database.

Please read this KB to know how to fix this error: http://support.microsoft.com/kb/823287

On that KB, Microsoft explains 4 situations may happen that error and lead to verify on your system. But another reason was found and often causes if you are running on SharePoint Farm or using Domain account to configure out the SharePoint.

1) On SharePoint Farm

You should check on your server in which hosting SharePoint Central Admin the Local Users & Groups to find out whether any account did not deduce to fullname account. That means each of account in Local Users & Groups must be show full name of that account and you will see them very clearly. 

For example: when you get the error "cannot connect to the configuration database", let do the following instruction. 
-> from Start Menu -> Run -> type compmgmt.msc then Enter. After windows opens, expand Local Users & Group, click to open Groups, and then double-click on any group. You will see the error like that:

Because the domain account did not deduce on your system, so SharePoint can not connect to SQL server and that error happens.

For double-hop, you should verify this thing both on SQL machine where is hosting your SQL and SharePoint Central Admin.

Note: Don't try to remove that account and re-add them.

To fix this issue, just disconnect both your system from your domain and join to the domain again.

2) On Single Server using Internal DataBase (connect to MICROSOFT##SSEE)

If on single server happens this issue, please remove the account to connect to SQL group in Local Users & Groups. Find in all SQL groups and WSS/MOSS group and remove that account out of group, then add this account into that group again.

Good luck.

Saturday, November 13, 2010

How to connect to MICROSOFT##SSEE (Windows Internal Database)

When we run the wizard configuration for SharePoint, we have 2 options to install: Web Front-End and Standard. For Web Front-End, we will use a specific SQL server, database and account to login. For standard, we needn't install SQL Server, so we won't specify SQL Server name, database and account, SharePoint will install a minimum SQL server with windows authentication. You never know what the server name is, however, you can open Registy Editor to see the currently server name SharePoint is using.

[To open Registry Editor from Windows Start -> Run -> type Regedit and then press Enter] Expand the following path:

[SharePoint 2007] HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0\Secure\ConfigDB

[SharePoint 2010] HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure\ConfigDB

On the left handsite, you will see the property DNS with the value like this:

Data Source=WSS2K3X86Final\Microsoft##SSEE;Initial Catalog=SharePoint_Config_d3e9e3d0-4d67-48fb-9242-4e46b0021086;Integrated Security=True;Enlist=False

Yeah, for now you can install SQL Server on that server to try to connect to SharePoint Standard server with  server name above. The result is "can not connect to database server"!

In fact, SSEE means SharePoint Service Embedded Edition server, it's connected through Name Pipe. To find out the name pipe server, the following step to show you.

1) Run SQL Server Configuration Manager:

The Windows Internal Database is connecting to MICROSOFT##SSEE is currently to use for SharePoint. Now, click on Protocols for Microsoft##SSEE

2) The name pipe shows as following picture:

3) Double click on Name Pipes to see the server link to connect:

Now, you can connect to \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

Friday, November 12, 2010

How to Customize the Document Set Ribbon

In this article, we will extend that sample by adding a new menu to download all files in the Document Set, check out selected files, check in selected files and send selected files as links.  We will walk through the example, and we will also provide a finished program and scripts that you can use to upload in your SharePoint server.

Here is Full Blog :


Thursday, November 4, 2010

25 ways to be healthier / 25 cách để sống khỏe hơn.

1.)      Brush twice a day!

2.)    Dress right for the weather.

      Visit the dentist regularly.  

   Get plenty of rest.

       Make sure your hair is dry before going outside..


     Eat right.

     Get outside in the sun every once in a while.

      Always wear a seatbelt.

   Control your drinking of alcoholic beverages.

  Smile!  It will make you feel better.


    Don't over indulge yourself.

   Bathe regularly.

   Read to exercise the brain.

  Surround yourself with friends.

   Stay away from too much caffeine.

  Use the bathroom regularly.


  Get plenty of exercise.

   Have your eyes checked regularly.

  Eat plenty of vegetables

Believe that people will like you for who you are.

   Forgive and forget.

  Take plenty of vacations

  Celebrate all special occasions.

24.)  Pick up a hobby.

Love your neighbor as yourself. 

 Send this to your
computer buds to give them a warm fuzzy! 

Pictures: copy from the internet. Relax!