Download and Install SQL Server 2014 SP1 in Windows Server 2016

Download and Install SQL Server 2014 SP1

This SQL Server tutorial will discuss how to download and install SQL server 2014 and also we will see how to download and install Sql Server 2014 SP1 (service pack 1). Step-by-step procedure for installing a new instance of SQL Server 2014 using the SQL Server setup installation wizard in windows server 2016. Check out …

Read moreDownload and Install SQL Server 2014 SP1 in Windows Server 2016

Download & Installation SQL Server 2016 and Management Studio 2017

download and install sql server 2016

In this SQL Server tutorial, we will discuss how to download SQL server 2016 and step by step tutorial on how to install SQL server 2016 and how to install SQL Server management studio 2017. We were going to install in Windows server 2016 laptop. Check out Complete SharePoint Training Course ($46 OFF) SQL Server …

Read moreDownload & Installation SQL Server 2016 and Management Studio 2017

Configure SQL Server Analysis Services (SSAS) in SQL Server 2012 Step by step guide

sql server analysis services download

This SQL Server tutorial explains we will learn how to configure SQL Server Analysis Services (SSAS) in SQL server 2012. Check out Complete SharePoint Training Course ($46 OFF) Being SharePoint guy we need to learn SSAS because SSAS play a major role in SharePoint 2013 BI. SSAS is a prerequisite for: SharePoint PowerPivot SharePoint View …

Read moreConfigure SQL Server Analysis Services (SSAS) in SQL Server 2012 Step by step guide

Importing SQL Server Analysis Services (SSAS) Sample CUBE and Processing the CUBEs

sql server analysis services cube backup

Objective:In my previous article I have explained how to install and configure the SQL Server Analysis Services (SSAS). It is time to extend our knowledge and environment by implementing and processing data. Check out Complete SharePoint Training Course ($46 OFF) Again I would like to emphasize more for our SharePoint techies as it is a …

Read moreImporting SQL Server Analysis Services (SSAS) Sample CUBE and Processing the CUBEs

Killing a SPID in SQL Server and Checking Rollback Progress

How to Kill SPID in SQL Server

The SPID is the identification number that is uniquely assigned to each process whenever a new session is started with the SQL Server. However, when an application is connected to a SQL server, a new SPID (or connection) is created. Check out Complete SharePoint Training Course ($46 OFF) The main purpose of this is to …

Read moreKilling a SPID in SQL Server and Checking Rollback Progress

Fix – Cannot connect to the configuration database error in SharePoint

Cannot connect to the configuration database error in Sharepoint

This SharePoint tutorial, we will discuss how to fix error “cannot connect to the configuration database” in SharePoint. Check out Complete SharePoint Training Course ($46 OFF) When Microsoft users access SharePoint 2010/SharePoint 2013, they come across a very common error i.e. “Cannot connect to the configuration database” which means that SharePoint is unable to synchronize …

Read moreFix – Cannot connect to the configuration database error in SharePoint

>