SQL BI

My Experience - Troubleshooting SQL BI Stack

Azure Data Factory V2– Pipeline Functional Testing

This article helps you to understand functional testing with pipelines in Azure Data Factory. Note:-...

Author: Karan Gulati (SSAS Maestro) Date: 11/18/2018

ADF - Azure Data Factory Learning Path

If you are looking to learn Azure Data Factory (ADF) it’s a good path to start, as it covers various...

Author: Karan Gulati (SSAS Maestro) Date: 05/10/2017

SQLDW: Could not allocate a new page for database

Issue: Recently I faced an issue where Stored Procedure running on SQLDW failing with error as...

Author: Karan Gulati (SSAS Maestro) Date: 02/16/2017

HDInsight: How to find Long Running Queries

Coming from SQL background where you have dependency on SQL Profiler Trace for understanding what’s...

Author: Karan Gulati (SSAS Maestro) Date: 01/25/2017

SSAS Monitoring Tool–SQL 2014 ASTrace

Refer SSAS Monitoring Tool– ASTrace to learn more about ASTrace, this post was pending for a long...

Author: Karan Gulati (SSAS Maestro) Date: 12/01/2016

Halo, Minecraft, and More! How Microsoft Studios Processes Gaming Event Data

My first video on Channel 9, it talks about how we Handle various Events generated from Games……….....

Author: Karan Gulati (SSAS Maestro) Date: 02/17/2016

Azure Data Factory: Detecting and Re-Running failed ADF Slices

  Recently I came across  a scenario where I need to detect failed slices of all Datasets...

Author: Karan Gulati (SSAS Maestro) Date: 11/12/2015

Microsoft Azure Essentials: Azure Machine Learning

  Microsoft Azure Essential: Azure ML Free book is pretty informative if you wanted to learn...

Author: Karan Gulati (SSAS Maestro) Date: 04/16/2015

Tried to collate informative articles related to HDInsight. In comments section please add URLs of...

Author: Karan Gulati (SSAS Maestro) Date: 01/20/2015

Harnessing the Power of both worlds

  Harness the Power of Both Worlds –SQL Engine and Analysis Services Introduction The...

Author: Karan Gulati (SSAS Maestro) Date: 11/16/2014

System Patching: Steps need to follow on SSAS Server before applying Windows Patches

  Generally when we apply System Level patches we tend to reboot Machine / Server multiple...

Author: Karan Gulati (SSAS Maestro) Date: 07/15/2014

Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014

  This white paper describes how business intelligence developers can apply query and...

Author: Karan Gulati (SSAS Maestro) Date: 05/28/2014

Tabular: Cant see Databases in Management Studio

  Background You have a Role which got only Read Permission for Tabular Database with users who...

Author: Karan Gulati (SSAS Maestro) Date: 03/26/2014

Tabular: .Net Provider supported by Tabular Mode

  Yes, tabular server supports .Net Provider but only for those Data Sources which are...

Author: Karan Gulati (SSAS Maestro) Date: 09/10/2013

Introduction to SQL 2012 Tabular Modeling

3rd August, 2013 Presented a Session about SQL 2012 Tabular Server for DBA’s in an Event Organized...

Author: Karan Gulati (SSAS Maestro) Date: 08/06/2013

SQL 2012 TABULAR: Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services

Most Awaited Tabular Performance Tuning Paper is out…………. Applies to: SQL Server 2012 Summary:...

Author: Karan Gulati (SSAS Maestro) Date: 08/02/2013

Tabular: Error while using ODBC data source for Importing Data

Issue When using ODBC as a Data Source in the Table Import Wizard to add data to a Tabular Server,...

Author: Karan Gulati (SSAS Maestro) Date: 07/25/2013

Power View for Multidimensional Model is Finally Here

I am pretty excited about this feature with SQL 2012 SP1 Cumulative Update 4,  you can create...

Author: Karan Gulati (SSAS Maestro) Date: 06/03/2013

HDInsight Whitepapers

  Informative Whitepapers covering operation of HDInsight including: 1) Compression in Hadoop...

Author: Karan Gulati (SSAS Maestro) Date: 04/15/2013

SSAS Crashing Intermittently: Caused by Monitoring / AV Scans

Problem Description: Analysis Services crashed, generating dump file. Assessment: The issue is SMS...

Author: Karan Gulati (SSAS Maestro) Date: 04/08/2013

Microsoft BI Authentication and Identity Delegation

  From straightforward client/server designs to complex architectures relying on distributed...

Author: Karan Gulati (SSAS Maestro) Date: 03/11/2013

Connectivity Issue: "A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running"

Symptoms: SSAS Named Instance running on cluster with two nodes, on one instance we are able to...

Author: Karan Gulati (SSAS Maestro) Date: 02/20/2013

DAX: Using filter and summarize in same Query

In this SQL Query we are grouping Sales by Year and Color plus adding a filter of 5000 select...

Author: Karan Gulati (SSAS Maestro) Date: 02/15/2013

PowerShell:How to List Database Roles and their Members

