Blog | Madeira Data Solutions

sp_Blitz – Free SQL Server Health Check Script from Brent Ozar

webinar recording - sp_Blitz – Free SQL Server Health Check Script from Brent Ozar

May 12, 20201 min read

Madeira Data Solutions did quite a lot to chip in during these difficult times. Hopefully, it’s enough to make some kind of difference.

May 12, 20202 min read

Have you ever needed to change the database mirroring partner names? One of our clients had to transfer all their servers from one domain...

May 10, 20203 min read

In most databases, there are redundant indexes, which only have costs, but no benefits. Here is a useful script to find them...

May 7, 20203 min read

Here are my top 3 pre-conference sessions in PASS Summit 2020

May 6, 20204 min read

Disaster recovery is one of the critical things and every IT or technology system faced with. Unfortunately, many times even our own work...

May 3, 20202 min read

Availability Groups is a wonderful feature in SQL Server that provides HA/DR solutions. But what if I use Standard Edition? What do I get?

May 1, 20202 min read

In our last webinar, I presented how SQL Server works with Parallelism, what are the default values and what they affect.

Apr 30, 20201 min read

Sometimes an extra level of control is necessary for managing big environments’ resources. Resource Governor is here just for that, giving

Apr 16, 20201 min read

Today's webinar was about two very important SQL Server (and Azure SQL Database) developer tips: How to use scalar user-defined functions a

Apr 6, 20201 min read