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...
2020-04-07 (first published: 2020-03-30)
132 reads
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...
2020-01-23
26 reads
Introduction I recently got a call from our DBA telling me that the CPU usage is hitting 100% on the DB server and the ETL process runs for more...
2019-09-04 (first published: 2019-08-26)
646 reads
Introduction
Have you ever found yourself in a situation where you were supposed to troubleshoot a long running expensive query that...
2019-03-06 (first published: 2019-02-19)
2,855 reads
Implicit Conversions – Introduction
In this blog post, I’ll explain and demonstrate how to use Extended Events to detect Implicit Conversions that...
2019-01-24 (first published: 2019-01-15)
2,498 reads
The Problem
During our workload we have recognized a difference in performance for queries using IN clause. We are building query...
2018-12-18
148 reads
Background
In the past, Windows Server Failover Clustering (WSFC) cluster only monitored the health of your entire Always On Availability Groups...
2018-11-20
266 reads
Background
Our customer has recently experienced an issue during the installation of the latest cumulative updates in their SQL Server environment....
2018-11-05
499 reads
When developing DAX measure, you should be aware that Blank value behavior might be similarly insidious as NULL value in...
2018-10-23
395 reads
In Joyful Craftsmen we provide, among other things, technical support to our customers, which from time to time involves us...
2018-10-16
332 reads
Sometimes in life you have to do things you really don’t like to do....
By HamishWatson
Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...
By Steve Jones
Last week went a little crazy, and I learned something: don’t post a Zoom...
Hi, I need to include a very simple schema in all of my database...
This is my first time dealing with CLR assemblies and we have setup some...
Hi, I have a requirement to convert a date value like '7th March 2020' ...
Ask SSC