eitanblumin

[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! ⚠

[eitanblumin]

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

[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

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

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

[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!

[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

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

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

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

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

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

[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

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

[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

[eitanblumin]

Understanding 'ALTER TABLE SWITCH statement failed' errors 4907, 4908, and 4912

Learn about SQL Server's ALTER TABLE SWITCH statement and how to troubleshoot errors 4907, 4908, and 4912 in my latest #blog post #Microsoft #SQLServer #MadeiraData

Recently we’ve encountered an interesting use case for a customer. They had a table with partitioning that they needed to be archived (with the help of said partitioning), but the ALTER TABLE SWITCH commands were failing with a peculiar error: Error 4907, ‘ALTER TABLE SWITCH’ statement failed. The table ‘MyDB.dbo.PrtTable1’ has 4 partitions while index ‘IX1’ has 6 partitions. This prompted…

[eitanblumin]

Solving the Latch Convoy Problem with OPTIMIZE_FOR_SEQUENTIAL_KEY in SQL Server 2019

Learn about the elusive "Latch Convoy Problem" in #SQLServer and how #Microsoft's OPTIMIZE_FOR_SEQUENTIAL_KEY index option can help resolve it 💡. #MadeiraData

The latch convoy problem arises when there is contention for a specific data page, particularly the last page at the end of an index. This contention can result in high waits and reduced performance for insert operations. Microsoft introduced the OPTIMIZE_FOR_SEQUENTIAL_KEY index option in SQL Server 2019 as a solution for this problem. Recently, I finally encountered and successfully resolved…