Skip to content

Solving the Latch Convoy Problem with OPTIMIZE_FOR_SEQUENTIAL_KEY in SQL Server 2019

Have you ever come across an elusive SQL Server issue known as the “Latch Convoy Problem” or “Last Page Insert Contention”? It’s a rare and challenging problem to encounter in real-world scenarios. In fact, it’s so uncommon that many database professionals may go their entire careers without experiencing it firsthand. But sometimes, the unexpected happens, and you find yourself face to face with this elusive beast.

The Top 15 SQL Server Security Myths

As a SQL Server DBA, you are responsible for securing your organization’s critical data stored in SQL Server. However, there are many myths surrounding SQL Server security 🔒 that can lead to a false sense of security or even leave you vulnerable to attacks. In this blog post, I’ll be debunking the 15 most common security-related myths in SQL Server that every DBA should be aware of. So, grab a cup of coffee, and let’s get started! ☕

Read More »The Top 15 SQL Server Security Myths

This is a Call-to-Arms Against AI-Generated Content

As a productivity geek, I am very excited about the recent advancements in AI as a content-generating tool.

In fact, I have already started using ChatGPT as a writing assistant for my blog.

However, I am very careful with the content produced by it, as the currently available AI models are not trustworthy enough to produce 100% accurate content. As an expert in my field, it’s easy for me to curate and validate the content generated for me by AI, because I have the knowledge and expertise to do so. So, you can rest easy knowing that I’ll continue producing high-quality content 😉.

But what about people who don’t have a high level of expertise in the field in which they’re using AI for content generation? Even worse, what if they don’t care? What would happen when every shmoe gets access to AI and uses it to try and earn an easy buck by content generation? What happens when there’s an oversaturation of content generated by AI?

Read More »This is a Call-to-Arms Against AI-Generated Content

From Good to Great: Boosting Your Performance as a DBA with the SPIN Sales Strategy

Introduction

As a DBA, your job involves much more than just managing databases. You must also work with customers to understand their needs and provide solutions that meet their requirements. In this blog post, we will discuss how you can implement the SPIN sales strategy concepts as part of your job.

Read More »From Good to Great: Boosting Your Performance as a DBA with the SPIN Sales Strategy

Drop All Redundant Indexes In Every Database All At Once

Redundant indexes in SQL Server are a phenomenon that is more common than I’d like to admit. I see it in quite a lot of shops. Meaning, that there’s still a significant target audience for this blog post!

This article published by Brent Ozar is very informative about redundant/duplicate indexes, what they mean, why they’re bad, and what should be done with them.

Also, a few years ago, Guy Glantser published a post about dropping redundant indexes. It’s very useful for finding all redundant indexes within all tables in a specific database.

But what both of these articles are missing – is the ability to easily generate Drop/Disable commands for these redundant indexes.

Read More »Drop All Redundant Indexes In Every Database All At Once