Blog | Madeira Data Solutions

Should You Split Queries?

The SplitQuery feature in EF is a terrible feature in most cases. Developers should avoid using it.

A Useful Script to Delete Data from Multiple Tables

Sometimes you need to delete data from multiple tables with foreign keys. Here is a useful script that can save you a lot of time...

Use Filtered Statistics to Improve Performance on Very Large Tables

Let’s say you have a very large table on SQL Server 2012 Standard Edition. Most of the time you get poor performance. What can you do?

The Performance Tuning Magic Show @ DPS2022

I'm excited about delivering a pre-con session in Data Platform Virtual Summit 2022 - The Performance Tuning Magic Show

Can I Pause and Resume an Index Rebuild Operation?

One of the cool features introduced in SQL Server 2017 is the option to pause and resume an online index rebuild operation...

Extract, Transform...and, send an e-mail!

Author: Eric Rouach, DBA at Madeira Data Solutions Date: July 2022 If you need to extract data from a SQL Server/Azure SQL database,...

How to Identify and Fix Tempdb Contention

Here is all you need to know about the two types of contention in tempdb...

Do You Have a Proper Backup Strategy?

Research shows that we are more likely to lose our database in the coming year - don't let that happen to you!

Truth is multidimensional and depends on the perspective you view from

Just as your Power BI table visualizations. I often want to build a dashboard with sleek elegant visualizations and at the same time show...

If you want to torture data - store it in CSV format

Are you using CSV files as a primary file format for your data? CSV is a very useful file format if you want to open the file in Excel...

Contact Us