Compare 2 similar Excel files with the Inquire Add-In

Note: this was only tested in Excel 2019. Office 365 Pro Plus has something called Compare sheets similar to this function I had the need the other day to compare two excel files that had some information in them from exported SharePoint lists. They were very similar, but I didn’t know of a good way […]

Why you should disable Nintex Automatic Database Mapping

There are a few things that after I learn them, make me want to immediately share with as many people as possible. This is definitely one of those moments. After starting a migration project where I work involving some cleanup with Nintex workflow content databases, I’ve run into something that everyone should check in their […]

Migrating Nintex Workflow Content to Another DB

Here lately I’ve been looking into doing some cleanup for Nintex related databases in a SharePoint farm, so I thought I would share a short write up I did for a few other folks on the process of moving content in the context of dealing with Nintex content databases. Taken from : https://community.nintex.com/docs/DOC-1092 First take […]

Handling large lists with SharePoint on premises

If you have spent much time working with SharePoint, you know that once a group of users likes it to store information in libraries or Lists, you can certainly tell. Ultimately what happens is you get an email (or call, or service ticket) one day that says “Hey we are getting some kind of error […]

SharePoint resources for demos

Today’s post I thought I would include in order to find anything needed to create a working demo of SharePoint locally. Nowadays,  Azure or other cloud providers make this much easier, but if you want more control you can spin up your own locally. Windows Server 2019 (still beta as of now) https://techcommunity.microsoft.com/t5/Windows-Server-Insiders/bd-p/WindowsServerInsiders 2016 https://www.microsoft.com/en-us/evalcenter/evaluate-windows-server-2016 […]

Office Files too big? Inspect them!

Today I had a problem with a group of users that were trying to work with a very large PowerPoint file in SharePoint and didn’t realize until I downloaded a local copy of the file that it was too big to work with through Office Web Apps. So I did some digging around to see […]

SharePoint giving all zeros for correlation id

I had an interesting error come across today when I was working on a new Nintex form list. I have been doing some power user training in my company lately and a few of my users have taken the plunge and started creating their own electronic forms in Nintex. Which is awesome! It’s a great […]

Displaying pdf reports in SharePoint

I had an interesting request by someone the other day. I was helping them set up a new site template for SharePoint 2013 and they wanted to display a couple of reports on their site that they had in pdf format in a way to showcase the numbers of the report to others in the […]

MS Ignite 2016 Day 1

Well for the first day of ignite, I can pretty much sum it all up in one word. Wow!  To begin the day with the keynote of the conference in an arena with 20,000 other people was truly amazing. If you would like to watch a replay of it, you can find it here: https://ignite.microsoft.com/#fbid=LjEHvsDymJ4 […]