SharePoint Tidbit - SPO with Power Pivot and other BI stuff

Hello All, Recently I was asked the question “How do you use Power Pivot with SharePoint Online” and the answer is to use Excel 2013 or later, it will get you a basic level of use with Power Pivot and SPO (E1 – E5 License) as suggested by this article (See all Stages but the last…

0

SharePoint Tidbit - Better way to setup Perfmon tracing

Hello All, Was working with a platform PFE and he provided me with the script that he uses to have customers setup/start/stop perfmon, I thought it was great so did some digging and found a blog that detailed the formatting to use for SharePoint counters. Here is the script I sent to my customer: Logman.exe…

3

SharePoint Tidbit - GUI for PowerShell commands

Hello All, Earlier this week I was going thru my RSS feed and found an article about the cmdlet Show-Command and thought it was cool enough that I wanted to tell you about it. This cmdlet allows you to have a GUI for your cmdlet’s so we can get something like this, as you can…

0

SharePoint Tidbit - SharePoint Hybrid book now available

Hello All, A book was just recently released titled “Configuring Microsoft SharePoint Hybrid Capabilities” (Download here https://blogs.msdn.microsoft.com/microsoft_press/2016/07/06/free-ebook-configuring-microsoft-sharepoint-hybrid-capabilities/) this is a great read if you want to understand the integration between SharePoint on-prem and the cloud. As an added bonus one of the authors Manas Biswas is a fellow PFE with an amazing fountain of knowledge,…

0

What to do once you have disabled the Workflow Cleanup Timer Job

Sooooooo you have figured out that you disabled the Workflow History Cleanup timer job, and now realize the mistake you made…. My customer recently found themselves in that position, this customer had done this to allow a Site Collection to use that data for auditing purposes and as I said a few weeks ago this is…

0

SharePoint Upgrade and database growths

Hello All, I have been working with customers on upgrades and figured I would provide you with some of the notes about Database growth.  As we upgrade the databases they will grow (Talking about mdb, ldf, and log files) this happens because the schemas change and they have to move columns around and massage data.  The space…

0

Auditing and the WorkFlow history list in MOSS 2007

Hello All, Recently I was working with a customer who has MOSS 2007 and as we are making improvements to this environment I realized that they had disabled the WorkFlow Cleanup Timer Job I then discovered that they had done this becuase somebody had told them to do this so that Site Collection owners could…

1

Exposing SharePoint to the Internet

Hey Guys, This is a very high level view of how to expose SharePoint to the internet. Methods:       Place all of SharePoint or SharePoint WFE in DMZ.       Allow traffic thru DMZ passing into internal network (Using router or Load balancer).       Place TMG or similar product in DMZ. Pro's and Con's: 1. Place…

3

SharePoint Tidbit - August 2012 Cumulative Update release for SharePoint

Hello All, So it is that time again when the SharePoint group releases the Cumulative Updates for all versions of SharePoint, here are the links you need to know 1. Description of the Windows SharePoint Services 3.0 cumulative update server hotfix package (WSS server-package): August 28, 2012 http://support.microsoft.com/kb/2687331 2. Description of the SharePoint Server 2007…

2

SharePoint Tidbit - Simple ways to present data using SharePoint 2013 and Exchange 2013

Hello All, Something I noticed with SharePoint 2013 that I find very exciting is how it is integrating with other Office products much closer to provide you and your users with a better experience. If you search thru Technet you will find some great Blogs and Articles in the future about the way that Office…

1