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:-...
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...
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...
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...
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...
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……….....
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...
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...
Date: 04/16/2015
Informative HDInsight Links
Tried to collate informative articles related to HDInsight. In comments section please add URLs of...
Date: 01/20/2015
Harnessing the Power of both worlds
Harness the Power of Both Worlds –SQL Engine and Analysis Services Introduction The...
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...
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...
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...
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...
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...
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:...
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,...
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...
Date: 06/03/2013
HDInsight Whitepapers
Informative Whitepapers covering operation of HDInsight including: 1) Compression in Hadoop...
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...
Date: 04/08/2013
Microsoft BI Authentication and Identity Delegation
From straightforward client/server designs to complex architectures relying on distributed...
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...
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...
Date: 02/15/2013
PowerShell:How to List Database Roles and their Members
1: [Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") 2: $ServerName...
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...
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...
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...
Date: 01/04/2013
HDInsight – What is it?
HDInsight is Microsoft’s Hadoop-based distribution. HDInsight comes in two flavors: HDInsight Server...
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 -...
Date: 12/28/2012
Terms: Data Warehouse and SSAS
Data warehouse and ssas terms from Karan Gulati
Date: 12/24/2012
Cleared SSAS Maestro (MCM)
Finally achieved highest certification in SSAS world. What is the SSAS Maestros? The SSAS...
Date: 12/18/2012
SSAS Synchronization: Across different versions
Problem Statement: Synchronization between different builds or versions of Analysis Services....
Date: 10/24/2012
SSAS encryption
Description: Customer asking if AS supports TDE like encryption we got in SQL Engine. Solution: SSAS...
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...
Date: 10/01/2012
Getting Deadlock Error During Processing
Issue: Intermittently Getting below mentioned error during processing OLE DB error: OLE DB or ODBC...
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...
Date: 09/19/2012
Configuring: PowerPivot for Excel 2013
For configuring PowerPivot in Excel 2013 you need to follow below mentioned steps: In Excel...
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,...
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...
Date: 08/15/2012
SSAS:Informative Links
SSAS 2012 Links Free SQL 2012 EBook SQL 2012 Virtual Labs DAX in the BI Tabular Model...
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...
Date: 07/30/2012
SSAS Monitoring Tool– ASTrace
Guys, We have noticed customers asking a tool for Monitoring SSAS Activities; So we have...
Date: 06/05/2012
PowerPivot–Enable Logging
For enabling Verbose Logging follow these steps - Go to Central Admin and Click on Monitoring Click...
Date: 05/18/2012
ProcessUpdate–Insight
ProcessUpdate applies only to Dimension. It is the equivalent of incremental dimension processing in...
Date: 05/03/2012
XMLA– Clear Analysis Services (SSAS) database cache
How to clear cache of a cube <ClearCache...
Date: 04/26/2012
SSAS Tip - IndexBuildThreashold
<IndexBuildThreshold> Index creation is controlled by the number of rows, specified in the...
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...
Date: 04/13/2012
PowerPivot: Error while saving a file to PowerPivot Gallery
Issue: Using Excel 2010 when try to save a file to SharePoint Gallery it fails with error stating:...
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...
Date: 02/20/2012