Eitan Blumin

New #Blog post - Reporting Service Subscription: Failure sending mail: One or more errors occurred #Microsoft #SQLServer #SSRS #SqlHelp #SMTP #MadeiraData

After configuring an Email subscription, the subscription result shows: “Failure sending mail: One or more errors occurred.“. In this blog post I will share how I investigated and resolved one such failure. Continue reading Reporting Service Subscription: Failure sending mail: One or more errors occurred

#Blog post: Resolving and Preventing Deadlocks in #Microsoft #SQLServer #MadeiraData #TSQL #AzureSQL

Deadlocks in SQL Server can be frustrating and can cause significant performance and reliability issues. A deadlock occurs when two or more transactions are waiting for each other to release a lock on a resource, resulting in a situation where no transaction can proceed, and eventually, one of them is automatically killed and rolled back. This can happen when two transactions try to access the…

New #Blog post and #TSQL script: Incremental Integrity Check for Large Databases #Microsoft #SQLServer #MadeiraData

Traditional database integrity checks in SQL Server can be time-consuming and resource-intensive, especially for large databases, even when using super cool tools like Ola Hallengren’s maintenance solution. To address this challenge, I developed a TSQL script for performing incremental integrity checks, which significantly optimizes the process and reduces its impact on the server. Continue…

I'll be delivering one of my newest sessions on the topic of Database #DevOps in this year's #GroupBy #conference on October 29th: #Database DevOps for Leaders! #Webinar #MadeiraData

I know it’s a bit of a short notice, but I’m posting this as soon as this became final and publicly announced. I’ll be delivering one of my newest sessions on the topic of Database DevOps in this year’s GroupBy conference on October 29th: Database DevOps for Leaders Continue reading Catch me live in GroupBy on October 29!

This month's #tsql2sday is hosted by the diligentdba, who asks us how we manage our #database code. Well, as the de-facto #DB #DevOps expert over at #MadeiraData, I felt obliged to participate. There's no way I'll be missing this one ;)

This month’s #tsql2sday is hosted by Malathi, a.k.a Mala, a.k.a diligentdba (b), and asks us about how we manage our database code. Well, as the de-facto DB DevOps expert over at Madeira Data Solutions, I felt obliged to participate and contribute my piece. Continue reading T-SQL Tuesday 177: Managing database code

New #Webinar page is now up: #Database #DevOps for Leaders Already one recording (in Hebrew) is available! #Meetup #MadeiraData

Until recently, database development often lagged behind application development in adopting modern lifecycle techniques. This disparity leads to inefficiencies, errors, and communication issues between teams, and hurts the organization’s time-to-market capabilities in both the short and long term. In this session, the prelude for a multi-part series, we’ll focus on the meaning of DevOps in…

In case you missed my latest #Blog post: #SQLServer #Index Mastery - Choosing the Right Column Order #Optimization #SQLDba #MadeiraData

It’s been a while since my last post about SQL Server performance optimization. This one focuses on index design and how the order of columns in your indexes can make or break your database queries. Using my insights from real-world consulting experience, this guide should help you understand the critical decisions that would impact your database performance. How does SQL Server decide where to…

Take a sit, and let’s have an honest talk about what we all know has been happening this past decade in the world of #DBAs #Microsoft #RDBMS #SQLServer #NoSQL #Hiring #BigData #MadeiraData

Hey there, pull up a chair, and let’s have a real heart-to-heart about what we all know has been happening this past decade in the world of DBAs. Yeah, I know, not exactly what you were looking for in my mostly technical blog, but stick with me here because this talk we’re going to have… Is very, very important. You see, in this past decade or so, we’ve all noticed a trend where more and more…

#AlwaysOn Availability Groups can be tricky when it comes to cluster configurations. Check out this real-life scenario involving DR exercises and quorum failures. #Microsoft #SQLServer #HADR #Blog #MadeiraData

In a recent incident involving AlwaysOn Availability Groups, an interesting lesson was learned about cluster configurations and the delicate balance of democratic votes within them. The scenario occurred during a routine DR exercise, where a client’s entire cluster collapsed unexpectedly, prompting an investigation into the root cause. As it turned out, the issue stemmed from the cluster…

Learn about the benefits of #SQLServer #database #monitoring with our new webinars in partnership with @SolarWinds. Join us for technical showcases and more. #Microsoft #DBA #SqlDBA #SolarWinds #SQLSentry #Webinar #MadeiraData

Thanks to our productive partnership with SolarWinds as part of our Managed Remote DBA Service, we’ve set up two new webinars in our Data Platform Meetup: More Than Downtime: Elevating Your Business with Database MonitoringTUE, JAN 16, 2024, 11:00 AM IST Target audience: C-level executives (including CTOs and CIOs) wanting to learn about the benefits of SQL Server database monitoring, and…

Unfortunately, the Data TLV summit was delayed. But I still have some good news: I'll be speaking at #DataWeekender 6.5 on November 11, and I will be delivering a brand new session! ✨ It's next week! Register now! #Microsoft #SQLServer #MadeiraData

Unfortunately, the Data TLV summit was delayed. But I still have some good news: I’ll be speaking at #DataWeekender 6.5 on November 11, and I will be delivering a brand new session! ✨ Continue reading Untitled

New upcoming #Webinar - #SQLServer Multi-Tenancy in the Real World! See it next week on @DataWeekender 6.5! (November 11) #Microsoft #DataWeekender #SaaS #AzureSQL #MadeiraData

With the advent of cloud technologies, “microservice” design patterns, and SaaS products, how could a “monolith” sort of “legacy” system ever hope to achieve the same level of scalability without breaking the bank and/or starting from scratch? Implementing actual multi-tenant database systems is not an easy task, especially when done on top of an existing on-prem system. Join Eitan Blumin in…

📢I'm #Speaking at the #DataTLV #Summit - the biggest #Data #Community event in #Israel ! Don't miss out! #Event #MadeiraData #SQLServer #DevOps #SSDT #RishonLezion

The Data TLV Summit in Israel is the single most biggest, largest, most amazingest annual summit in Israel for data enthusiasts, made by the community, for the community. The summit is taking place on November 2, 2023, and I will be delivering my most popular session there: Development Lifecycle Basics for DBAs! Continue reading Untitled