After watching my free webinar the most popular question, which I receive is about Database Compatibility Level.
SQL SERVER – 5 Tips to Optimize SQL Server Application Performance
I recently talked with Mark Wright, CTO of Nitrosphere, a company that optimizes SQL Server application performance. Let us talk about it.
SQL SERVER – 10 Questions Where YES May Be a Wrong Answer – Performance Health Check
Ten yes or no questions about your SQL Server. If you answer yes to any of them, your server can run faster. Take this quick Performance Health Check quiz.
SQL Server Performance Tuning Practical Workshop – Notes and Thoughts
In January I delivered 36 sessions of my SQL Server Performance Tuning Practical Workshop for newsletter subscribers. Here are my notes and thoughts.
Find All Queries with Implicit Conversion in SQL Server – Interview Question of the Week #107
Question: How do I find out how many queries have an Implicit Conversion in SQL Server? The source of this question is very interesting.
GroupBy Conference – 3 Common Mistakes to Kill SQL Server Performance
At the first GroupBy Conference, organized by Brent Ozar, I presented a one hour session on 3 Common Mistakes to Kill SQL Server Performance.
SQL SERVER – Testing Database Performance with tSQLt and SQLQueryStress
Database testing is often skipped until there is a problem. Here is my approach to testing database performance with tSQLt and SQLQueryStress.