Setting SharePoint View properties with the PnP-Framework

The PnP-Framework has made a lot of task easier when taking care of a SharePoint environment. However, the documentation is still… ehem, let’s say developer friendly. In this article I’ll take a look at the Set-PnPView cmdlet and what values can be configured and why.

Session I held at the Ignite 2018

Since we, in the company I work for, have rolled out 65,000 Office 365 licenses and are one of the most successful companies ever with Yammer and Teams, I had the great luck this year to be invited by Microsoft as a speaker to the Ignite 2018 in Orlando. Together with my colleague we held a total of 3 sessions and were interviewed in a podcast.

In the meantime the sessions are available on YouTube. The links to the videos can be found here:

Find out how one of the biggest retailers in Europe is using Microsoft Teams - BRK2366

With approximately 48,000 frontline workers spread across 5,000 stores around Europe, dm drogerie's employees communicate with each other by smartphone and Microsoft Teams. The introduction of modern communications tools based on Office 365 has led to a productivity increase felt by every employee and ultimately by our customers. We describe how we encouraged adoption by taking away the fears of colleagues who weren’t IT-affine and showing them the value to be gained from the new tools. Across the entire company, communications skills, team and project work has been taken to a new level. We tell the success story from the first pilot through the tsunami of demand to the roll out in production.

Build your communities using SharePoint and Yammer - BRK2076

Learn how SharePoint and Yammer bring together modern content and conversations to deliver a best-in-class community solution. Understand what's new and coming next for building communities across your organization using Microsoft 365. Leaders from Rolls Royce and DM share how to champion a community approach to business challenges for accelerated business transformation. Learn how you can empower community leaders to support a strategic approach to community management.

Success with Teams Customer Panel – Best practices for large scale enterprise - BRK2189

Learn from key customers about how they are moving to Microsoft Teams. This session includes real world guidance for planning, delivering, managing and driving adoption of Microsoft Teams at scale.

The Office 365 Secure Score

Keeping track how secure your Office 365 tenant is can be a bit of a hassle. To make it easier for you, Microsoft created the Office 365 Secure Score.

In this 4-minute overview of Office 365 Secure Score, you will learn about a new tool that helps you to automatically assess the security posture of your Office 365 accounts, data, and devices. You'll discover the security features and best practices available to you to implement based on your overall security and productivity goals.

Code Snippet: Load the SharePoint Office PnP Module in PowerShell

How do you load the PowerShell OfficeP PnP module for SharePoint?

Addendum: I've added a try/catch block to the code. This way you can be sure the module is loaded.

