Thursday, December 26, 2013

Sharepoint 2010 Metadata

SharePoint Metadata is advancing with the versions and if you know how to work with the metadata you can make it easier for the users to search, locate, organise and use stuff within your organization.

The tags and the site columns makes it easier to get what you need within the search query, Below is a video from Sean Bordner who explains sites columns, Content Types, Term Store and Term set with real world examples we really found it useful and think if you spend 21 minutes here you can understand the sharepoint metadata in a better way

Wednesday, December 25, 2013

Practice question answers for exam 70-332 | Advanced Solutions of Microsoft SharePoint Server 2013

If you are looking forward to clear 70-332 paper and looking for practice questions answers like me, here i have combined a set of links which can be useful.

The best place where i could see the questions and answers is

I am listing down the links to go step by step these are 12 part series which contains 70 questions and answers which might give you an idea of stuff you can expect in 70-332 paper


I will add more links here when I make progress.

More information can be found at

Friday, November 22, 2013

Linked table is unavailable. Microsoft access cannot contact the server.

Linked table is unavailable. Microsoft access cannot contact the server.
We got this error message when we tried to export our big fat list to “open with access”
We recently found this issue coming up for one of our lists and we are still searching for the solution but when I tried googlng for solution. The only part I found was a hot fix. We have users complaining about this list not working since morning and the hotfix would not make any sense at this moment because it used to work and everyone swears no changes were made.  
What should be your check list for such type of issue? I have tried to list what I did, hope it helps you.
1.       What are the statists of the list.
·         Number of columns
·         Number of items
·         Number of lookup columns
This part in my case was way above the ordinary 163 columns and 12 thousand+ items
2.       Does it work with a different view and less columns
3.       Does it work with Access 2007 and Access 2010
4.       Does it work with a other lists in the same site or sub site (this worked for me)
5.       Does export to excel option works ( this one didn’t work for me, it just helped us to drill the problem down further to the list contents)
6.       I saved the list as a template without content and created list again and tried opening with access (this worked – not sure what that really mean)
7.       Can you apply the hotfix;EN-US;2552989

Close assumptions:
According to the kb 270262
You cannot receive data from SharePoint lists in Microsoft Access if the following conditions are true:
  • When there is a problem with the health of the Microsoft SharePoint Server (for example, it runs slowly).
  • You have a low bandwidth connection.
  • You have a large or complex SharePoint list/document library.
  • There is a large distance between you and the server.
  • There are more than 255 columns in the SharePoint list/document library.

Out of this the large distance to server sounds funny.  The only point I could use to my defense was” You have a large or complex SharePoint list/document library.”
But MS did not specify what that meant so I checked on the threshold section of MSDN  at
Which says :
SharePoint Server 2013 data is stored in SQL Server tables. To allow for the maximum number of possible columns in a SharePoint list, SharePoint Server 2013 will create several rows in the database when data will not fit on a single row. This is called row wrapping.
To prevent too much load, by default a maximum of six SQL Server rows are allowed Each time that a row is wrapped in SQL Server, an additional query load is put on the server when that item is queried because a SQL join must be included in the query. for a SharePoint item. This limit leads to a particular limitation on the number of columns of each type that can be included in a SharePoint list. The following table describes the limits for each column type.
The row wrapping parameter can be increased beyond six, but this may result in too much load on the server. Performance testing is recommended before exceeding this limit.
And you can find from the table how row wrapping is determined.
For Single line of text SQL Server row wrapping occurs after each 64 columns in a SharePoint list.
So on and so forth. Please check the technet link for more information.
This could be a reason of the error message popping up.
As mentioned I was still not able to determine the cause, will update this article when I can.

Thursday, November 7, 2013

Downloadable resources about how to plan for SharePoint 2013

Architecture icon Technical diagrams for SharePoint 2013

Checklist icon
Planning worksheets for SharePoint 2013 

What's new icon (stem)
SharePoint Server IT Pro Reviewer's Guide 

Video (play button) icon
Video demos and training for SharePoint 2013 


Boundaries, thresholds and supported limits in SharePoint 2013

In SharePoint Server 2013, there are certain limits that are by design and cannot be exceeded, and other limits that are set to default values that may be changed by the farm administrator. There are also certain limits that are not represented by a configurable value, such as the number of site collections per web application.

Plan browser support in SharePoint 2013

Supported Internet Explorer versions

The product group makes every effort to validate that SharePoint functionality works correctly with released versions of Internet Explorer. Customers who want a more deeply validated browser interaction experience should strongly consider Internet Explorer.

Internet Explorer 10, Internet Explorer 9, Internet Explorer 8

Other supported browsers

Wednesday, November 6, 2013

Browser support with SharePoint Foundation 2010

