Eitan Blumin's blog https://eitanblumin.com/ Data Platform MVP and SQL Server Expert Thu, 19 Feb 2026 10:52:31 +0000 en-US hourly 1 https://i0.wp.com/eitanblumin.com/wp-content/uploads/2018/11/cropped-cropped-me3_crop-e1541454765759.jpg?fit=32%2C32&ssl=1 Eitan Blumin's blog https://eitanblumin.com/ 32 32 209288398 When Nothing Is True – Everything Is Permitted https://eitanblumin.com/2026/02/19/when-nothing-is-true-everything-is-permitted/ https://eitanblumin.com/2026/02/19/when-nothing-is-true-everything-is-permitted/?noamp=mobile#respond Thu, 19 Feb 2026 10:52:29 +0000 https://eitanblumin.com/?p=52486 There is a growing anxiety in the digital age that goes beyond partisanship, beyond specific leaders, beyond even artificial intelligence… Read More »When Nothing Is True – Everything Is Permitted

The post When Nothing Is True – Everything Is Permitted appeared first on Eitan Blumin's blog.

]]>
https://eitanblumin.com/2026/02/19/when-nothing-is-true-everything-is-permitted/feed/ 0 52486
Error 845 Time-out occurred while waiting for buffer latch type 4 during DBCC CHECK https://eitanblumin.com/2025/09/01/error-845-time-out-occurred-while-waiting-for-buffer-latch-type-4-during-dbcc-check/ https://eitanblumin.com/2025/09/01/error-845-time-out-occurred-while-waiting-for-buffer-latch-type-4-during-dbcc-check/?noamp=mobile#comments Mon, 01 Sep 2025 12:45:00 +0000 https://eitanblumin.com/?p=50834 How could different unrelated tables fail with a latch timeout on the exact same page?

And aren't latches supposed to be, like, super-quick?

The post Error 845 Time-out occurred while waiting for buffer latch type 4 during DBCC CHECK appeared first on Eitan Blumin's blog.

]]>
https://eitanblumin.com/2025/09/01/error-845-time-out-occurred-while-waiting-for-buffer-latch-type-4-during-dbcc-check/feed/ 2 50834
Hidden Risks in SQL Agent Job Logging: How Retry and Output Settings Can Compromise Your Logs https://eitanblumin.com/2025/07/01/hidden-risks-in-sql-agent-job-logging-how-retry-settings-can-compromise-your-logs/ https://eitanblumin.com/2025/07/01/hidden-risks-in-sql-agent-job-logging-how-retry-settings-can-compromise-your-logs/?noamp=mobile#respond Tue, 01 Jul 2025 12:25:00 +0000 https://eitanblumin.com/?p=41441 In many SQL Server environments, DBAs configure SQL Agent jobs with retry attempts (which is a smart move to handle… Read More »Hidden Risks in SQL Agent Job Logging: How Retry and Output Settings Can Compromise Your Logs

The post Hidden Risks in SQL Agent Job Logging: How Retry and Output Settings Can Compromise Your Logs appeared first on Eitan Blumin's blog.

]]>
https://eitanblumin.com/2025/07/01/hidden-risks-in-sql-agent-job-logging-how-retry-settings-can-compromise-your-logs/feed/ 0 41441
Going back to DataTLV in 2025 https://eitanblumin.com/2025/03/06/going-back-to-datatlv-in-2025/ https://eitanblumin.com/2025/03/06/going-back-to-datatlv-in-2025/?noamp=mobile#respond Thu, 06 Mar 2025 15:14:57 +0000 https://eitanblumin.com/?p=5004 Previously known as the SQL Saturday branch in Israel, Data TLV is an annual in-person conference for Data professionals and… Read More »Going back to DataTLV in 2025

The post Going back to DataTLV in 2025 appeared first on Eitan Blumin's blog.

]]>
https://eitanblumin.com/2025/03/06/going-back-to-datatlv-in-2025/feed/ 0 5004
Reporting Service Subscription: Failure sending mail: One or more errors occurred https://eitanblumin.com/2025/01/06/reporting-service-subscription-failure-sending-mail-one-or-more-errors-occurred/ https://eitanblumin.com/2025/01/06/reporting-service-subscription-failure-sending-mail-one-or-more-errors-occurred/?noamp=mobile#respond Mon, 06 Jan 2025 15:03:46 +0000 https://eitanblumin.com/?p=4877 After configuring an Email subscription, the subscription result shows: “Failure sending mail: One or more errors occurred.“. In this blog… Read More »Reporting Service Subscription: Failure sending mail: One or more errors occurred

