Blog | Madeira Data Solutions

How to Leverage Parallelism in SQL Server?

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

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