Eitan Blumin

Microsoft Data Platform Professional and Senior SQL Server Consultant

[eitanblumin]

We live in an exceptional political landscape, and therefore I find myself writing an exceptional blog post of a kind I would normally not write here. But the reality is forced upon us, and I must speak out.

When Nothing Is True - Everything Is Permitted

[eitanblumin]

New #Blog post: Error 845 Time-out occurred while waiting for buffer latch type 4 during DBCC CHECK #SQLServer #DataCorruption #Microsoft #Database #MadeiraData

Error 845 Time-out occurred while waiting for buffer latch type 4 during DBCC CHECK

[eitanblumin]

New #Blog post: Hidden risks in #Microsoft #SQLServer Agent job logging: How retry settings can compromise your logs - the problem you didn't know you had! ⚠

Hidden Risks in SQL Agent Job Logging: How Retry Settings Can Compromise Your Logs

[eitanblumin]

I'm speaking at the #DataTLV Summit of 2025. My session will be: #Database #DevOps for Leaders Register quickly for a discount!

Going back to DataTLV in 2025

[eitanblumin]

Reporting Service Subscription: Failure sending mail: One or more errors occurred

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

Reporting Service Subscription: Failure sending mail: One or more errors occurred

[eitanblumin]

Resolving and Preventing Deadlocks in SQL Server

#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…

Resolving and Preventing Deadlocks in SQL Server

[eitanblumin]

Incremental Integrity Check for Large Databases

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…

Incremental Integrity Check for Large Databases

[eitanblumin]

Catch me live in GroupBy on October 29!

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!

Catch me live in GroupBy on October 29!

[eitanblumin]

T-SQL Tuesday 177: Managing database code

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

T-SQL Tuesday 177: Managing database code

[eitanblumin]

CI and CD with SSDT Part 0 - Database DevOps for Leaders

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…

View On WordPress

[eitanblumin]

SQL Server Index Mastery: Choosing the Right Column Order

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…

View On WordPress

[eitanblumin]

We need to talk about the elephant in the room - the future of DBAs

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…

View On WordPress

[eitanblumin]

Forced Quorum Mode and The Value of Democracy

#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…

View On WordPress

[eitanblumin]

Upcoming Webinars About SQL Server Monitoring

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…

View On WordPress

[eitanblumin]

I'm Speaking at DataWeekender 6.5!

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

View On WordPress

[eitanblumin]

SQL Server Multi-Tenancy in the Real World

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…

View On WordPress

[eitanblumin]

I'm speaking at the Data.TLV Summit 2023 in Israel

📢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

View On WordPress