Blog | Madeira Data Solutions

Overriding the Authentication in SSRS for External Access

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

This month's #tsql2sday is hosted by @AirborneGeek who asks us to learn from others' mistakes. That's almost my job description! Read on...

Jul 14, 20205 min read

Let's examine SQL Server security from a hacker's point of view of, the common methodologies used, and offer recommendations to tackle each.

Jun 15, 20207 min read

learn how Ola Hallengren’s implementation behaves with Always On and Backup Preference. the different scenarios and how to configure it.

Jun 4, 20203 min read

Today I presented a session as part of our monthly live webinars. Here is a recap...

Jun 2, 20201 min read