Index Related Dynamic Management Views and Functions

Dynamic Management Views (DMV) was introduced in SQL Server 2005 and every SQL Server release Microsoft introduces additional DMVs, which helps to provide information about the health of a Server instance, performance and Server issues. There are two types of DMV, the first type is server-scoped DMV which requires VIEW SERVER STATE permission on the Server … Read moreIndex Related Dynamic Management Views and Functions

Power BI – Working with Date – Part I

I have been working with Power BI for few years and quite often someone asks me questions about Date functions in DAX (Data Analysis Expressions), that is the reason I am writing this post. As prerequisites, your Power BI model needs to have a Date table, which will be used to create a couple of … Read morePower BI – Working with Date – Part I

Invoking R script file in SQL Server 2016

The sp_execute_external_script is a stored procedure to execute script at an external location. The system sp_execute_external_script stored procedure was introduced in SQL Server 2016 and only supports R language. This post, I will show how to invoke an R script file in SQL Server 2016. Prerequisites Install SQL Server 2016 with R Server Enable External … Read moreInvoking R script file in SQL Server 2016

Compatibility Level – Tabular Model

Before we talk about Compatibility Level on Tabular model project, it is important to explain what is Compatibility Level. Compatibility Level  is the version of SQL Server with which a Database or Tabular model is compatible. Follow the compatibility level for databases: 80 = SQL Server 2000 90 = SQL Server 2005 100 = SQL … Read moreCompatibility Level – Tabular Model

Excel Services configuration on SharePoint 2010

In this document, I will explain how to configure Excel Services on Microsoft SharePoint 2010 and how to solve an issue that may occur during Excel Services configuration\testings. Configuration Enable Claims to Windows Token Service The first step, check the status of the Claims to Windows Token Service on SharePoint. Use the following instructions to … Read moreExcel Services configuration on SharePoint 2010

Installing SQL Server 2012 and SharePoint 2010

In this document I will explain how install SQL Server 2012, SharePoint 2010, PowerPivot and Tabular Mode in the same server, for testing/development propose. As a first step update the Windows Server with the latest Service Pack and hotfix. SQL Server 2012 Installation page, click New SQL Server stand-alone installation. Setup Support Roles page, click OK. … Read moreInstalling SQL Server 2012 and SharePoint 2010