# Loading Office Online PnP Module
try {
    if((Get-Module "Microsoft.Online.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null) {
        Import-Module Microsoft.Online.SharePoint.PowerShell
        Write-Host "PowerShell module Microsoft.Online.SharePoint.PowerShell initialized"
    }
    else {
        Write-Host "PowerShell module Microsoft.Online.SharePoint.PowerShell loaded"
    }
}
catch {
    throw "PowerShell module Microsoft.Online.SharePoint.PowerShell initialization failed"
    exit 3
}

Connect to Office365 via Office PnP behind a proxy

How do you connect to your SharePoint Office365 tenant with the PowerShell if you are locked behind a proxy? This hint will probably work for all kind of PowerShell scripts, not only for Office PnP. I tried this with the Microsoft SharePoint Online extensions as well and it worked.

So my problem was, the company I was working for, had a proxy which could not be bypassed. The proxy settings have been set by a GPO and the network settings where fine so far. However the proxy used user authentication to access the internet. Now if I want to use the SharePoint Online tools, I must authenticate my PowerShell session at the proxy so the tools can access the internet too.

The trick to get your PowerShell connected is quite simple. You only need to enter the following line:

[System.Net.WebRequest]::DefaultWebProxy.Credentials = [System.Net.CredentialCache]::DefaultCredentials

Now you should be able to connect to Office365 SharePoint without problems. If you don't want to enter this line every time you open a new PowerShell, you could add it to your PowerShell profile.

ise $PROFILE
then add this to the profile file:

#Set user default credentials for any webrequest
"Setting the users default credentials for WebRequests..." | Write-Host -ForegroundColor White
[System.Net.WebRequest]::DefaultWebProxy.Credentials = [System.Net.CredentialCache]::DefaultCredentials

A certificate validation operation took nnn milliseconds and has exceeded the execution time threshold

After installing a new SharePoint 2013 farm, I noticed a few messages in the Windows event log:

A certificate validation operation took 14988.6926 milliseconds and has exceeded the execution time threshold. If this continues to occur, it may represent a configuration issue. Please see http://go.microsoft.com/fwlink/?LinkId=246987 for more details.
Source:	SharePoint Foundation
Event ID:	8321
Level:	Critical

As Microsoft states in their knowlege base article KB2625048:

The SharePoint server does not have access to the Internet, or the server is protected by a firewall that has limited ports open. In this situation, users intermittently experience long delays when they perform certain operations, such as logging in to the site or performing a search. Users may also encounter HTTP timeouts when they perform these operations.

The mean you must either let your server access the internet, what most of the time won't be possible due to policy reasons, or we need a other solution. Good for us that the knowlege base article offers two possible solutions.

How to remove an unsuccessful AutoSPInstaller job

What do you need to uninstall from your server if the installation with AutoSPInstaller wasn’t successful?

Installing a SharePoint Server with the AutoSPInstaller job has become the gold standard for administrators. It’s much easier for large farms and offers a high degree of quality. However, using AutoSPInstaller can be a bit of a hassle. Until you get the xml configuration right, you normally need a few approaches. You can start the installation again, but you need to remove a few things first before it will re-run successfully.

Languages

If you are installing language files with your SharePoint Farm, remove these packages first. Open the Windows Control Panel, go to Programs -> Uninstall a program. Search for any SharePoint Language Package that has been installed and remove them all.

SharePoint Server

Leave the Control Panel open. Search for the SharePoint Server binary installation package and remove that file as well.

Prerequisites

These files must not be removed. They can stay on the server.

Internet Information Server

Open the IIS Management and look for any Web Application that was created during the AutoSPInstaller setup. Remove all of them and the Application Pools as well. Because AutoSPInstaller will create all of them again, I normally delete all Application Pools and Web Applications from IIS. This way I’ll have a clean system after setup.

The Web Applications create directories in the VirtualDirectories folder of the IIS working directory. You normally find it here:

C:\inetpub\wwwroot\wss

Remove the folders from the Web Applications you have deleted from here as well.

Log files

Remove the log files from the ULS logging directory or do a clean up after you sucsessfully installed SharePoint.

Search Index

If the SharePoint Search has been created already, go to the directory where the search index is stored. Delete all GUID directories you find there.

SQL Server

Open the SQL Management Studio and connect with the SQL instance you are using to host the SharePoint databases. Delete any database that has been created by the AutoSPInstaller script. At the prompt to delete the database, you should select to close any connection to the database.

Finally

Now reboot your server. After login back into the server you can restart the installation with AutoSPInstaller. Any traces of previous installations will be gone then.

Latest release of the SPBestWarmUp Script available

I finished the updates on the latest version of the SPBestWarmUp script and we’re heading version 2.0 (Stockholm). You can get it here on Codeplex.

SPBestWarmUp is a PowerShell script that will load all of your SharePoint web sites. By doing so it helps to populate the IIS and the asp.net caches. This will speed up accessing your server and give your users a better overall experience.

Change log:

• Removed the Internet Explorer to fetch webpages and switched instead to the Invoke-WebRequest Cmdlet. IE will be deprecated in the future anyway.
• Collecting all relevant Urls prior fetching them from the server.
• Temporarily removed the ability to use own Urls. Will be added in the future as a parameter and/or as a file. However, if you look at the code, you’ll find it isn’t hard to write your own little patch if you need to.

The code is marked as beta. To use it, collect a copy from the source repository.

Feedback is welcome. If you find any issue, please use the issues panel on the Codeplex project site.

Trickshots: Testing a SQL connection quick and easy

Did you ever need to test a SQL connection? As a SharePoint Pro you probably have. I found a nice little trick on Steve Rachui's Blog today I’d like to share with you.

Create a new text file on the desktop of the machine you will try to connect to the SQL server. Name the file whatever you like, but rename the file into UDL. Double click on the file and a dialog pops up with SQL connection settings. Enter your connection settings and use the Test Connection button in the lower end of the dialog.

If you need to test a different SQL server port (not 1433), simply create a SQL alias on the machine and test against the alias.

Toolbox: SharePoint 2013 Search Tool

Using the SharePoint REST API can be sometime a bit of a pain. Good to have some tools at hand that make life more easy. With the SharePoint 2013 Search Tool you learn how to build an HTTP POST query, and how the different parameters should be formatted.

After running the query, you can view all the different result types returned, e.g. Primary Results, Refinement Results, Query Rules Results, Query Suggestions and the actual raw response received from the Search service.

SharePoint 2013 On-Premise and Office 365 are both supported.

To download visit the project page at Codeplex:
https://sp2013searchtool.codeplex.com

Kerberos and SharePoint

Keeping a SharePoint environment secure is one of the biggest challenges for an IT-Professional. Kerberos is the strongest Integrated Windows authentication protocol available so far. That is why it should always be used in a SharePoint Farm instead of NTLM.

Inferno, Canto VI, 12-35, Cerberus – From William Blake
https://commons.wikimedia.org/wiki/File:Cerberus-Blake.jpeg

Kerberos supports advanced security features including Advanced Encryption Standard (AES) encryption and mutual authentication of clients and servers. The protocol allows delegation of client credentials and from all the available secure authentication methods. It also requires the least amount of network traffic to the Active Directory controllers. Kerberos can reduce webpage loading latency in certain scenarios as well.

This post is

Ignite 2015 Sessions about SharePoint 2016 on Channel 9

Are you looking for and update about SharePoint 2016? Here you'll find a selection of the Ignite 2015 sessions held in Chicago. If you miss a video in my list, fell free to leave a link in the comments below and don't forget to spread via facebook and twitter ;)

