Blog – Joyful Craftsmen – The Business Intelligence Agency

Clustered Column Store Load Pitfalls – Magic number 64 when using WHERE IN clause

December 18, 2018

Column Store Index, Performance, SQL Server Central

The Problem During our workload we have recognized a difference in performance for queries using IN clause. We are building query dynamically, so you can have a different length of…

Watch out – new Database Level Health Detection can send your AOAG down!

November 20, 2018

Database, Errors, SQL Server Central

No Comments

Background In the past, Windows Server Failover Clustering (WSFC) cluster only monitored the health of your entire Always On Availability Groups (AO AG) primary replica. This meant that even when…

Není v JC pohovor jako “pohovor”

November 9, 2018

No Comments

Slávka je náš happiness manager s velkým “H”, který je s námi už od samého počátku. Nejen, že neustále pomáhá JC budovat, ale baví jí také poznávat nové lidi z…

Failed Installation of SQL Server Cumulative Updates Debugged

November 5, 2018

Errors, KB, SQL Server Central

No Comments

Background Our customer has recently experienced an issue during the installation of the latest cumulative updates in their SQL Server environment. Instances for one specific application ended in a crashed…

DAX – Cumulative Total and Blank Handling

October 23, 2018

Power BI, SQL Server Central, SSAS, Tabular

No Comments

When developing DAX measure, you should be aware that Blank value behavior might be similarly insidious as NULL value in DB. Sometimes it can surprise you as shown in the…

Internal Query Processor Error Debugged

October 16, 2018

Database, Errors, SQL Server Central

No Comments

In Joyful Craftsmen we provide, among other things, technical support to our customers, which from time to time involves us in very interesting cases. One of them occurred after a…

Clustered Column Store Load Pitfalls – Magic number 64 when using WHERE IN clause

Watch out – new Database Level Health Detection can send your AOAG down!

Není v JC pohovor jako “pohovor”

Failed Installation of SQL Server Cumulative Updates Debugged

DAX – Cumulative Total and Blank Handling

Internal Query Processor Error Debugged

About the Company

Partnership

Contacts