Explore all the products and find the right solution for your business
Proactively manage server performance on-prem or in the cloud with timely alerts and analytics
Fast configuration of regulatory and audit compliance settings with proactive monitoring, alerts, and reporting
Automated database security, monitoring and management for MS SQL, Azure and Amazon RDS for SQL Server
Backup and instant recovery for SQL Server, Azure Blob Storage and Amazon S3
Discover, track and manage database inventory across the entire environment
24 Essential tools to simplify daily server administration
Get the right solution to keep your database running at peak performance.
All of the support you need at your convenience.
When you pass in a query, how does SQL Server build the results? I will give you a scenario: I'm the end user sending in queries, and the SQL Server engine is my client. Using simple spreadsheets as tables, you'll learn how SQL Server builds execution plans, uses indexes, performs joins, and considers statistics. This session is for DBAs and developers who are comfortable writing queries, but not so comfortable when it comes to explaining nonclustered indexes, lookups, sargability, and fill factor.
Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz® and sp_AskBrent®, coauthored Professional SQL Server 2008 Internals and Troubleshooting, and he loves sharing knowledge at BrentOzar.com. He's a Microsoft Certified Master of SQL Server.
Topics: Database Diagnostics, Database Monitoring, Database Performance, SQL Query Performance Products: SQL Diagnostic Manager for SQL Server