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. In the …

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. SQL Server 2016 Downloads Below are few SQL Server download …

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. 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 We will certainly learn how to configure these …

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. Again I would like to emphasize more for our SharePoint techies as it is a primary and important step to configure SharePoint …

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

Create Configure and Use SQL Server Database using Microsoft Azure

create configure SQl server microsoft azure 4

In this Article I had explained how to create, configure and SQL Server database in Microsoft Azure. Open Microsoft Azure Portal. Logged in with your subscription Microsoft account In your portal Click New -> SQL database Click Add Provide the database name and select the subscription of your account Create a new resource group Click …

Read moreCreate Configure and Use SQL Server Database using Microsoft Azure

SQL Server Physical File Fragmentation Complete Guide

SQL Server Physical File Fragmentation Complete Guide

Problem:Most of the time while working on SQL Server, users face a server’s performance issue, which is due to the bad structure of database or SQL Server Physical File Fragmentation. Solution:Physical File Fragmentation in SQL Server has been a problem since the first file was written into floppy disk drive by using DOS. If contiguous …

Read moreSQL Server Physical File Fragmentation Complete Guide

>