1: [Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") 2: $ServerName...

Author: Karan Gulati (SSAS Maestro) Date: 02/05/2013

Hardware Sizing a Tabular Solution (SQL Server Analysis Services)

Applies to: SQL Server 2012 Analysis Services, Tabular Solutions Summary: Provides guidance for...

Author: Karan Gulati (SSAS Maestro) Date: 01/11/2013

HDInsight on Windows: Building PowerPivot Report from Hive in a Few Easy Steps (PDF)

Download Step by Step PDF from Slide Share HDInsight on Windows: Building PowerPivot Report from...

Author: Karan Gulati (SSAS Maestro) Date: 01/07/2013

HDInsight on Windows: Building PowerPivot Report from Hive in a Few Easy Steps

What are we Covering: Hive Create table Load Data Query Data Configure ODBC Create PowerPivot With...

Author: Karan Gulati (SSAS Maestro) Date: 01/04/2013

HDInsight – What is it?

HDInsight is Microsoft’s Hadoop-based distribution. HDInsight comes in two flavors: HDInsight Server...

Author: Karan Gulati (SSAS Maestro) Date: 01/04/2013

SQL - Parallel Data Warehouse (PDW)

In this presentation we will figure out what's SQL PDW, SMP Vs. MPP and world of Appliance.... SQL -...

Author: Karan Gulati (SSAS Maestro) Date: 12/28/2012

Terms: Data Warehouse and SSAS

  Data warehouse and ssas terms from Karan Gulati

Author: Karan Gulati (SSAS Maestro) Date: 12/24/2012

Cleared SSAS Maestro (MCM)

  Finally achieved highest certification in SSAS world. What is the SSAS Maestros? The SSAS...

Author: Karan Gulati (SSAS Maestro) Date: 12/18/2012

SSAS Synchronization: Across different versions

  Problem Statement: Synchronization between different builds or versions of Analysis Services....

Author: Karan Gulati (SSAS Maestro) Date: 10/24/2012

SSAS encryption

Description: Customer asking if AS supports TDE like encryption we got in SQL Engine. Solution: SSAS...

Author: Karan Gulati (SSAS Maestro) Date: 10/23/2012

SSAS Data Collection: Collecting Perfmon for SSAS

Applies to Windows7, Windows 2008/R2 and Vista SQL Server all builds >= SQL 2005 Generally, for...

Author: Karan Gulati (SSAS Maestro) Date: 10/01/2012

Getting Deadlock Error During Processing

Issue: Intermittently Getting below mentioned error during processing OLE DB error: OLE DB or ODBC...

Author: Karan Gulati (SSAS Maestro) Date: 09/27/2012

SSDT Query Builder: MDX Query returning NULL instead of AllMembers

  *SSDT – SQL Server Data Tools *SSMS – SQL Server Management Studio In SSDT Query Designer...

Author: Karan Gulati (SSAS Maestro) Date: 09/19/2012

Configuring: PowerPivot for Excel 2013

  For configuring PowerPivot in Excel 2013 you need to follow below mentioned steps: In Excel...

Author: Karan Gulati (SSAS Maestro) Date: 09/18/2012

How to use Network Monitor to capture network traffic

  Often I need to share these steps with customers while troubleshooting Connectivity issues,...

Author: Karan Gulati (SSAS Maestro) Date: 09/17/2012

Power View Infrastructure Configuration and Installation: Step-by-Step and Scripts

Power View implementation paper is out and covers major scenarios of implementing Power View with...

Author: Karan Gulati (SSAS Maestro) Date: 08/15/2012

  SSAS 2012 Links Free SQL 2012 EBook SQL 2012 Virtual Labs DAX in the BI Tabular Model...

Author: Karan Gulati (SSAS Maestro) Date: 07/31/2012

SSAS: All Possible Scenarios of Changing SSAS Data Folder

Title - All Possible Scenarios of Changing SSAS Data Directories Scenario 1: Recreating a New Data...

Author: Karan Gulati (SSAS Maestro) Date: 07/30/2012

SSAS Monitoring Tool– ASTrace

Guys, We have noticed customers asking a tool for  Monitoring SSAS Activities;  So we have...

Author: Karan Gulati (SSAS Maestro) Date: 06/05/2012

PowerPivot–Enable Logging

For enabling Verbose Logging follow these steps - Go to Central Admin and Click on Monitoring Click...

Author: Karan Gulati (SSAS Maestro) Date: 05/18/2012

ProcessUpdate–Insight

ProcessUpdate applies only to Dimension. It is the equivalent of incremental dimension processing in...

Author: Karan Gulati (SSAS Maestro) Date: 05/03/2012

XMLA– Clear Analysis Services (SSAS) database cache

How to clear cache of a cube <ClearCache...

Author: Karan Gulati (SSAS Maestro) Date: 04/26/2012

SSAS Tip - IndexBuildThreashold

<IndexBuildThreshold> Index creation is controlled by the number of rows, specified in the...

Author: Karan Gulati (SSAS Maestro) Date: 04/20/2012

Step by Step Guide of Installing Power View with PowerPivot 2012

Install Win 2008 R2 + SP1 Roles IIS Add .Net Framework 3.5 Features Features Add Desktop Experience...

Author: Karan Gulati (SSAS Maestro) Date: 04/13/2012

Issue: Using Excel 2010 when try to save a file to SharePoint Gallery it fails with error stating:...

Author: Karan Gulati (SSAS Maestro) Date: 02/28/2012

Mining Structure: Issue while Processing when DataSource is OLAP Cube

  When processing SSAS Data Mining Structure which is based on a Cube (DataSource is Used as...

Author: Karan Gulati (SSAS Maestro) Date: 02/20/2012

Next>