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...
Introduction I recently got a call from our DBA telling me that the CPU usage is hitting 100% on the DB server and the...
Introduction Have you ever found yourself in a situation where you were supposed to troubleshoot a long running expensive query that was hammering your...
Implicit Conversions – Introduction In this blog post, I’ll explain and demonstrate how to use Extended Events to detect Implicit Conversions that affect execution...
Introduction In this blog post, I would like to describe two case scenarios of bulk loading data, using SSIS, into a partitioned table that...
Introduction In this blog post, I would like to explain what a columnstore segment elimination is and how to load data to achieve better...