Industry Insights from Our Experts

Tag Archives: sharepoint

Items missing from Search Results in SharePoint 2013

Comments Off
Filed under Enterprise Search, SharePoint

We’ve been pretty busy the last few months putting the finishing touches on a new SharePoint 2013 Intranet for a client. One of the features we have been asked to implement is a detailed search page that pulls information from a third party financial asset management solution.

We have built what I think is a pretty elegant solution using BCS and SharePoint Search that is going to work quite well.

However, during QA a strange issue cropped up. When doing a search for assets, some of them would not appear in the search results.

We were ordering the results based on an asset Id field so I thought it could have been something to do with sort.

Read More »

How is a hand sanitizer dispenser like SharePoint?

Comments Off
Filed under SharePoint
I’ve just been to my local grocery store and as I was leaving I spotted a hand sanitizer dispenser hanging on a wall accompanied by those ominous “wash your hands or else!” signs. Of course being the clean living guy that I am, I wandered over, put my hand under it and … nada. Nothing came out because it was empty. On reflection I think this has been my experience with these 9 times out of 10. Read More »

Changing SharePoint to use a SQL Availability Group Listener

Comments Off
Filed under SharePoint, Software Architecture

I had an interesting issue crop up from a client this week. They were testing failover of their High Availability cluster and for some reason SharePoint wasn’t working after failover.

It turns out that SharePoint had been installed months ago, before the SQL Availability Group was configured. Production SharePoint was pointing to the SQLServer\Instance name in the form of Cluster\Prod. Ideally if you are planning to use High Availability then SharePoint should be installed with this in mind.

In order for SharePoint to failover successfully with SQL, we need to change the SharePoint database server to point to the SQL Availability Group listener instead. The listener will then handle redirecting to the active node.

Changing the SharePoint environment to use the AG Listener was actually a lot easier than you (or at least I) would think.

After stopping all the SharePoint services, I simply configured a SQL Alias to let SharePoint continue to use Cluster\Prod even though in reality it was now connecting to the AG Listener:



We tested the failover again and this time it worked successfully.

SharePoint 2013 Foundation, Standard, and Enterprise Comparison Chart

Comments Off
Filed under SharePoint

SharePoint offers a huge number of features, and with the growing popularity of Office 365, SharePoint Online adds even more options to mix.

Here is a great comparison chart that might help you in your self hosted SharePoint decision making processes. I’ll create a separate post for a similar SharePoint Online chart. Read More »

LightSwitch Apps for SharePoint 2013 Rollup

Comments Off
Filed under Cloud Practice, LightSwitch, Productivity, SharePoint

Hey, I may be all about cloud computing these days, but my heart is still anchored in all that is LightSwitch. With the new Visual Studio 2013 Preview out, I’ve been a busy little beaver (okay, a busy big ol’ bear) with all that interesting LightSwitch stuff.


(image courtesy of Microsoft)

For what it’s worth, here is a bit of a web content rollup about creating LightSwitch applications in SharePoint (yes, most are from Microsoft):

Building Modern, HTML5-based Business Apps for SharePoint 2013 with Visual Studio LightSwitch

Building Modern, HTML5-based Business Apps for SharePoint 2013 with Visual Studio LightSwitch (same presentation, different presenter at TechEd 2013 Europe)

Walkthrough: Creating an App for SharePoint by Using LightSwitch

Walkthrough: Accessing a SharePoint Workflow from a LightSwitch Mobile App

Get Started Building SharePoint Apps in Minutes with LightSwitch

Sending Email from a LightSwitch SharePoint App using Exchange Online

Theming a LightSwitch SharePoint App with ThemeRoller (way cool!)

Publishing LightSwitch apps for SharePoint to the Catalog 

Survey App Tutorial: Developing a SharePoint Application Using LightSwitch

More to come I’m sure.

Hey, if you’re curious to learn more about LightSwitch, I’m your guy. Contact me and I’d more than happy to chat with you about how using LightSwitch can shave weeks, if not months, of your next line of business software project.


Paul P

Organizations Struggle with SharePoint Data Security Governance

Comments Off
Filed under Cloud Practice, SharePoint

(re-post from the blog of PaulSPatterson.com)

