Blog – Joyful Craftsmen – The Business Intelligence Agency

Azure Analysis Services – Processing Hot & Cold Data using Tabular model partitions

March 30, 2020

Architecture, Azure, SQL Server Central, SSAS, Tabular

Introduction Recently have been working on a “Proof of Concept” task where I wanted to test the capabilities of Azure Analysis Services Tabular model when loading data from different sources…

We achieved GOLD Microsoft competency in DevOps!

March 6, 2020

No Comments

We Joyful Craftsmen are happy to announce, that we achieved already 3rd significant milestone in our competency history. Last week we officially became GOLD Microsoft Partner – in the super…

Microsoft TSQL Certification

February 4, 2020

JC, Study

No Comments

Working with data is a daily routine for hundreds of database experts in Prague, but how many of these are guaranteed specialists, is it the same number as before? How…

Loading data with umlauts from SQL server into Oracle using SSIS and OLE DB driver

January 27, 2020

Data Warehouse, Oracle, SSIS

No Comments

Recently, I was developing a simple SSIS package. The purpose of the SSIS package was extraction of a data from MS SQL server into Oracle database. Extraction data flow was…

SSAS Tabular – Process Add memory consumption

January 23, 2020

Performance, SQL Server Central, SSAS, Tabular

No Comments

For me it’s a bit surprising how little information can be found regarding the “Process Add” option which I consider as the best choice for incremental data load to SSAS…

Test Automation Base Camp

January 19, 2020

Event, JC, Performance, Testing

The purpose of this post is to briefly introduce Test Automation Base Camp, a workshop for testers, which Tomas Pribyl and I attended on the 2nd and 3rd of November,…

Azure Analysis Services – Processing Hot & Cold Data using Tabular model partitions

We achieved GOLD Microsoft competency in DevOps!

Microsoft TSQL Certification

Loading data with umlauts from SQL server into Oracle using SSIS and OLE DB driver

SSAS Tabular – Process Add memory consumption

Test Automation Base Camp

About the Company

Partnership

Contacts