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.
Read More »Reporting Service Subscription: Failure sending mail: One or more errors occurred
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 same data in a different order or when one transaction holds a lock on a resource while waiting for a lock held by another transaction. In this blog post, we’ll discuss how to troubleshoot and prevent deadlocks in SQL Server.
Read More »Resolving and Preventing Deadlocks in SQL Server
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.
Read More »Incremental Integrity Check for Large Databases
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
Read More »Catch me live in GroupBy on October 29!
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 obligated (and obliged) to participate and contribute my piece.
Read More »T-SQL Tuesday 177: Managing database code
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 look first when executing a query? The answer lies in the structure of your indexes. Learn how the sequence of key columns can optimize your data retrieval, making your database faster and more responsive.
Read More »SQL Server Index Mastery: Choosing the Right Column Order
AlwaysOn Availability Groups can be tricky when it comes to cluster configurations. Learn from a real-life scenario involving DR exercises and quorum failures.
Unfortunately, the Data TLV summit was delayed. But I still have some good news: I’ll be speaking at #DataWeekender 6.5 on November 4, and I will be delivering a brand new session! ✨
Read More »I’m Speaking at DataWeekender 6.5!
[EDIT] Due to the current ongoing situation between Israel and Palestine, the event was delayed to February 2024. For more details, please refer to the official Data TLV Summit website.
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!
Read More »I’m speaking at the Data.TLV Summit 2023 in Israel
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 some insightful research into some of the validations done by SQL Server behind the scenes when executing an ALTER TABLE SWITCH command.
Read More »Understanding ‘ALTER TABLE SWITCH statement failed’ errors 4907, 4908, and 4912