The post Reporting Service Subscription: Failure sending mail: One or more errors occurred appeared first on Eitan Blumin's blog.

]]>
https://eitanblumin.com/2025/01/06/reporting-service-subscription-failure-sending-mail-one-or-more-errors-occurred/feed/ 0 4877
Resolving and Preventing Deadlocks in SQL Server https://eitanblumin.com/2024/12/12/resolving-and-preventing-deadlocks-in-sql-server/ https://eitanblumin.com/2024/12/12/resolving-and-preventing-deadlocks-in-sql-server/?noamp=mobile#respond Thu, 12 Dec 2024 10:00:00 +0000 https://eitanblumin.com/?p=4828 Deadlocks in SQL Server can be frustrating and can cause significant performance and reliability issues. A deadlock occurs when two… Read More »Resolving and Preventing Deadlocks in SQL Server

The post Resolving and Preventing Deadlocks in SQL Server appeared first on Eitan Blumin's blog.

]]>
https://eitanblumin.com/2024/12/12/resolving-and-preventing-deadlocks-in-sql-server/feed/ 0 4828
Incremental Integrity Check for Large Databases https://eitanblumin.com/2024/10/28/incremental-integrity-check-for-large-databases/ https://eitanblumin.com/2024/10/28/incremental-integrity-check-for-large-databases/?noamp=mobile#comments Mon, 28 Oct 2024 13:00:00 +0000 https://eitanblumin.com/?p=4750 Traditional database integrity checks in SQL Server can be time-consuming and resource-intensive, especially for large databases, even when using super… Read More »Incremental Integrity Check for Large Databases

The post Incremental Integrity Check for Large Databases appeared first on Eitan Blumin's blog.

]]>
https://eitanblumin.com/2024/10/28/incremental-integrity-check-for-large-databases/feed/ 5 4750
Catch me live in GroupBy on October 29! https://eitanblumin.com/2024/10/11/catch-me-live-in-groupby-on-october-29/ https://eitanblumin.com/2024/10/11/catch-me-live-in-groupby-on-october-29/?noamp=mobile#respond Fri, 11 Oct 2024 18:30:03 +0000 https://eitanblumin.com/?p=4727 I know it’s a bit of a short notice, but I’m posting this as soon as this became final and… Read More »Catch me live in GroupBy on October 29!

The post Catch me live in GroupBy on October 29! appeared first on Eitan Blumin's blog.

]]>
https://eitanblumin.com/2024/10/11/catch-me-live-in-groupby-on-october-29/feed/ 0 4727
T-SQL Tuesday 177: Managing database code https://eitanblumin.com/2024/08/13/t-sql-tuesday-177-managing-database-code/ https://eitanblumin.com/2024/08/13/t-sql-tuesday-177-managing-database-code/?noamp=mobile#comments Tue, 13 Aug 2024 18:26:52 +0000 https://eitanblumin.com/?p=4685 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… Read More »T-SQL Tuesday 177: Managing database code

The post T-SQL Tuesday 177: Managing database code appeared first on Eitan Blumin's blog.

]]>
https://eitanblumin.com/2024/08/13/t-sql-tuesday-177-managing-database-code/feed/ 2 4685
SQL Server Index Mastery: Choosing the Right Column Order https://eitanblumin.com/2024/05/13/sql-server-index-mastery-choosing-the-right-column-order/ https://eitanblumin.com/2024/05/13/sql-server-index-mastery-choosing-the-right-column-order/?noamp=mobile#respond Mon, 13 May 2024 13:00:00 +0000 https://eitanblumin.com/?p=4095 Learn how the order of columns in your SQL Server indexes can affect your database queries. This guide offers real-world insights for optimization.

The post SQL Server Index Mastery: Choosing the Right Column Order appeared first on Eitan Blumin's blog.

]]>
https://eitanblumin.com/2024/05/13/sql-server-index-mastery-choosing-the-right-column-order/feed/ 0 4095