Use Azure data factory to sort files to time hierarchy partitions.

Redundant indexes in SQL Server are a phenomenon that is more common than I'd like to admit. I see it in quite a lot of shops. Meaning,...

Using Change data capture new (preview) feature in Azure data factory

Graph from the "don't try this at home" drawer or a story about how the user sometimes doesn't know what he needs. Several years ago, I...

Pipeline templates in Azure data factory can save you time when creating a complex pipeline, and enable you to use code already developed by

There are 2 ways to integrate images into PowerBI, each with Pros and Cons.

In an effort to break the routine and be original, data visualization practitioners often attempt to create special graphs For example,...

Accessing Synapse serverless SQL pool external table with an SQL user

First, let's look at the Microsoft documentation: Hints are options or strategies specified for enforcement by the SQL Server query...

During my work, I see a lot of databases and TSQL coding. I see many coding mistakes, one of which is counting without actual necessity....