How to check list views that has more than 12 lookup columns in SharePoint

So I was on a customer who asked me which lists, actually views, has more than 12 lookup fields, that we all know impacts directly in our SharePoint performance. Here is it, enjoy! param( [Parameter(Mandatory = $false)] $fooparameter = “foovalue” ) $spsnapin = Get-PSSnapin | ? {$_.Name -eq “Microsoft.SharePoint.PowerShell”} if (!$spsnapin) {Add-PSSnapin “Microsoft.SharePoint.PowerShell”} $badviews =…

0

Business Intelligence: From classic to self-service BI.

Hi Everyone! This time I wanted to post an article about the new concepts of self-service BI and how Excel plays the lead role in it. The classic way First of all, let´s go to the basis about the "classic" BI solutions I was involved back some years ago. To summarize all the elements that…

0

Power BI : Excel Auto Refresh from On Premise SQL Server Data Source in Office 365

Hi! Let's propose this scenario: You have an Excel Workbook that consumes data from a SQL Server Database in your network, like this diagram: In this case, you live happily ever after because your desktop is in the same network of your SQL Server, so you just create your data connection, input the server name,…

2

Checklist when configuring ADFS with SharePoint

Hi everyone! This time, let's summarize a check list if you have to configure AD FS for a SharePoint 2013 environment. The basic steps are well described in the following TechNet article: http://technet.microsoft.com/en-us/library/hh305235.aspx I will just mention things that you should take care of before and during the configuration process. My first recommendation is to…

1

Checklist when configuring Reporting Services for SharePoint 2013

Hi again! Continuing with my series of check lists, this time it's turn for Reporting Services from SQL Server 2012 with SharePoint 2013. The high level steps are: Install SSRS in SharePoint mode (and the add-in) in the farm server you want to be the Reporting Server. Install the SSRS add-in in the remaining farm…

0

Checklist when configuring PowerPivot for SharePoint 2013

Hi everyone! Currently I am in the middle of a deployment with PowerPivot in SharePoint 2013, for the sake of have as much new stuff as possible, at least from the SharePoint end. My scenario looks like this: For the installation the high-level steps are: Install a SQL Server Analysis Services for SharePoint in any…

0

Page variation update doesn´t work after SharePoint 2013 migration (upgrade)

Hi! After some testing I discovered something quite funny while upgrading a publishing site collection from SharePoint 2010 to SharePoint 2013 with Variations. The original configuration in 2010 was that is updates pages across label targets. This means, if you change or add a new page, it will update all the pages in their corresponding…

0

SharePoint 2013 Prerequisite Installer fails at Web Server Role

Scenario: You want to install SharePoint 2013 in a server that has no connection to the internet. You have downloaded all your prerequisites according to the following articles: http://technet.microsoft.com/en-us/library/ff686793.aspxhttp://technet.microsoft.com/en-us/library/cc262485.aspx If you want an easier version (in spanish) refer to this article by Matias Rama: http://blogs.technet.com/b/pfespain/archive/2013/08/07/sharepoint-2013-instalaci-243-n-de-requisitos-de-software-y-v-237-nculos.aspx Symptom: When you run the prerequisite. The process fails while…

0