This article is not quite specific to my cloud security bandwagon context, however I was just reading an interesting report from Aberdeen Group. The report, titled SharePoint Collaboration Secure and Mobile, talks to a couple of SharePoint data security concerns that I found interesting. Most notably, how organizations are not performing well at data governance with their SharePoint environments.

Data Security and the Cloud Sprawl

Keeping track of corporate data is harder today than it ever has been. Introduce the use of cloud services for data management, and now your looking at whole different dimension end-points to worry about.  Adding the elastic and organic nature of the cloud, specifically in how cloud services are used to host data, seems to only compound security and privacy concerns.

And it’s tough to keep up. As quickly as we move to adjust and implement governance models, a new way of doing something in the cloud is made available. SharePoint is arguably the most commonly used collaboration software used today. Consider the massive amount of documents, lists, and knowledge that is managed by today’s enterprise SharePoint environments, and the number of users that have access to those environments. Those same users are also accessing elastic cloud services and social networks that when combined, represent a sprawl of new risks that are sometimes impossible to map and keep track of.

SharePoint Concerns

Coming back to SharePoint, Aberdeen presents some points about what organizations are performing well at with SharePoint, and what they are not doing well at. Two pieces of insight are presented in the report; how well are organizations doing when they use complementary security technologies for SharePoint, and how they are struggling with SharePoint data governance.

The use of complementary security technologies seems to be what most are doing well at. Measurements of security-related incidents, non-compliance incidents, and human related errors, were each used to determine how organizations fared.  Strategies such as; disk encryption, data classification, data loss prevention, and rights management are used. According to the report, best-in-class users of SharePoint are leaders in the use of disk encryption and data classification, while the lagging performers seem to have more issues due to data loss, and rights management security.

Clearly understanding expectations of how data is accessed and used seems to be a challenge for most organizations using SharePoint. SharePoint empowers users with the ability to do a lot of things, including the ability to define very granular security permissions. Without a clear and defined expectation of what users should or should not do, users can wreak havoc with the data. Organizations, according to the report, are struggling with data governance.

What Can Be Done?

As per the report, there are some steps that can be taken to mitigate a more secure SharePoint environment.

  • Data Classification. Taking an inward-out strategy by putting controls on the data. The idea that information about the data follows the data wherever it goes, even it happens to go outside of the SharePoint environment – such as into the cloud sprawl.
  • Prioritize Security Objectives. Create, or apply existing, data security and compliance protocols to SharePoint data.
  • Policies and Procedures. Especially important for publicly traded companies, data in SharePoint needs to meet legislated compliance regulations, as well as organizations guidelines.
  • Knowledge and Training. Teach users how to do things right the first time.
  • Best Practices. Using security best practices will scaffold the privacy and protection of the data.
  • Complementary Tools. There are many complementary data protection tools for SharePoint. Use them.

I can see much of the above being applied to pretty much any other internal, and external cloud-based, environment. What attracted me to this report were data security concerns, and how poorly many organizations are doing with data governance.

Do you see any of this being a concern? How about in your own organization?

Updating your SharePoint Newsfeed from Lync 2013

Comments Off
Filed under .NET, Lync, Productivity, SharePoint

If you are not familiar with the SharePoint 2013 Newsfeed, it allows your SharePoint users to keep their team up to date on what is going on and what they are working on. It is a great tool for increasing social collaboration in the workplace.


Other team members can see a quick feed of their colleagues updates through out the day.


Another Microsoft Office product, Lync, provides a “What’s happening today?” field that also lets you update your colleagues on what you are up to. Pretty similar to what the SharePoint Newsfeed does. Read More »

Troubleshooting SharePoint 2013 upgrade issue “Content database cannot be upgraded due to use of the obsoleted External Binary Storage feature”

Comments Off
Filed under SharePoint, Software Architecture

I’m in the middle of a large upgrade project for a client. They are currently live on SharePoint Enterprise 2007 and are upgrading to SharePoint 2013.

The process is very well documented via Technet but in summary we migrate to SharePoint 2010 first and then migrate from there to 2013.

The SharePoint 2010 migration piece went very well, there were missing features and custom deployments that needed to be fixed of course but the site is now successfully running on a SharePoint 2010 test farm with no issue.

So next I setup our test 2013 farm to begin the initial test migration to SharePoint 2013. After testing the root content database I fixed any missing features and deployments. However when I attempted to run the upgrade I got the following error:

Read More »

Copyright 2018 by Quercus Solutions