SQL Server is no exception. However, it often leads to three common phenomena – locks, blocks, and deadlocks. SQL Diagnostic Manager SQL Server
Webinar – Mastering SQL Query Performance: A Deep Dive into Index Tuning and Analysis
The webinar topic is Mastering SQL Query Performance: A Deep Dive into Index Tuning and Analysis. I will be hosting this webinar.
Reflections on Fireside Chat about Future of MySQL
I had the honor of participating in the Fireside Chat organized by Idera, where the discussion revolved around many different topics.
Challenges and Opportunities for DBAs in the Next 5-10 Years: How to Prepare
DBA challenges and opportunities call for skills we can practice now. I focus on recovery, performance and judgment as tools change.
Common Mistakes to Avoid for DBAs Working with MySQL Databases
“What are some common mistakes you see DBAs make when working with MySQL databases, and how can they be avoided?”
Adapting to the Evolving Role of the DBA with SQL DM
The evolving role of the DBA includes proactive monitoring. See how SQL DM can highlight risk, help prioritize issues and support the team.
Long Running Queries in MySQL: Find Them in Two Ways
Find long running queries in MySQL with two built-in methods: the slow query log and the Performance Schema digest table. See the settings, a ready query and how to choose between them.