Blog | Madeira Data Solutions

Hackorona session materials

Today I had the honor to present a webinar as part of the Hackorona event hosted by in.dev in cooperation with Microsoft. My webinar was...

Mar 26, 20201 min read

דחיסת מידע ב-SQLSERVER יכולה לחסוך שטח ואף לשפר ביצועים. אבל במקרים מסוימים זה יכול לגרום יותר נזק מתועלת, וחשוב לזהות מקרים אלה.

Mar 16, 20203 min read

Sometimes I see SQL Server instances with hundreds or even thousands of databases. This is usually a consolidated environment or a...

Mar 16, 20202 min read

Sometimes you need to compare data between two tables with many rows and columns. There are several ways to achieve this. Here is one...

Nov 28, 20196 min read

Sometimes I see SQL Server instances with hundreds or even thousands of databases. This is usually a consolidated environment or a...

Nov 4, 20182 min read

One of the scariest moments for a DBA is to see a database in the "Suspect" mode or in the "Recovery Pending" mode... First, let's...

Jul 29, 20187 min read

In many cases, while we using DBCC commands, we must to run two statements instead of one, in order to receive the wishful result. For...

Mar 9, 20181 min read

I just had an interesting case of performance tuning: a query with multiple predicates on a very large table. Something like this: SELECT...

Mar 9, 20182 min read

One day, your Availability Group cluster can get into a critical state in a way that forces your team to create the Availability Group...

Mar 9, 20181 min read

We have many customers, and we work on lots of projects. Each project is different in so many ways: the business environment, the system...

Mar 8, 20181 min read