A few months ago, I was involved in an interesting project where a large customer (not to be named due to NDA) needed to migrate their...

Revisiting my post on change data capture on Azure data factory, I want to see what's new on this front.

By Eric Rouach, DBA & Data Engineer at Madeira Data Solutions July 2023 With Active Geo-Replication , you can create a read-only...

As a DBA, understanding your customers' needs is crucial. In this blog post, I'll discuss how the SPIN sales strategy can help you, the...

אינדקסים הם כלי בעל חשיבות עצומה בכל מה שקשור לשליפות (ואולי גם עדכונים) של טבלאות, וככלל ניתן לומר כך: כשאין אינדקס אנחנו "מרוויחים"...

"New, better alternative to Pie Charts: Treemap" this is a title I meet a lot in many blog posts and articles about data visualization....

Azure data factory has an agent for on-prem networks called self-hosted integration runtime. The most common use case is accessing data sour

This month's T-SQL Tuesday topic is "Code That Made You Feel A Way", hosted by Erik Darling. Here is my story about Trigram Search...

In this blog post, we will take an in-depth look at Synapse Studio and its various components...

The " Last Page Insert Contention " in SQL Server, also known as " Latch Convoy Problem ", also known as " PageLatchEx Contention " is...