SharePoint 2016 Multi-Server Farm Installation Guide

It’s very important to follow best practice installation for SharePoint Farm specially for staging and production environments. Most of the time we learn things with self-experience and follow the basic installation instructions. You can install SharePoint with basic/default settings for Dev environments or for single server installation but need to follow the best practices when …

Continue reading ‘SharePoint 2016 Multi-Server Farm Installation Guide’ »

SharePoint Performance Issue- Set Memory Limits on SQL Server

By default, SQL Server is set to use max 2TB of RAM. You might not be having 2TB RAM in your environment, you might have 8GB, 16GB or more depending on your farm and SharePoint installation. Here is a formula to determine memory size for all instances of SQL Server. SQL Max Memory= TotalPhysicalMemory – …

Continue reading ‘SharePoint Performance Issue- Set Memory Limits on SQL Server’ »

Hostname Alias for SQL Server Instance

A Hostname alias SQL Server instance is a simple Hostname that allows clients to connect to an instance of SQL Server without specifying an instance name or a port number. They are very useful for upgrades, server migration, consolidation and disaster recovery. A network alias can redirect clients from one server to another. This is …

Continue reading ‘Hostname Alias for SQL Server Instance’ »

Best Practice: SQL Server settings before deploying SharePoint Server 2016

Do not enable auto-create statistics on a server that hosts SQL Server and SharePoint Server. Enabling auto-create statistics is not supported for SharePoint Server. SharePoint Server configures the required settings during provisioning and upgrade. Manually enabling auto-create statistics on a SharePoint database can significantly change the execution plan of a query. We recommend updating the …

Continue reading ‘Best Practice: SQL Server settings before deploying SharePoint Server 2016’ »

SQL Server 2012/R2/2014/2016 Installation Step by Step

In this blog post I will be sharing step by step installation detail for SQL Server with Best Practice for SharePoint. SQL Software requirements 64-bit edition of Microsoft SQL Server 2012 R2 or SQL Server 2014/16 Standard (Enterprise required for Always On) Named SQL alias recommended. Windows Server 2012/R2/2014/16 with latest patch levels should be …

Continue reading ‘SQL Server 2012/R2/2014/2016 Installation Step by Step’ »

Add .NET Windows Server Feature on Windows Server

When you are going to setup for a new SharePoint Farm, you need to install .Net windows feature on all servers (SQL and SharePoint). Follow the below steps to add .net Windows feature windows server. To add the .NET Windows Server feature, click on Start > All Programs > Administrative Tools > Server Manager. From …

Continue reading ‘Add .NET Windows Server Feature on Windows Server’ »

SharePoint Farm User Accounts

When you are going to deploy a SharePoint Farm, you need a set of user accounts with proper roles and permissions, in this blog post I am going to share the list of recommended user accounts required for a SharePoint 2016 Farm with their roles. I will share the installation details in later blog posts. …

Continue reading ‘SharePoint Farm User Accounts’ »

Collection of e-Books and Articles on Microsoft Technologies

I have came through below wiki article on Microsoft technet, which have a nice collection of eBooks and articles on Microsoft Technologies. Download content for SharePoint, Lync, MS Office, SQL Server, System Center, Visual Studio, Web Development (asp.net), Windows Server, Window Azure, Windows Phone and other Microsoft technologies in e-book formats (references, guide, and step-by-step). E-Book …

Continue reading ‘Collection of e-Books and Articles on Microsoft Technologies’ »