A great business analysts are never saturated with data, they need more and more. Data analysis frequently calls for data enrichment, to...

Author: Eric Rouach, Madeira Data Solutions Date: March 2022 The following guide describes how to execute and schedule any T-SQL command...

If you are using an old version of SQL Server, then you have some good reasons to upgrade. Here are five of them...

Part 2: Create your first ADF pipeline Author: Eric Rouach, DBA at Madeira Data Solutions Date: 2022-02 Description: The following will...

Filtered Indexes are pretty great, honestly. If, of course, you can actually create them and use them in your environment. But, what if not?

Part 1: Setup Your Environment Author: Eric Rouach, DBA at Madeira Data Solutions Date: 2022-02 Description: The following will guide you...

Here are the results of our last Customer Satisfaction Survey...

This series of articles will cover the first steps you should take when entering a new environment, aiming to improve overall...

Sometimes we need to troubleshoot memory pressure issues in SQL Server or in Azure SQL. Here is a useful script...

Azure SQL databases don't behave like on-premise SQL Server databases and unfortunately, we can't use the handy (and undocumented)...