Tag: SQL Server

Sharepoint User Profile Synchronization hangs in Stopping state
Your Sharepoint Database is hosted on Microsoft SQL Server 2014, but you cannot run profile synchronization in SharePoint Server 2013 SP1 by using the [···]

SQL Server 2016 In-Memory OLTP
With the release of SQL Server 2016 RC0, last month, I thought it would be pertinent to review the New Features and Enhancements being [···]

Unable to establish data source connection to external SQL Server from SharePoint 2013
You are using SharePoint 2013 On-Premises. You have successfully configured Kerberos authentication on the SharePoint environment. However, you are not able to connect external [···]

Pivoting in SQL-SERVER
Suppose a manufacturing farm manufactures three products (Brand) say X,Y,Z and it has three sale points (Location) say A,B,C from where they sell those [···]

How to prepare a simple OLAP cube using SQL Server Analysis Services
This blog is created to help people who want to learn OLAP (Online analytical processing) Cube in SSAS. It also helps to analyze data [···]

Reporting Services in SharePoint 2013 Integrated Mode Cannot Support Scale Out Mode
You have deployed SharePoint 2013 with Reporting Services in the SharePoint Integrated mode. From the Central Administration, System Settings>Manage Services on Server, you try [···]

Microsoft’s Big Data Strategy
A number of people thought that Microsoft was not paying much attention to the Big Data space and that all developments were happening in [···]

What is Big Data?
Big Data has been a topic of intense discussion and media hype during the last year or two. A number of people have asked [···]

Install and Configure SQL Server 2012 PowerPivot for SharePoint 2010 Using PowerShell
The PowerPivot feature in SQL Server 2012 provides powerful data mashup capabilities to support self-service BI scenarios. It’s based on the xVelocity in-memory analytics [···]

How can I build a useful Executive Dashboard?
The design of executive dashboards varies depending upon the needs of the executives for which they are designed. However, well-designed executive dashboards commonly have [···]

What is an Executive Dashboard and why do I need one?
Everyone who drives a car understands the importance of a dashboard. How fast are you going? How much gas do you have left? Are [···]