🔍 Discover why SQL Server's ALTER TABLE SWITCH encounters errors 4907, 4908, and 4912! 🚀

Today, I was late for team meeting ... :( When I joined a Teams meeting, the team discussed ANSI_PADDING. One of the teammates fires at...

A date dimension is extremely useful and is required by most BI applications. Here is a code sample for creating one on Azure Databricks

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