The Evolution of SharePoint: Overview and Roadmap   
It’s been an exciting year for SharePoint and we’re been hard at work evolving features and capabilities both online and on-premises. This session has a little something for everyone—users, IT pros and developers. We'll cover numerous aspects of SharePoint Server 2016, SharePoint Online, hybrid and everything in between. Lots to share, lots to learn.
http://channel9.msdn.com/Events/Ignite/2015/FND2203

Effective Search Deployment and Operations in SharePoint Server 2013  
SharePoint 2013 introduces a flexible and highly customizable search topology, providing a scalable framework to meet demanding requirements for query and indexing performance. In this session we will share experiences from the field of real world multi-node search installation case studies, review best practices for common operational procedures, and position IT to meet the unique demands of hybrid search scenarios. You will learn proven tips and tricks on how to keep your search system healthy and your users satisfied with their search experience.
http://channel9.msdn.com/Events/Ignite/2015/BRK3176

Deep Dive into Safe SharePoint Branding in Office 365 Using Repeatable Patterns and Practices  
This session demonstrates how the use of repeatable, proven, and secure patterns and practices can help developers create a safe branding solution that they can implement in Microsoft Office 365.
http://channel9.msdn.com/Events/Ignite/2015/BRK3164

Migration to SharePoint Online Best Practices and New API Investments  
In this session we provide an overview of best practices to migrate Files Shares or on-premises SharePoint environment to SharePoint Online. First we will focus specifically on defining a holistic migration approach, the Content Migration Process, replacing full trust solutions, and addressing network capacity concerns. We will then talk about the new SharePoint Online Migration API in that area and what to expect out of it. This will be followed by more in depth explanation on how to fully take advantages of those new capability.
http://channel9.msdn.com/Events/Ignite/2015/BRK3153

Designing and Applying Information Architecture for Microsoft SharePoint and Office 365  
This session demonstrates a proven process for defining, designing, implementing, and governing your information architecture (IA). IA is more than just columns and metadata. Learn how the different components available in SharePoint and Microsoft Office 365 can be leveraged to their fullest potential and your users' ultimate benefit to content organization and discovery.
http://channel9.msdn.com/Events/Ignite/2015/BRK3190