SharePoint Needs optimal browser for best performance and you would need to know the supported browsers before you plan to use it for your company, no points for guessing that Microsoft would support their own Browser much more than the other popular ones available in the market.

  • IE6 is not supported by Microsoft as it’s an outdated version
  • IE 7 to 11 are supported in both 32 and 64 bit flavors.

ActiveX controls

Some functionality in SharePoint Foundation 2010 requires the use of ActiveX controls. This produces limitations on browsers which do not support ActiveX. Currently only 32-bit versions of Internet Explorer support this functionality. All other browsers have the limitations.

Mobile browser support

  • Windows Phone 7.0 Internet Explorer
  • Apple iOS 4.0 Safari
  • Google Android 2.1 Android Browser
  • Research in Motion (RIM) Blackberry 4.0 Blackberry Browser
  • Nokia Symbian 3 Nokia Browser

Is SharePoint 2007 really outdated?

If you are one amongst the people who joined this amazing product in 2007 when it was in full boom and were comfy working with the Central Admin and the SSP and then when you rubbed your soul into it you got the new ribbons and stuff around ...I know how it feels.

MOSS is classy, its seems like your working on something.. a website ... the ribbons in 2010 just makes everything look like Office but yes we do need then so the end users can explore all the functionality of options available.

But we have to move on as everyone does .. Still there are organizations stuck with 2007 because the cost of upgrade is something they need to think upon. For the 2007 Share pointers I have something here.

Here is downloadable content for 2007 that you can read and use as per your needs.

Wednesday, October 2, 2013

SharePoint 2013 updates

June 2013 CU + April 2013 CU + March Public Update for SharePoint 2013

June 2013 CU for SharePoint 2013
The KB articles for June CU will be available at the following locations in a couple of days:
  • KB 2817346 - SharePoint Foundation 2013 June 2013 CU
  • KB 2817414 - SharePoint Server 2013 June 2013 CU
  • KB 2817415 - SharePoint Server 2013 with Project Server June 2013 CU
  • KB 2817350 - Office Web Apps Server 2013 June 2013 CU
The Full Server Packages for June 2013 CU are available through the following links:
April 2013 CU for SharePoint 2013
March Public Update for SharePoint 2013
Install future cumulative updates for SharePoint 2013 it will be mandatory to first install the March public update.
  • KB 2768000 - SharePoint Foundation 2013
  • KB 2767999 - SharePoint Server 2013
  • KB 2768001 - Project Server 2013
The Full Server Packages for March 2013 PU are available through the following links:

Download IE links

How to Repair IE10 in windows 7

  1. Close all Internet Explorer and Explorer windows that are currently open.
  2. Start Internet Explorer.
  3. On the Tools menu, tap or click Internet options. If you don't see the Tools menu, press Alt.
  4. In the Internet Options window, tap or click the Advanced tab.
  5. Tap or click Reset. If you're using Windows Internet Explorer 6, click Restore Default.
  6. In the Reset Internet Explorer Settings dialog box, tap or click Reset.
  7. Select the Delete personal settings check box if you also want to remove browsing history, search providers, Accelerators, home pages, Tracking Protection, and ActiveX Filtering data.
  8. When Internet Explorer finishes applying default settings, tap or click Close, and then tap or click OK.
  9. Exit and then start Internet Explorer.

Friday, July 19, 2013

How to change image library location in SharePoint Blog site?

First of all it depends on which method you are using to publish blog?
Is it using MS Word?
Or you are directly creating posts on blog site?

If you are using MS Word
If you are using MS Word to publish post to SharePoint Blog site then it will automatically publish images to "Photos" picture library.
Below are the steps to change the default location
  • Open MS Word > New > Blog
  • Manage Accounts > Select the account and click on change
  • Click "Picture Option", this will give you 3 more option - SharePoint Blog, My Own Server and don't upload images
  • Select the second option
  • Provide URL of another picture library where you want to upload images into source and upload URL, click OK.
  • It will give you pop up after successful registration

Direct posting on SharePoint Blog site
If you are directly creating posts inside blog site then you have to first create another picture library and while you are inserting an image it will give an option where to save this image.

Thursday, July 4, 2013

SharePoint Optimization: ADC Implementation Tips & Methodologies

Optimize SharePoint deployments – dramatic performance improvements.
Windows IT Pro | Welcome

White Paper:SharePoint Performance Optimization Download this white paper
Download this step-by-step guide for SharePoint optimization through implementation of application delivery controller (ADC). Information Systems professionals can increase user productivity while also reducing the computational and budget resources needed to provide mission critical applications.
Learn about:
  • Obtaining high availability for SharePoint Servers
  • Distributing client traffic seamlessly across multiple SharePoint WFE Servers to improve site scalability
  • Supporting higher connection throughput and faster end user response times, and reduce WFE CPU utilization by initiating SSL offload, HTTP Compression, RAM Caching and Connection Reuse
  • Improving site performance and reliability to end users and more!
