Blog | Madeira Data Solutions

Working with templates in Azure data factory

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

A picture in PowerBI is worth a thousand words

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

Why Tornado is a disaster even as a graph?

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

External tables with SQL user

Accessing Synapse serverless SQL pool external table with an SQL user

Use your hints in the right way

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

Bad habits: unnecessary counting

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....

SQL Server Query Store and how to enable it

One of the biggest disadvantages of SQL Server has always been the lack of a monitoring system. A system that collects performance...

What is the internal database version, and how does it affect our work?

A few months ago, one of my customers asked me to create a new DEV environment. The interesting part of the project was the request for...

How to downgrade SQL Server edition

Recently, one of my customers decided to downgrade the SQL Server edition. It was an Enterprise to Standard change, due to licensing...

Link Power BI to Azure Synapse Analytics

Author: Eric Rouach, Madeira Data Solutions Date: October 2022 Pre-requisites: · Basic/Intermediate understanding of Microsoft...

Contact Us