Microsoft SQL Server BI Drill Down  
SQL Server Business Intelligence delivers a comprehensive platform empowering organizations to build and deploy secure, scalable and manageable BI solutions. Please join us to learn more about SQL BI. We will showcase mobile BI implemented on-premises and optimized for SQL server, highlight SQL Server BI key capabilities and discuss the strategic investment areas and roadmap for Microsoft SQL Server Analysis Services and Reporting Services.
http://channel9.msdn.com/Events/Ignite/2015/BRK2552

Proven Ways to Build Robust, No-Code Solutions in Microsoft SharePoint  
In SharePoint there are many tools available to create elaborate solutions to tackle the most common business scenarios. In this session, see the true power of tools such as Microsoft Access 2013 apps, Microsoft Excel 2013 PowerView, SharePoint Designer 2013 Workflows, Microsoft InfoPath 2013, out-of-box SharePoint features and more! Gain a deeper understanding of how these tools are used in SharePoint to create robust end-to-end SharePoint applications, on-premises and online—without writing a line of code. We help you learn how to create custom, no-code solutions for your organization.
http://channel9.msdn.com/Events/Ignite/2015/BRK2150

What's New for IT Professionals in SharePoint Server 2016  
In this session, we have a lot of new information for admins, sharing what's new and coming in the next on-premises version of SharePoint - SharePoint Server 2016 - with insights on hybrid, too. More detailed information to be posted as we get close to Ignite.
http://channel9.msdn.com/Events/Ignite/2015/BRK2188

Virtusa: Establishing SharePoint Hybrid for Social, Search and Personal Storage  
In this Session, Shehan details their hybrid journey over the last 3 years, building a dynamic enterprise spanning SharePoint on-premises and Office 365. He will focus on three main areas: 1) their strategy of integrating social (Yammer) with their Systems of Record for 10,000 global employees, 2) bridging the content divide with hybrid search, and 3) enabling all employees to use their personal work files in Office 365. You will learn how to accomplish a sustainable, beneficial hybrid deployment rooted in solid strategy, planning and execution. Virtusa Corporation (VRTU) is a global information technology (IT) services company providing IT consulting, technology and outsourcing services: www.virtusa.com.
http://channel9.msdn.com/Events/Ignite/2015/BRK2156

Upgrade to Microsoft SharePoint 2013 and Ready for Cloud Potential  
Have you heard all your SharePoint admin friends talk about how great SharePoint 2013 is, yet your farm is still running at SharePoint 2010, or even worse, SharePoint 2007? Then this session is for you. In this session, Todd goes over the strategies for upgrading to SharePoint 2013 and best practices for reaching ready-for-cloud potential. He then digs into some fun stories about how he's done battle upgrading SharePoint so that you won't have to. This session includes lots of tips, and lots of fun, and in the end you'll be ready for anything the upgrade to SharePoint 2013 can throw at you, and will be set for the future.
http://channel9.msdn.com/Events/Ignite/2015/BRK3115

Setting Up Your On-Premises SharePoint Environment for Custom App Development  
This session walks through the operations and management details of how to set up your development environment on-premises to develop cloud apps and solutions.
http://channel9.msdn.com/Events/Ignite/2015/BRK4104

Ernst & Young: Microsoft SharePoint Server 2013 Search Adoption  
In this case study, Ed Dale discusses the SharePoint Server 2013 search program at EY, providing real-world examples from the EY environment for how to improve your own search environment. The presentation explores various techniques, including optimization of content, user training, search log analysis, relevancy tuning, and voice of the customer initiatives—all of which positively impacted the adoption of SharePoint at EY. Ed will use examples from the enterprise search management program at EY which supports 170,000 users spanning multiple business units, geographies and languages.
http://channel9.msdn.com/Events/Ignite/2015/BRK2130

MVP Panel: SharePoint On-Premises, Online and Everything in Between  
Imagine five great minds coming together to talk about Microsoft SharePoint across the board, be it within Microsoft Office 365, in Microsoft Azure, on-premises and certainly hybrid. Via a panel Q&A format, these MVP experts expose how online and hybrid improvements increase both deployment scenarios and value. This session is designed to help ITIs and ITDMs find the right cloud formula to deploy based on practical business and technical considerations. This is a must-not-miss session for any IT pro!
http://channel9.msdn.com/Events/Ignite/2015/BRK2163

