Blog | Madeira Data Solutions

Concatenating Strings in SQL Server

What happens in SQL Server when you concatenate strings? You might be surprised...

Nov 10, 20204 min read

The purpose of unit testing in software development is to validate that each unit of the software performs as designed. It is usually...

Nov 10, 20201 min read

Last week I presented a session as part of the GroupBy event about Working with Very Large Tables Like a Pro in SQL Server 2019.

Nov 3, 20201 min read

Data compression can save storage space and improve performance. But in some cases, it may cause more harm than good. Read to learn more.

Oct 28, 20202 min read

If you made this one dangerous configuration mistake, you may have created a wide open backdoor into your database servers.

Oct 13, 20201 min read

Eitan provides a practical guide to troubleshoot high THREADPOOL waits and Deadlocked Schedulers in production environments.

Oct 11, 20201 min read

Here is a useful script to identify the head blockers that make your SQL Server stuck...

Oct 6, 20202 min read

PASS is working hard to bring all of us the best experience ever in PASS Virtual Summit 2020. Let me take you through a guided tour...

Sep 15, 20204 min read

The latest cumulative update (22) for SQL Server 2017 has just been released. It includes many fixes to bugs and known issues. I counted 40.

Sep 13, 20201 min read

The default behavior of SQL Server when it comes to the management of the error log is not optimal. Here are some best practices...

Sep 13, 20204 min read