We are sorry, the event "Customer Appreciation Lunch at Cooper's Hawk" has already expired.
To gain insight into the evolving trends and challenges for database professionals in 2020, Quest commissioned Unisphere Research to survey PASS members – the database professionals responsible for the management of the corporate data management infrastructure. The results are in and the thoug
Solve performance issues faster with deep SQL workload visibility and lock analytics
Frustrated with query tuning? Learn an Oracle ACE Director’s tips to quickly find and fix slow queries.
Learn Brent’s tips to fix deadlocks. He’ll discuss tables in long transactions and why you need to work through them in a consistent order and touch them as few times as possible; then, he'll rewrite a stored procedure that's having deadlocking problems.
Speaker: Brent OzarIf you've managed database performance, you've come across the wait types CXPACKET and CXCONSUMER. You've seen a lot of conflicting instructions on how to go about fixing them, and you know that setting MAXDOP to 1 isn't the right thing to do. Learn what happens when SQL Server parallelizes queries correctly, what causes parallelism to go awry, and what you can do about it.
MySQL query tuning. See how to monitor and review the execution plan.
Learn best practices to configure VMs for SQL Server and database workloads, identify bottlenecks and resolve performance problems proactively.