Database tech resource

Power BI desktop limitation

Introduction This article describes limitation of Power BI desktop tool. It is based on my practical...

Author: Ajit Kumar Thakur Date: 06/24/2016

Unzip memory stream and load into Azure blob container

Introduction This article is used for getting memory stream of zip file, uncompress memory stream...

Author: Ajit Kumar Thakur Date: 06/23/2016

Create Blob Container in Azure Storage

Introduction This article is used for creating blob container using c# code. It uses azure...

Author: Ajit Kumar Thakur Date: 06/23/2016

Business Intelligence Reporting through Datazen

Introduction Datazen Software – industry leader in mobile business intelligence and data...

Author: Ajit Kumar Thakur Date: 04/26/2015

Read OLAP cube and display in simple SSRS report

Introduction This article is for beginner who wants to read data from SSAS cube. Numbers are...

Author: Ajit Kumar Thakur Date: 04/04/2015

OLAP cube reading through MDX :part 2

Introduction This article contains calculation process used in MDX. I have already covered basic MDX...

Author: Ajit Kumar Thakur Date: 04/04/2015

Learning DOS batch shell script

Introduction Professionally I am Database and BI consultant. mostly I work on SQL Server and BI...

Author: Ajit Kumar Thakur Date: 04/04/2015

Retrieve SSRS report server database information

Introduction Microsoft provided SSRS for report development. we develop report for business analysis...

Author: Ajit Kumar Thakur Date: 04/04/2015

step by step SSAS cube designing

Introduction This article explain step by step process to implement SSAS Cube.SSAS Cube allow...

Author: Ajit Kumar Thakur Date: 04/04/2015

Read OLAP cube and display in SSRS report with parameter

Introduction This article is based on SSRS report which accept parameters.Report paramters gets...

Author: Ajit Kumar Thakur Date: 04/04/2015

Retrieve metadata information in SQL Server 2012

Introduction Learning SQL server internal begins with collecting metadata information of system. SQL...

Author: Ajit Kumar Thakur Date: 04/03/2015