Sunday, January 5, 2014

Happy New Year 2014 and a following good News…..!

Hi Friends,
A very great and HAPPY New Year. I have been away from the blogging from quite days as I was on planning to take a trip out with the family, celebrate X-Mas and New Year eve.
Everything went as planned and I feel sorry for not to bring something good for your guys as a part of SharePoint Learning.
First of all I would like to take this pleasure that MS has re-awarded me as an MVP-SharePoint for the year 2014. You can check the global announcement here:
Alongside I have got a certification of MCT from MS.
These two New Year gift as really precious for me and I would like to thanks for all my readers and extended support from my MS team Lead and fellow MVP for the extended support.
I have few things on my agenda for this year which I would be the primary points of attention this year.
Ø  Change the look and feel of the blog:
Ø  Bring up new real time scenarios.
Ø  Share information on How To’s on SharePoint 2010 and 2013.
Ø  Learn the basic Development skills.
Ø  Certification on SharePoint Server 2013 by mid of this year.
Ø  Buying a domain name to give the blog a new name.
Ø  Plan to conduct some webcasts and speak on different occasion when given a chance.
Again with this, I wish you all the luck to you and wishing you the very HAPPY NEW YEAR to your family.
Please keep on sharing your love and drop some comments with the feedback of the content.
Thanks and Regards,
Amardeep Singh.

Tuesday, April 30, 2013

Ten Tips for Optimizing SQL Server Performance

Optimizing SQL Server performance is challenging work. And while you can find a lot of info on general performance problems, there hasn’t been much out there for tackling specific issues—until now.

Kevin Kline, one of the world’s leading SQL Server experts, has simplified SQL optimization in this free paper. He reveals the most important things you should know about SQL Server performance and how to take it to new heights.

Discover Kevin’s favorite optimization tricks and strategies for solving your unique challenges.
Get Instant Access to Read It Now.

Friday, April 26, 2013

List tools tab missing SharePoint 2010

Today I have seen a very strange issue, where one my client said that he has the ‘List Tools’ tab missing from his List.

Issue: Unable to see list tools tab from the SharePoint Document Library and List.


Checked the list on other site and it has the List tools tab.
Edited the page list tools tab is available. Stop editing it again disappears.
Checked various option in the List view webpart.
Enabled the summary tool bar, full tool bar. It still does’t appears on the list menu.

Resolution:  This is the default behavior of the SharePoint 2010, that if we have more than two web parts (especially Content Editor) added on the List view page then 'List Tools' menu will not appear.

As a fix you either need to remove the Content editor webpart form the List view page.

As a work around I have selected the Full Toolbar option by editing the List Webpart. If you click on any section such as New, Action, Settings, you will get 'List Tools' option to work with.

If you have any queries/questions regarding the above mentioned information then please let me know.
I would be more than happy to help you as well as resolves your issues, thank you.

Hide the quick launch bar in SharePoint 2010

Today one of our clients asked a query if we can hide the quick launch bar from the site or sub-site. Informed him that he can hide the quick launch options (like Documents/Lists etc.) in SharePoint 2010 for site/subsite by going to

Site Actions - Site Settings - Tree View

Uncheck the box for “Enable Quick Launch”

But he says he wants to hide it and completely and would like to shift the page to the left to utilize the space of quick launch?

Add following script to the content editor webpart in HTML editor on the page:

If you have any queries/questions regarding the above mentioned information then please let me know.

I would be more than happy to help you as well as resolves your issues, thank you.

Saturday, April 20, 2013

Error while opening excel files after upgrade your SharePoint site to 2010

Error Message: The workbook cannot be opened because it is not stored in an excel services.

Cause: By default the setting in the library is set to "open the file in browser".

Resolution: Change the Library settings to open files in Client application.


-Open your document Library

-Click on "Library" under "Library tools" (See screenshot)

-To the extreme right on the ribbon, please click on "Library settings".

-Click on Advanced settings under General settings.

-In the settings for "Opening Documents in the Browser"

-Change the radio button and select Open in the client application.

-Click OK

You must change this setting in all the document libraries.

Applies to: SharePoint Foundation 2010/SharePoint Server 2010.


Attachments doesn’t open when attached with a discussion boards.

The lists can be configured to open documents in client mode but this doesn’t happen with discussion boards and other collaborative lists which do not have a special provision for attachments.
Error messages may say that the features included in the files are not supported by web browser.
Reason: Uploaded excel files may contain macros or other calculations which needs an excel client. In SP 2010 all the office documents open in client by default so ether make the settings suggested below or turn on a feature to open all documents in client by default.
Steps to do this:
Go to Site Actions > Site settings > Site collection Features > Open documents in Client Applications by default
Applies to: SharePoint Server 2007/2010.

Windows Server and Virtualization Bulletin.

Wednesday, April 17, 2013

The Business Card As A Career Tool: by Jim Adcock

