Blog | Madeira Data Solutions

Is TreeMap the answer to the pie graph's "problems?"

"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 self-hosted integration runtime. what is it and when to use it?

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

Paul White and the Code That Made Me Wow - Trigram Search

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

Exploring Azure Synapse Studio

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

Behold! A Wild Latch-Convoy Problem Appears!

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

Disable activities on Azure Data Factory

A long-awaited new feature in Azure Data Factory (ADF) lets you disable activities in a pipeline

The Story of DBeaver, PostgreSQL, and the silly data engineer

A thrilling story of making a mistake and learning from it (and a little about DBeaver)

Don't Be a Sitting Duck: The Top 15 SQL Server Security Myths

Introduction As a SQL Server DBA, you are responsible for securing your organization's critical data stored in SQL Server. However, there...

$How to Fix the "Login Failed for User NT AUTHORITY\ANONYMOUS LOGON" Error with Linked Servers$

How to Fix the "Login Failed for User NT AUTHORITY\ANONYMOUS LOGON" Error with Linked Servers

Learn how to resolve the common "double-hop pass-through authentication" issue that causes the "Login failed for user NT...

SQL Server - An Intelligent Database

Here is a summary of the Intelligent Database webinar along with the session materials available to download...

Contact Us