Nov10
3076 Views
2 minutes read

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

Apr08
2505 Views
5 minutes read

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

Jan06
1824 Views
3 minutes read

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

Jun24
695 Views
3 minutes read

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

Jun18
10754 Views
4 minutes read

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

Aug04
1510 Views
2 minutes read

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

Jul03
1295 Views
1 minute read

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

May07
760 Views
3 minutes read

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

Sep04
1581 Views
12 minutes read

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

Jul12
697 Views
2 minutes read

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

Jul12
643 Views
1 minute read

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