The Social Intranet: Integrate Yammer into Your Microsoft SharePoint Experience  
Yammer is the standalone, end-to-end enterprise social platform for your organization. You can extend the social experience directly into your Microsoft Office 365 or on-premises SharePoint portal with a range of options from Yammer Embed to the REST API. We explore the ins and outs of Yammer integration, capabilities, terms of service, and governance for production applications. Learn how we can use Yammer methods as well as reference the powerful Office 365 dev patterns and practices. There are recommended dos and don’ts, which we highlight with relevant real-world case studies. We cover effective design for enhanced user experience and engagement, making your Portal and Yammer a seamless experience to increase usage and adoption.
http://channel9.msdn.com/Events/Ignite/2015/BRK3201

Elastic SharePoint Storage with StorSimple and Microsoft Azure  
One of the biggest challenges facing enterprise storage customers is massive data growth and the amount of storage management work required to keep up with it. In this session, we dive deep into Remote BLOB Storage architecture, boundaries and scale limits, disaster recovery, and improvements in Microsoft SharePoint Server 2016. In addition, we look at how Azure StorSimple hybrid cloud storage can support SharePoint.
http://channel9.msdn.com/Events/Ignite/2015/BRK4101

Microsoft SharePoint Server with SQL Server: Now Better Than Ever  
Learn how you can enrich your SharePoint Server deployment when you take advantage of specific configurations and features of SQL Server. This session will focus on SQL Server 2014 benefits for SharePoint 2013 and offer insights into how it sets you up for SharePoint Server 2016. We will cover areas of performance, security, reliability – all covered with lots of best practices and core depth knowledge for the most successful better together deployment.
http://channel9.msdn.com/Events/Ignite/2015/BRK4131

SharePoint 2013 and Azure IaaS: Better Together  
Get an overview of the options that Microsoft Azure provides for SharePoint. This session explains and demos how you can utilize Azure to host SharePoint farms for hot and warm standby, segregated farms for your developers, farms for integration testing or productive farms. We explain how you can create your own template for SharePoint servers that enables you to add a server to your farm in Azure or on-premises in 15 minutes. We also help you to develop a backup strategy for SharePoint that uses Azure as the storage for long-term backups.
http://channel9.msdn.com/Events/Ignite/2015/BRK3124

Transforming Your SharePoint Full Trust Code to the Office App Model  
This session is a panel discussion covering examples and patterns for moving SharePoint customizations to the app model - for use either in Office 365 or "cloud-friendly" implementations of on-premises SharePoint. The panel comprises members of the Microsoft Office Dev Patterns and Practices team and independent MVPs. Both bring their experiences from the field, but different perspectives too. The discussion will centre around 5 related hot topics - branding, options around remote code (including .NET, JavaScript and PowerShell), provisioning of customized sites, the story with sandbox solutions and finally how the Office 365 APIs fit in with the app model. We promise a lively discussion, examples of code from the field, and time for Q&A!
http://channel9.msdn.com/Events/Ignite/2015/BRK4125

The future of Forms for SharePoint 2016 and Office 365

As you might remember, Microsoft announced last year, that InfoPath will be discontinued. It seemed the product would come to an end and would only be supported until April 2023. All efforts from Microsoft were heading into Forms designed on SharePoint Lists, or better known as FoSL.

Well these plans have changed. As it seems Microsoft will not be able to provide FoSL on time for the next SharePoint release. Instead they announced that SharePoint 2016 will indeed have full support for InfoPath Forms for Office 365 and On Premises installations. However, a new version of InfoPath will not be part of the next Office.

Read the full story at:
http://blogs.office.com/2014/01/31/update-on-infopath-and-sharepoint-forms/

SharePoint 2015 is peeking thru

Today I was working with the SharePoint Design Manager on Office365 when I found something interessting:

Wave 16 can already be selected in Office365

It seems like Microsoft is already testing Office Wave 16 in the field or at least preparing for it. It is possible to select the Option for SharePoint 2015, but you will get an error that uploading has been disabled by the administrator.