SQL Sentry, Inc. delivers software products that optimize the performance of Microsoft® SQL Server® environments. SQL Sentry Performance Advisor® for SQL Server delivers an advanced performance dashboard with relevant Windows and SQL Server metrics in a single view along with detailed insight of heavy SQL, blocking, deadlocks, and disk bottlenecks. SQL Sentry Performance Advisor for Analysis Services provides unparalleled insight into Analysis Services performance, including bottlenecks related to memory, storage systems, aggregation usage, queries and processing. SQL Sentry Event Manager® is the ultimate scheduling, alerting and response system for managing SQL Server jobs and other events that impact performance. The FREE SQL Sentry Plan Explorer builds upon the graphical plan view in SSMS to make query plan analysis more efficient.
In this demo-packed session, you’ll learn practical tips and tricks for SQL code tuning from experienced SQL Server MVPs Aaron Bertrand and Kevin Kline as they walk you through some of the most problematic and troublesome SQL coding problems.