Explains why SQL Server backup strategies must focus on recovery readiness, not just successful backups.
A reference check for IT professional Richie Rump, highlighting his skills in data architecture, problem-solving, and reliability.
A fun SQL Server quiz called 'Well, Actually…' to test database knowledge, built as a free WordPress plugin.
![[Video] Office Hours: Long Answers Edition](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/thumbs/article-a9f3e37652de-full-5d20e9da.webp)
Brent Ozar answers database questions on HADR_SYNC_COMMIT waits, indexing strategies, RCSI, and SQL Server comparisons.
Explains SQL Server blocking chains, head blockers, and why transaction duration matters more than the session itself for diagnosing performance issues.
Learn how to use the azqr sql-esu plugin to identify SQL Server end-of-life instances and estimate Extended Security Update costs.
Explains database page splits with animations, their impact on writes and disk order, and historical context with hard drives.
T-SQL Tuesday roundup on warning signs of bad SQL queries, including WHILE loops, cursors, functions, and DISTINCT.
A technical post about removing the In-Memory OLTP (Hekaton) filegroup in SQL Server 2025, marking the end of the feature's journey.
An animated explanation of how SQL Server index seeks work, covering B-tree root pages, intermediate pages, and leaf pages.
Explains why high SQL Server CPU usage is a symptom, not a root cause, and how to diagnose the real issue before adding hardware.
Slides from a DataSaturday session on building a €100 data warehouse using Azure data platform.
A personal recap of Data Saturday Rheinland 2026, covering PostgreSQL, SQL Server, GenAI, and data literacy sessions.
Explains why SQL Server wait statistics indicate direction, not root cause, and warns against using them as a diagnosis.
SQL Server diagnostic queries for July 2026, covering configuration, performance, and T-SQL scripts for various versions.
Introduces Polecat, a .NET library that turns SQL Server 2025 into a document database, leveraging its native JSON support for improved developer productivity.
Analysis of SQL Server security issues, vulnerability disclosure challenges, and Microsoft's documentation gaps.
T-SQL Tuesday #199 explores moving data platforms back to on-premises, highlighting lost troubleshooting skills and infrastructure challenges.
SQL Server diagnostic queries for performance and configuration analysis, covering versions from 2005 to 2025 and Azure.
How AI assists SQL Server consulting without replacing expert judgment, focusing on analysis and communication.
