Blog | Madeira Data Solutions

Something new, that I have learned today: Optimize for ad hoc workloads

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

Developers, DBAs, QAs, or even accidental DBAs everyone of us works with SSMS (SQL Server Management Studio). We tend to spend a huge...

May 31, 20203 min read

Recently, our team developed a new feature as an extension to Ola's maintenance solution for managing database file size growth and shrink.

May 31, 20201 min read

On May 12, 2020, I had the honor to participate and speak in the GroupBy conference. I talked about SQL Server Setup Best Practices.

May 27, 20201 min read