Blog | Madeira Data Solutions

I am Speaking at Data Platform Summit 2020

am excited to be one of the speakers in Data Platform Summit 2020!

Sep 9, 20201 min read

Find the ad-hoc queries that waste the most resources in your server...

Sep 9, 20202 min read

It is often useful to query the list of all indexes in a database. Here is a script just for that...

Sep 2, 20202 min read

I had the honor and pleasure to present a session as part of SQL Friday about the most important performance factor in SQL Server.

Aug 31, 20201 min read

In this post, Eitan summarizes the various methods that we have in order to get rid of that annoying authentication prompt in SSRS.

Aug 13, 20208 min read

Webinar about parameters, a fundamental part of T-SQL programming. how to use it to boost server performance

Aug 8, 20202 min read

Thank you Microsoft for presenting me with the MVP award for the sixth year

Jul 31, 20202 min read

First of all, let's see, what is 'optimize for ad hoc workloads' in SQL Server? In simple words, the term 'ad hoc' means 'as needed' or a...

Jul 30, 20202 min read

If you work with Trello, then you will probably agree with me that it is a very powerful tool. In Madeira Data Solutions, we work a lot...

Jul 22, 20203 min read

How to make scheduled jobs run on the Primary server while having couple of SQL Servers with a High Availability solution between them

Jul 15, 20201 min read