Blog | Madeira Data Solutions

Exporting CRM 365 data to Synapse

Use azure Synapse Link for Dataverse to export data to Azure synapse analytics.

My Session in SQL Day 2022

Here are all the session materials (slide deck and scripts) from my session in SQL Day 2022 about temporary tables and table variables...

How to export a database from Azure Managed Instance to your local SQL Server instance

1) EXPORT a database from an Azure Managed Instance by creating a .bacpac file using SqlPackage.exe: SqlPackage.exe /Action:Export...

T-SQL Tuesday #150 – My First Technical Job

This blog post is part of TSQL Tuesday. This month the host is Kenneth Fisher, and the topic is "Your First Technical Job".

The Best Solution for SQL Server Partitioning Sliding Window

Turns out there's a shortage of solutions online for easily managing partitioned tables in SQL Server. Well... That's where I come in!

Send e-mails from Azure Data Factory with Azure Logic App

(Part 3/3 of “Getting started with Azure Data Factory”) Author: Eric Rouach, DBA at Madeira Data Solutions Date: April 2022 In this demo,...

Which Tables are Referenced by a View?

I published a very simple script to query for all the objects referenced by a specific object in the local database (e.g. a view)...

Modernizing Your SQL Server

So you have an old SQL Server. It's time to make a change, but where do you start?

Monitoring Heartbeats in SQL Sentry

SQL Sentry uses a service to monitor targets. But what if this monitoring service is down? Who will alert about the alerter not alerting?

How to Configure Auto-Scaling in Azure Data Explorer

You can configure auto-scaling in two ways. The first is called Optimized Auto-Scale, and the second is called Custom Auto-Scale...

Contact Us