Blog | Madeira Data Solutions

sp_execute_external_script permission denied - What a b*tch!

A few weeks ago, a customer contacted me with an interesting problem. They recently upgraded the SQL Server from 2017 to 2019 and started...

May 26, 20203 min read

webinar materials tempdb

May 24, 20201 min read

When the tempdb database is growing too large, you need the tools to troubleshoot and locate the offending sessions or transactions.

May 13, 20206 min read

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 11, 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 4, 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