After talking with a job seeker the other day, I asked for his card so I could keep in touch with him. He replied that his company didn't give its employees business cards. He didn't have a personal business card either.
I was asking for his card because I had spoken with him a couple of months before, and he took my card and said he would contact me so I could pass job leads to him. But I didn't hear from him, and I had no way to initiate contact with him, so he missed a couple of good leads.
I realized that not everyone has been taught the value of a business card - their own personal business card - to their career.

Quick Fix: “The document could not be opened for editing. A Microsoft SharePoint Foundation Compatible application could not be found to edit the document” by Jim Adcock

A user tries to open an InfoPath form in the application instead of the browser, and get an error message:
The user can open in the browser just fine, and has been able to open the forms previously with no problem. User is able to download the form to their desktop and open the form in InfoPath. But when they try to open the form in the application from the context menu, the above error is shown.
In researching the error, I found a support posting that provided a clue to the problem. In it, the user is instructed to enable Add Ons in their Internet Explorer:
  1. Go to Tools in IE, click Internet Options
  2. Click Programs at the top
  3. Click “Manage add-ons” near the bottom
  4. Click Publisher, then you can see all of Microsoft Corporation together
  5. Scroll to SharePoint names (May be one or several)
  6. Make sure they are all enabled by clicking on the name; the Enable button is towards the bottom.
  7. Then click OK and OK and restart IE
Can you guess what the problem was?
Read more of this post

Sunday, April 14, 2013

SharePoint Pro | Update

By Michael T. Smith

As I discussed in "Inventorying SharePoint Using PowerShell," Windows PowerShell is a valuable tool that you can use to inventory top-level SharePoint objects. That article shows you how to get lists of farm features, web applications, site collections, and sites using PowerShell cmdlets. In this article, I will explain how you can use PowerShell to obtain information from SharePoint about lists, libraries, files, and pages. Here are some of the tasks we will explore:

  • Find lists and libraries based on just about any feature (e.g., versioning, content approval, date created).
  • Find all libraries that use a selected content type.
  • Find all items based on a selected column (including finding all documents created by a user).
  • Find all documents of a certain type (e.g., .docx).
  • Find all files larger than a certain size.
  • List all libraries, their file counts, and total file size.

A reminder before we get started: Just because you can use PowerShell does not mean that you can ignore SharePoint security. See "Inventorying SharePoint Using PowerShell" for the basic security requirements. You will need to have at least read permissions to the content you want to explore. You can add the account you're using with PowerShell as a site collection administrator to every site collection or use SharePoint Central Administration user policies to give your account full read permissions in each application (select Central Administration, Application Management, then select an application, then click User Policy).

To read the rest of the article, click here.

By Caroline Marwitz

See if any of the new or improved features listed below for SharePoint 2013 catch your eye. Then head over to Microsoft's SharePoint site for a deeper dive.

1. Authentication
  • OAuth support. This web authorization protocol means that a user or web app can request authorization to get temporary access to specific network resources.
  • Default claims-based authentication for new web apps. A new Windows PowerShell cmdlet, Convert-SPWebApplication, helps you migrate from Windows classic-mode authentication to claims-based authentication.
  • Distributed Cache Service for login tokens. A dedicated cache helps avoid the need for additional configuration and makes for less memory utilization in the web front-ends.
  • Enhanced logging.

To read the rest of the article, click here.
SharePoint Pro Magazine Tips and How-To's

SharePoint Pro | Updates

By Dan Holme

Over the last two weeks, I’ve laid out an analysis of Office 365 and what it means to enterprises large and small.  But there’s one piece that I left out—quite intentionally—that today deserves to be brought to light: apps.  Not just any apps.  Killer apps.  Solutions to problems that transcend SharePoint… problems that have plagued businesses for years.  Now that Office 365 is released, I’d like to lay out my prediction for an exciting near-term future for SharePoint 2013 and Office 365 apps. 

From time to time I will highlight apps that I think are particularly noteworthy.  Today, I’d like to talk about a few—in particular a pair of apps that address very common business meeting and organizational challenges: MEETINGS and MY VIEW, which revolutionize your ability to leverage the Microsoft stack to manage effective meetings, and to roll up tasks and calendar entries across your SharePoint and Exchange worlds into a single view that can surface on any computer, tablet, or phone.

Before we jump to that discussion, I’d like to thank everyone at Penton—the organization behind—for all their work on our BRAND NEW SITE, launched today with a great new engine that my colleagues—for example Paul Thurrott at SuperSite for Windows—have been raving about.  I think you’ll love the new look, and how easy it is (finally!) to register to make comments, and to find content you’re looking for!  So whether you have time now to read about a couple of apps that could change your work life, do jump to the new site to check it out!

To read the rest of the article, click here.

By Asif Rehmani

Have you noticed any SharePoint pages in your environment that load slower than the others? Want to know why? The SharePoint Developer Dashboard can provide the answer. Its name makes it sound like it’s only for developers. However, it's an extremely useful tool for IT professionals as well as SharePoint site owners.

To read the rest of the article, click here.

Additional Resources

Why Data Quality Matters—A DBA and IT Perspective | April 3
To applications, data is everything. Allan Hirt explains how keep it clean inside and outside the application.

