The Curious Engineer

All blogs / Databases

SQL BI

learn.microsoft.com/en-us/archive/blogs/karang

My Experience - Troubleshooting SQL BI Stack

DatabasesMicrosoft blogsMSDN archive

’10’15’20’25
Posts
88 from 8 Nov 2008 to 18 Nov 2018
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/karang/feed.xml

2018 1

  1. Azure Data Factory V2– Pipeline Functional Testing

2017 3

  1. ADF - Azure Data Factory Learning Path
  2. SQLDW: Could not allocate a new page for database
  3. HDInsight: How to find Long Running Queries

2016 2

  1. SSAS Monitoring Tool–SQL 2014 ASTrace
  2. Halo, Minecraft, and More! How Microsoft Studios Processes Gaming Event Data

2015 3

  1. Azure Data Factory: Detecting and Re-Running failed ADF Slices
  2. Microsoft Azure Essentials: Azure Machine Learning
  3. Informative HDInsight Links

2014 4

  1. Harnessing the Power of both worlds
  2. System Patching: Steps need to follow on SSAS Server before applying Windows Patches
  3. Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014
  4. Tabular: Cant see Databases in Management Studio

2013 15

  1. Tabular: .Net Provider supported by Tabular Mode
  2. Introduction to SQL 2012 Tabular Modeling
  3. SQL 2012 TABULAR: Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services
  4. Tabular: Error while using ODBC data source for Importing Data
  5. Power View for Multidimensional Model is Finally Here
  6. HDInsight Whitepapers
  7. SSAS Crashing Intermittently: Caused by Monitoring / AV Scans
  8. Microsoft BI Authentication and Identity Delegation
  9. Connectivity Issue: "A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running"
  10. DAX: Using filter and summarize in same Query
  11. PowerShell:How to List Database Roles and their Members
  12. Hardware Sizing a Tabular Solution (SQL Server Analysis Services)
  13. HDInsight on Windows: Building PowerPivot Report from Hive in a Few Easy Steps (PDF)
  14. HDInsight on Windows: Building PowerPivot Report from Hive in a Few Easy Steps
  15. HDInsight – What is it?

2012 27

  1. SQL - Parallel Data Warehouse (PDW)
  2. Terms: Data Warehouse and SSAS
  3. Cleared SSAS Maestro (MCM)
  4. SSAS Synchronization: Across different versions
  5. SSAS encryption
  6. SSAS Data Collection: Collecting Perfmon for SSAS
  7. Getting Deadlock Error During Processing
  8. SSDT Query Builder: MDX Query returning NULL instead of AllMembers
  9. Configuring: PowerPivot for Excel 2013
  10. How to use Network Monitor to capture network traffic
  11. Power View Infrastructure Configuration and Installation: Step-by-Step and Scripts
  12. SSAS:Informative Links
  13. SSAS: All Possible Scenarios of Changing SSAS Data Folder
  14. SSAS Monitoring Tool– ASTrace
  15. PowerPivot–Enable Logging
  16. ProcessUpdate–Insight
  17. XMLA– Clear Analysis Services (SSAS) database cache
  18. SSAS Tip - IndexBuildThreashold
  19. Step by Step Guide of Installing Power View with PowerPivot 2012
  20. PowerPivot: Error while saving a file to PowerPivot Gallery
  21. Mining Structure: Issue while Processing when DataSource is OLAP Cube
  22. Add a BI Semantic Model Connection Content Type to a Library (PowerPivot for SharePoint)
  23. Excel: How to Enable Multi Thread in Excel 2010
  24. DAX-SUMMARIZE (ROLLUP)
  25. What is a Windows Azure Boot Camp?
  26. SQL Server 2012 Virtual Labs
  27. You can also find me on wordpress…..

2011 8

  1. It takes 4 Clicks to Build a Model (Cube) in Denali Tabular Mode
  2. PowerShell: Getting Cube XMLA
  3. SSAS Cluster: Issue with Mount Points while Performing Administrative Tasks
  4. MDX:Handling division by zero errors
  5. Top 10 products with Lowest Reseller Order count of at least 400.
  6. MDX Descendant Function
  7. SSAS 2005 Backup/Restore Limitation
  8. Different Kinds of SSAS Processing in simple words…..

2010 11

  1. Enabling SSAS Clustered Instance to listen on Multiple IP Addresses
  2. YTD Based on Current System Date
  3. During ETL detecting dirty records from Fact
  4. Slowly Changing Dimension using SSIS
  5. SQL Server Deployment Property (Retain Configuration Setting)
  6. How to Deal with Corruption in Analysis Services
  7. Migrating OLAP SSAS 2005 Database to SQL 2008
  8. Running AS Command(XMLA / MDX) as a Batch Job Using SSIS Package
  9. Updated SSAS Profiler Trace Scheduler Tool
  10. SSAS Profiler Scheduler
  11. Moving Data Directory of Analysis Services (SQL 2005 / 2008)

2009 7

  1. Why do we need SPN for File Server (NAS / RAS / File Share System) DNS Alias (Cname)
  2. SQL 2005 (SQL 2008) Analysis Services Server Side Tracing
  3. How to Warm AS Cache using SSIS Package
  4. Tampering master.vmp file may result in losing all Analysis Services Databases
  5. Analysis Services Preallocate Memory Setting – Insight
  6. SQL Server Analysis Services Port (SQL 2005 / 2008)
  7. Gemini (In-Memory Business Intelligence)

2008 7

  1. SQL 2005 SPN (SSAS/SSRS/SQL)
  2. SSAS(64 Bit) and Oracle Client Issues
  3. SSAS Performance Counter Error while collecting BLG file Reference error message: Access is denied.
  4. Configuring Datapump in IIS 7
  5. SSAS 2005:Performance
  6. Which Engine (Storage / Formula) causing MDX Performance Issue?
  7. SSAS:Informative Links