Click here to get this limited guide today.
Check out SharePoint Pro Resources to see a full listing of available
eBooks, white papers and essential guides.

Wednesday, July 3, 2013

Session state can only be used when enableSessionState is set to true, either in a configuration file or in the Page directive- SharePoint2010

Complete Error Message
Session state can only be used when enableSessionState is set to true, either in a configuration file or in the Page directive. Please also make sure that System.Web.SessionStateModule or a custom session state module is included in the <configuration>\<system.web>\<httpModules> section in the application configuration.
Before you start your troubleshooting, make sure that the State Service service application is running. How you will check this?

The security validation for this page has timed out. Click Back in your Web browser, refresh the page, and try your operation again

Problem Description
The security validation for this page has timed out" error message when a user submits data to Windows SharePoint Services

Error Message
The security validation for this page has timed out. Click back in your Web browser, refresh the page, and try your operation again.

If you are facing this error message then Microsoft has already published an article on this which is very useful and resolves your issues. Million thanks to Microsoft for publishing this detail information along with root cause.
Thanks to MS


Content databases contain orphaned items

Problem Description
The SharePoint Health Analyzer detected an error. 

Content databases contain orphaned items.

EXECUTE permission was denied on the object 'proc_putObject', database 'SharePoint_Config', schema 'dbo'

Problem Description
While I was deploying my solution , got an exception as follows

Error MessageEXECUTE permission was denied on the object 'proc_putObject', database 'SharePoint_Config', schema 'dbo'

Reference links for March Public Update for SharePoint 2013
  • Windows could not start the SharePoint 2010 administration service on local computer.

    SP Version: Microsoft SharePoint Server 2010-SP1
    Server: Windows Server 2008 R2

    Problem DescriptionNot able to start the SharePoint Administration 2010 Service in services.msc

    ErrorWindows could not start the SharePoint 2010 administration service on local computer. 

    Adding an Email Link in SharePoint site page

    There was a requirement raised by one of my user to add Email lnk to the SharePoint site page, I followed below steps to achieve this
    Add Content Editor Web Part on the page and in source editor insert following code
    <a href="">Email Us</a>
    open a site page in SharePoint Designer, select the location where you have to put the link and then insert above code
    if you want users to directly open email link on a page when they click on "Email Us / Contact Us" button then assign "OnClick" event to Contact Us button / tab with above code 
    <INPUT TYPE="button" VALUE="Email Us" onClick="parent.location=''">

    hope this helps

    Monday, June 24, 2013

    Cannot open the excel files in Sharepoint 2010

    Issue :
    Users cannot open excel files in SharePoint 2010 from the Library and get an error
    "This workbook cannot be opened because it is not stored in an Excel Services Application trusted location. To create an Excel Services Application trusted location, contact your system administrator"

    Initially what users do - They contact SP admins and ask them to add library to trusted file location (as error says) but in SP 2010 it's not the case

    Cause :
    By default the files are designed to open in browser . So it is checking for trusted location  

    Resolution : 
    • Go to the Library
    • On the top click on Library and go to Library settings .
    • Under General settings you will find Advanced settings
    • Over there you will find the option which by default is set to open in Browser
    • You need to set it to Open in Client and there you go .
    • Click OK and you are done

    FREE Trial Download for IT Job Scheduling Software

    Windows IT Pro | Welcome
    TRIAL DOWNLOAD:Skybot Scheduler: Modern IT Job Scheduling Software Download this white paper
    Efficiency and organization seem to go hand in hand these days. When you are dealing with dozens of network devices, and most of the time simultaneously, it is vital that they are being regulated and ordered.
    This is why Modern IT Job Scheduling Software is becoming more important than ever. The more tasks a server needs to handle, the more sophisticated your scheduler should be.
    Skybot is offering a free trial download of their scheduling software, which is a perfect opportunity to realize the convenience of organization.
    There are plenty of reasons to give this software a try:
    • Out-of-the-box scheduling software
    • SAP task scheduling
    • Built-In auditing
    • and more!
    Click HERE for this FREE trial download
    Check out Windows IT Pro Resources to see a full listing of available
    eBooks, white papers and essential guides.

    Monday, May 13, 2013

    SharePoint 2013 Technical Diagrams

    A very good Microsoft article on SharePoint 2013 Technical Diagrams

    Popular Posts


    The opinions expressed on this blog are the personal views of Pratik's SharePoint Blog, and do not represent or reflect the viewpoints or policies of any past, present, or future employer, colleague, or customer, or any other entity. The posts on this blog are provided ‘as is’ with no warranties, express or implied, and confer no rights. Use of information contained within this blog, including specific technical steps mentioned herein, is at your own risk. References to specific software products, processes, resources, or companies do not imply any endorsement.