March 21 | Upgrading to Windows Server 2012 Hyper-V the Right Way
Join us as we talk about how to upgrade your existing hypervisor environment to contain the great new functionality available in Windows Server 2012 Hyper-V.

SharePoint Pro Magazine Tips and How-To's

SharePoint Security 101: What you need to know to secure SharePoint, by Randy Williams

SharePoint Pro | Updates

By Jason Himmelstein

When I initially sat down to start this article, I quickly realized that you can't begin to troubleshoot performance issues until you have a sound baseline to start with. Otherwise, the likelihood of you figuring out what is going wrong in the environment is extremely low. With this in mind, I decided to tackle this topic from a bit of a different perspective, examining what forms the base of a solid and well-performing Microsoft SharePoint 2010 farm and working backward from there.

Performance is a tremendously broad topic when you're talking about SharePoint 2010. End users frequently have concerns such as "Saving that form took too long," or "It felt like it took forever for me to upload a file," or -- my favorite -- "SharePoint feels slow." As IT pros, we rarely get specifics when people complain about performance; they expect us to fix problems instantly without any details of what's really going on.

To read the rest of the article, click here.

Additional Resources

Mobilize SharePoint Securely: Top 5 Requirements
Give users mobile access to SharePoint while retaining control of the data

Free SharePoint Admin Toolset
Get 7 essential tools for monitoring, securing, and administering SharePoint

SharePoint Pro Magazine Tips and How-To's

SharePoint Pro | Updates

By Dan Holme

Yesterday, Microsoft released Office 2013, Office 365 Home Premium, and Office 365 University—a significant chunk of the “Wave 15” Microsoft Office portfolio. But business and enterprise plans of Office 365 are on hold for another month.

The general availability milestone for consumers means that Office 2013 is more officially in the wild, now. This is just one of many milestones, and there are many thousands of individuals—myself included—who have been using Office 2013 for months, whether through MSDN, TechNet, or Microsoft volume licenses, or through the suite’s inclusion on the Surface. Many thousands—myself included again—have also been working with the new version of Office 365 through preview accounts obtained during the Consumer Preview period, or through Enterprise plans.

This week, I’ll share some of the details and resources related to this release, which in my opinion is a “no brainer” for certain scenarios—especially for those of us who are the tech support for our FFANs (Friends & Family Area Networks). I’ll also address some of the rumors about the impact today’s release has on your business and your users (read: licensing!). Next week, I’ll cover and clarify the dizzying array of Office 365 offerings for business.

For those playing the “Where in the world is Dan?” game, I’m in London this week, speaking at the SharePoint User Group UK on Thursday. I fly to lovely Copenhagen on Friday for the European SharePoint Conference where I will deliver my new SharePoint 2013 Collaboration MasterClass, a keynote with Christian Buckley, and three governance sessions.

Due to this week’s Office release news, I’m going to put off sharing the next chapter in my Facebook Catfish saga which, by the way, Facebook has yet to address adequately! (MAJOR #FAIL in protecting their users!)

So, on a brighter note, the release of the stunning Office 365 and Office 2013 applications!

To read the rest of the article, click here.

By Caroline Marwitz

Because my brain has been totally corrupted by using Twitter, what else but a tweet came to mind while I was reading the just-released Metalogix SharePoint survey:
"SharePoint content explodes, admins unhurt.

Actually, by rights it would more accurately have said "Users going ape-crazy with putting content into SharePoint, admins hopeful #SharePoint 2013 can help, if their organizations will cough up the money for it and allow for decent planning time, and by the way, ANY downtime while migrating = fail."
To read the rest of the article, click here.

Additional Resources
Protecting Unstructured Data on File Servers, NetApp, EMC and SharePoint
Organizations today increasingly depend on unstructured data – including emails, spreadsheets and other documents. That makes protecting them a priority and having the right tools is critical to success. Read this white paper to learn about your options.

Real-time SharePoint Monitoring
Try this easy-to-use tool that watches SharePoint’s disk space operation speed

SharePoint Pro Magazine Tips and How-To's
Creating Mashup Applications in SharePoint, by Todd Baginski

The Cost of Changing to SharePoint, by Robert Bogue

Saturday, April 13, 2013

SharePoint Pro | Updates.

By Michael T. Smith

Microsoft SharePoint quickly spreads through the enterprise because it’s very easy to use. Unfortunately, that often means that it’s easy to abuse, too.

To manage the ever-growing spread of SharePoint, we often write governance plans that mandate the auditing and policing of users, content, and policies. Which tools can you use to perform these audits or even just to find out what's happening in your SharePoint installation? Third-party tools can handle some of the necessary inventories and auditing, but you already have a great instrument in your toolkit: Windows PowerShell.

To read the rest of the article, click here.

Additional Resources

The Essential Guide to Achieving High Availability for SharePoint Data
Michael Noel explores approaches for reliable, efficient distribution of SharePoint content.

Windows Server 2012, Hyper-V: The Essential Guide to New Virtualization Capabilities
Learn how Hyper V’s new advancements make it an ideal platform for all application tiers and scenarios

SharePoint Pro Magazine Tips and How-To's