The Five Leverage Points for SQL Server Performance and Management

Speaker: Rob Loranger of Embarcadero Technologies.

During this lively conversation with real world examples, Rob will discuss the five leverage points every DBA and Developer needs to focus on to increase SQL Server Performance and Manageability.

Rob will show how to get the most “bang for your buck” when looking to improve overall performance and productivity at every stage of the application development lifecycle.

In showing off real world examples, Rob will demo DB PowerStudio for SQL Server, Embarcadero’s new toolset that complements SSMS with critical capabilities such as database change management and SQL optimization and tuning.
You’ll learn how to:

Use Object Management skills to reverse engineer objects in seconds and place them within a project framework Manage database change from development through production Optimize SQL through the use of Visual SQL Tuning (VST) Diagrams in minutes instead of hours or days Identify “what if” scenarios and load test them BEFORE promoting to production to see their impact on database performance Manage upgrades and multiple versions of SQL Server to boost performance and productivity across all versions of SQL Server Rob Loranger is a Software Consultant with Embarcadero Technologies. He spends much of his time helping database professionals, such as DBAs, Database Developers, and Data Architects find solutions to their database related requirements. Rob has an EE degree from UC Santa Barbara.