SQL BI
My Experience - Troubleshooting SQL BI Stack
This article helps you to understand functional testing with pipelines in Azure Data Factory. Note:-...
Date: 11/18/2018
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
Issue: Recently I faced an issue where Stored Procedure running on SQLDW failing with error as...
Date: 02/16/2017
Coming from SQL background where you have dependency on SQL Profiler Trace for understanding what’s...
Date: 01/25/2017
Refer SSAS Monitoring Tool– ASTrace to learn more about ASTrace, this post was pending for a long...
Date: 12/01/2016
My first video on Channel 9, it talks about how we Handle various Events generated from Games……….....
Date: 02/17/2016
Recently I came across a scenario where I need to detect failed slices of all Datasets...
Date: 11/12/2015
Microsoft Azure Essential: Azure ML Free book is pretty informative if you wanted to learn...
Date: 04/16/2015
Tried to collate informative articles related to HDInsight. In comments section please add URLs of...
Date: 01/20/2015
Harness the Power of Both Worlds –SQL Engine and Analysis Services Introduction The...
Date: 11/16/2014
Generally when we apply System Level patches we tend to reboot Machine / Server multiple...
Date: 07/15/2014
This white paper describes how business intelligence developers can apply query and...
Date: 05/28/2014
Background You have a Role which got only Read Permission for Tabular Database with users who...
Date: 03/26/2014
Yes, tabular server supports .Net Provider but only for those Data Sources which are...
Date: 09/10/2013
3rd August, 2013 Presented a Session about SQL 2012 Tabular Server for DBA’s in an Event Organized...
Date: 08/06/2013
Most Awaited Tabular Performance Tuning Paper is out…………. Applies to: SQL Server 2012 Summary:...
Date: 08/02/2013
Issue When using ODBC as a Data Source in the Table Import Wizard to add data to a Tabular Server,...
Date: 07/25/2013
I am pretty excited about this feature with SQL 2012 SP1 Cumulative Update 4, you can create...
Date: 06/03/2013
Informative Whitepapers covering operation of HDInsight including: 1) Compression in Hadoop...
Date: 04/15/2013
Problem Description: Analysis Services crashed, generating dump file. Assessment: The issue is SMS...
Date: 04/08/2013
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
In this SQL Query we are grouping Sales by Year and Color plus adding a filter of 5000 select...
Date: 02/15/2013
1: [Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") 2: $ServerName...
Date: 02/05/2013
Applies to: SQL Server 2012 Analysis Services, Tabular Solutions Summary: Provides guidance for...
Date: 01/11/2013
Download Step by Step PDF from Slide Share HDInsight on Windows: Building PowerPivot Report from...
Date: 01/07/2013
What are we Covering: Hive Create table Load Data Query Data Configure ODBC Create PowerPivot With...
Date: 01/04/2013
HDInsight is Microsoft’s Hadoop-based distribution. HDInsight comes in two flavors: HDInsight Server...
Date: 01/04/2013
In this presentation we will figure out what's SQL PDW, SMP Vs. MPP and world of Appliance.... SQL -...
Date: 12/28/2012
Data warehouse and ssas terms from Karan Gulati
Date: 12/24/2012
Finally achieved highest certification in SSAS world. What is the SSAS Maestros? The SSAS...
Date: 12/18/2012
Problem Statement: Synchronization between different builds or versions of Analysis Services....
Date: 10/24/2012
Description: Customer asking if AS supports TDE like encryption we got in SQL Engine. Solution: SSAS...
Date: 10/23/2012
Applies to Windows7, Windows 2008/R2 and Vista SQL Server all builds >= SQL 2005 Generally, for...
Date: 10/01/2012
Issue: Intermittently Getting below mentioned error during processing OLE DB error: OLE DB or ODBC...
Date: 09/27/2012
*SSDT – SQL Server Data Tools *SSMS – SQL Server Management Studio In SSDT Query Designer...
Date: 09/19/2012
For configuring PowerPivot in Excel 2013 you need to follow below mentioned steps: In Excel...
Date: 09/18/2012
Often I need to share these steps with customers while troubleshooting Connectivity issues,...
Date: 09/17/2012
Power View implementation paper is out and covers major scenarios of implementing Power View with...
Date: 08/15/2012
SSAS 2012 Links Free SQL 2012 EBook SQL 2012 Virtual Labs DAX in the BI Tabular Model...
Date: 07/31/2012
Title - All Possible Scenarios of Changing SSAS Data Directories Scenario 1: Recreating a New Data...
Date: 07/30/2012
Guys, We have noticed customers asking a tool for Monitoring SSAS Activities; So we have...
Date: 06/05/2012
For enabling Verbose Logging follow these steps - Go to Central Admin and Click on Monitoring Click...
Date: 05/18/2012
ProcessUpdate applies only to Dimension. It is the equivalent of incremental dimension processing in...
Date: 05/03/2012
How to clear cache of a cube <ClearCache...
Date: 04/26/2012
<IndexBuildThreshold> Index creation is controlled by the number of rows, specified in the...
Date: 04/20/2012
Install Win 2008 R2 + SP1 Roles IIS Add .Net Framework 3.5 Features Features Add Desktop Experience...
Date: 04/13/2012
Issue: Using Excel 2010 when try to save a file to SharePoint Gallery it fails with error stating:...
Date: 02/28/2012
When processing SSAS Data Mining Structure which is based on a Cube (DataSource is Used as...
Date: 02/20/2012