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 post Solving the Latch Convoy Problem with OPTIMIZE_FOR_SEQUENTIAL_KEY in SQL Server 2019 appeared first on Eitan Blumin's blog ..read more

Do you find yourself facing performance problems and long lock chains caused by very frequent INSERT, UPDATE, or DELETE statements being executed on a table? Check out this neat trick that could help you out and make all the difference in the world. The post The Asynchronous Ledger Trick for Fast SQL Server Insert, Update and Delete Processes appeared first on Eitan Blumin's blog ..read more

Today I’ll talk about the main physical JOIN operator types in SQL Server (Nested Loops, Hash and Merge Joins), their differences, best practices and complexity. The post The LOOP, HASH and MERGE Join Types appeared first on Eitan Blumin's blog ..read more

Despite being one of the oldest database attack methods, SQL Injection still persists for decades at the OWASP Top Ten list of critical security risks to web applications. In fact, instead of dying out, it only seems to be getting more clever and even automated. With "hacker bots" scouring the web and automatically probing for injection vulnerabilities to exploit. But today I'm not actually going to talk about that. Today, I'm going to ask the question: When is SQL Injection dangerous, even if it's perfectly safe? The post Could SQL Injection be dangerous even when perfectly safe? appeared fir ..read more

Thanks to Paul Randal and his recently published blog post: “The Curious Case of… tracking page compression success rates“, I… Read More »Detect Low PAGE Compression Success Rates in all Databases The post Detect Low PAGE Compression Success Rates in all Databases appeared first on Eitan Blumin's blog ..read more

Every once in a while there comes an opportunity to “upgrade” your abilities with newly acquired knowledge that lets you… Read More »Performance Tuning Like a Pro – with Hypothetical Indexes The post Performance Tuning Like a Pro – with Hypothetical Indexes appeared first on Eitan Blumin's blog ..read more

On November 19th, 2020, I delivered a short session about Azure SQL Analytics, as part of the MVP Days Israel… Read More »Webinar: Performance Monitoring with Azure SQL Analytics The post Webinar: Performance Monitoring with Azure SQL Analytics appeared first on Eitan Blumin's blog ..read more

In this blog post I'll help you troubleshoot the rare but critical issues of Deadlocked Schedulers and high THREADPOOL waits. The post How to Troubleshoot THREADPOOL Waits and Deadlocked Schedulers appeared first on Eitan Blumin's blog ..read more

This month's #tsql2sday is hosted by the @AirborneGeek who asks us to learn from others' mistakes. Hey, that's my job description! Read on for more juicy details. The post T-SQL Tuesday #128 – Learn from Others appeared first on Eitan Blumin's blog ..read more

Can Azure SQL Analytics be a decent competitor to powerhouses such as SentryOne, RedGate, ApexSQL, Solarwinds and others? Let's find out! The post Is Azure SQL Analytics all you need for SQL Server Monitoring? appeared first on Eitan Blumin's blog ..read more