top of page
SQL Server Registered Servers
Developers, DBAs, QAs, or even accidental DBAs everyone of us works with SSMS (SQL Server Management Studio). We tend to spend a huge...
Vitaly Bruk
May 31, 20203 min read
OLA? WHO THE F**K IS OLA?
Recently, our team developed a new feature as an extension to Ola's maintenance solution for managing database file size growth and shrink.
Madeira Team
May 31, 20201 min read
SQL Server Setup Best Practices
On May 12, 2020, I had the honor to participate and speak in the GroupBy conference. I talked about SQL Server Setup Best Practices.
Guy Glantser
May 27, 20201 min read
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...
noa9484
May 26, 20203 min read
Troubleshooting tempdb Space Usage
When the tempdb database is growing too large, you need the tools to troubleshoot and locate the offending sessions or transactions.
Guy Glantser
May 13, 20206 min read
sp_Blitz – Free SQL Server Health Check Script from Brent Ozar
webinar recording - sp_Blitz – Free SQL Server Health Check Script from Brent Ozar
Madeira Team
May 12, 20201 min read
T-SQL Tuesday 126 - Responding to COVID-19
Madeira Data Solutions did quite a lot to chip in during these difficult times. Hopefully, it’s enough to make some kind of difference.
Eitan Blumin
May 12, 20202 min read
How To establish mirroring session following domain name change
Have you ever needed to change the database mirroring partner names? One of our clients had to transfer all their servers from one domain...
Reut Almog Talmi
May 11, 20203 min read
It’s Time to Get Rid of Those Redundant Indexes
In most databases, there are redundant indexes, which only have costs, but no benefits. Here is a useful script to find them...
Guy Glantser
May 7, 20203 min read
bottom of page