Demystifying CXPACKET and CXCONSUMER wait types in SQL Server
CXPACKET and CXCONSUMER wait types in SQL Server are common occurrences when managing database performance. Learn Brent Ozar’s advice on how to fix them.
Avoiding SQL deadlocks with query tuning: Advice from Brent Ozar
Learn how to avoid SQL deadlocks through query tuning, courtesy of Microsoft Certified Master Brent Ozar.
Database management career tips from Brent Ozar and Pinal Dave
Who better to provide database management career tips then SQL Server experts Brent Ozar and Pinal Dave? Hear their candid advice.
SQL Server performance advice from Brent Ozar and Pinal Dave
Learn SQL Server performance advice from SQL Server experts Brent Ozar and Pinal Dave.
Oracle performance tuning: A 5-step approach to optimized performance
Janis demonstrated this five-step Oracle performance tuning process using two case studies based on actual queries and data sets
An insider’s view on Automatic Indexing in Oracle 19c
Learn why automatic indexing in Oracle 19c is like having a performance tuning expert in-a-box.
Brent Ozar explains SQL Server internal and external fragmentation
Read Brent Ozar's hard-earned wisdom on SQL Server internal and external fragmentation.
SQL Server tuning – it’s all about measurement
Brent Ozar reminded us that database performance is all about measurement in his training session on “How to Measure SQL Server,”