Blog | Madeira Data Solutions

SELECT TOP (3) Pre-Conference Sessions

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

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 7, 20201 min read

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