November 10, 2016
5488 Views

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 [···]

Read More

April 08, 2016
3932 Views

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 [···]

Read More

January 06, 2015
3543 Views

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 [···]

Read More

June 24, 2014
1432 Views

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 [···]

Read More

June 18, 2014
15245 Views

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 [···]

Read More

August 04, 2013
2486 Views

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 [···]

Read More

July 03, 2013
2335 Views

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 [···]

Read More

May 07, 2013
1656 Views

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 [···]

Read More

September 04, 2012
2661 Views

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 [···]

Read More

July 12, 2012
1376 Views

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 [···]

Read More

July 12, 2012
1287 Views

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 [···]

Read More