In-Depth Training for Administrators, DBAs, Developers, & Data Professionals

Looking for intense training to help you take your career to a new level? SQL Server Live! Training Seminars take our world-class education on the road to provide in-depth, actionable developer and DBA training when and where it's convenient to you. Keep up-to-date on some of the hottest trends in the tech industry to drive your career forward. These engaging and high-impact training seminars provide in-depth education and knowledge-share, networking with fellow peers, and one-on-one interaction with a skilled instructor to take what you have learned back to your office.

Attend Live or Virtually

Practical Real-World SQL Server Performance for Everyone

In most organizations, accidental DBAs are the individuals who are often responsible for the SQL Server performance. In the real world, when we face performance problems we often don't have the luxury of time to study theory and find solutions. What helps us during these times of crisis are handy scripts which help us fix our performance problems quickly and efficiently. In this fast-paced, demo-heavy 2-day training workshop, we will learn how we can immediately improve our application performance when we know exactly what to do.

Over two days, this demo-oriented, real-world storytelling workshop will answer the questions which DBAs and Developers often wonder about Performance Tuning and Query Optimization. There are some problems which have straightforward answers, but there are some problems which are often invisible or need attention without even a problem statement.

Attendees of this 2-day workshop will learn:

  • About SQL Server Performance Tuning with Practical Case Studies
  • How to Identify and Resolve SQL Server Deployment Inefficiencies
  • How to proactively Implement Indexing and Maintenance Strategies for Future Proof Performance
Day 1: Server and Database Tuning and Optimization
Tuesday, October 29, 2019
9:00AM – 5:00PM
Level: Intermediate

In this full day training session, we will primarily focus on all of the basics to advanced concepts which are related to SQL Server and our Database. There are many tips and tricks which are extremely easy to implement but not commonly known. We will discuss each of them in great details with examples.

The following important topics and concepts will be covered on day 1:

  • Server Configurations
  • Database Configurations
  • Index Analysis and Optimizations
  • SQL Server Resource Wait Stats Analysis
  • SQL Server Best Practices
  • SQL Server Upgrade Path
  • What's in Version Next?

Day 1 will end with Q&A and a brief quiz.

Day 2: Query Tuning and Optimization
Wednesday, October 30, 2019
9:00AM – 5:00PM
Level: Intermediate

On day two, we will primarily focus on how to write efficient queries. Everybody knows how to read the basics of an execution plan, but not everyone knows how to interpret them as an expert and how to get the most out of them. We will learn how to write efficient and optimal queries with the help of execution plans.

The following important topics and concepts will be covered on day 2:

  • Query Life Cycle
  • Joins and Queries
  • Functions and Queries
  • Multi CPU Queries
  • Data Types and Performance Impact
  • Advanced Execution Plans

Day 2 will end with Q&A and a brief quiz.

Meet Our Speaker
Pinal Dave
SQL Server Performance Tuning Expert & Consultant

Pinal Dave is a SQL Server Performance Tuning Expert and an Independent Consultant. He has authored 11 SQL Server database books, 21 Pluralsight courses and has written over 4500 articles on the database technology on his blog at a blog.sqlauthority.com. Along with 16+ years of hands-on experience, he holds a Master's of Science Degree and a number of database certifications.

Attend Live or Virtually

Virtual Classroom Available!

Can't travel to the SQL Server Live! Training Seminar in Phoenix? You can join this class via our Virtual Classroom. Learn More

SQL Server Live! has partnered with MicroTek Phoenix, AZ to offer a virtual classroom opportunity to our attendees. The Virtual Training Room enables remote attendees to experience the benefits of instructor-led training without having to travel. Remote participants experience the same collaboration, instructor interaction, and learning benefits as those who are physically in the classroom. SQL Server Live!'s Virtual Training Room technology allows all students to:

  • See and hear everything that is taking place in the live classroom
  • Raise their hands and ask questions
  • View and interact with course content (presentations, videos, code, and more)
  • Experience real-time collaboration

Virtual Classroom Requirements
All remote users need to participate in a Virtual Training Room event is a computer with camera, wired Internet connection, speakers, and a microphone -- it's that easy.

Top Reasons To Join Us in Phoenix

In-Depth Training.

If you are a developer, DBA, or data professional looking for training, SQL Server Live! Training Seminars provide focused in-depth training with one of the top experts in the field. Attend both days, in-person or virtually, and learn how to set your team up for success with Performance Tuning and Query Optimization.

Networking.

With small classes and an expert instructor, the intimate setting of these training courses allows for networking with your peers to learn from their experiences, problem-solve and bring solutions back to your office.

Get the Most Out of Your Time.

If you don't have time for a full 4, 5, or 6-day conference, look no further. SQL Server Live! Training Seminars provide in-depth, actionable training in a two-day format to fit in with your busy schedule.

Looking For More? If you are interested in more Administrator, DBA, Developer, & Data Professional training offerings, check out vslive.com and live360events.com to explore the events, sessions, workshops and hands-on training options we offer.

REGISTER NOW
Seats Are Filling Quickly – Secure Your Spot Today!

Pricing

  • Standard Registration through October 29
  • 2-Day Workshop (in-person or virtual)
  • $1,340

If attending in-person, a continental breakfast, hot catered lunch, and breaks will be provided as part of your SQL Server Live! registration.

Discounts are available for alumni, government employees and educators. For more information, contact us at csegerson@converge360.com, or 949.296.9840.

Part of a team of 3 or more? Contact us at csegerson@converge360.com, or 949.296.9840 for more information and pricing.

You may substitute one person in your place by contacting csegerson@converge360.com at least five business days prior to the event. If you must cancel all or part of your registration, your refund request must be sent no later than 20 business days prior. Your fee will be returned, less a $250 cancellation fee. No refunds will be issued within 20 days of the event.

Event Details

Location
Click here for detailed event location

Close

The facility name you are looking for is Training To You (MicroTek - Phoenix, AZ), a MicroTek partner facility.

Training To You (MicroTek - Phoenix, AZ)
2200 N Central Ave Ste. 400
Phoenix, AZ 85004

Parking
Free parking can be found in front of the building.

Hotels
Click here for hotels, directions & travel

Close

Hotels
SQL Server Live! has partnered with Training To You (MicroTek - Phoenix, AZ) to offer you discounted pricing at the Hilton Garden Inn Phoenix Downtown close to the training center.

Hilton Garden Inn Phoenix Downtown
15 E. Monroe
Phoenix, Arizona 85004

Reserve your room online or call 602-343-0006 and request the MicroTek rate.

Can't Make This Location? Check Out Our Other Events.

Why SQL Server Live!

SQL Server Live! conferences and training seminars provide a broad range of content for administrators, DBAs, and developers to help them do more with their SQL Server investment. Visit us at vslive.com or live360events.com.

 

Questions or Want to Learn More?
Email Sara Ross at sross@converge360.com.
We look forward to hearing from you!