This seminar will be held July 30, 2018 (Online, 8:00 AM – 12:00 PM PDT)
Want to practice query tuning in SQL Server?
I’m all about learning by solving problems here at SQLWorkbooks – and this Query Tuning Jam Session is all about solving query tuning problems – live!
What you’ll learn in this SQL Seminar
In this four-hour live seminar, you’ll tackle query tuning problems against your own demo environment.
If you like the SQLChallenges here at SQL Workbooks, this will be similar: we’ll introduce and conquer a bunch of query tuning SQL Challenges throughout the session.
What do I need to know?
This course is designed to be “intermediate” level — that means you need to have a basic comfort with writing TSQL and designing indexes. If you find yourself stumped occasionally throughout the day, your classmates and I will give you hints of where to start, and I’ll also bring the class together for each problem to examine different solutions and recap the results.
Do I have to have a demo environment?
This session is way more fun if you can play along — plus, it means you can keep playing around with the examples after class, and continue your learning.
For this course you want to have a private SQL Server instance test environment with at least 4 cores and a minimum of 4GB of RAM. A virtual environment is totally fine, and it can be on your laptop. I encourage you to run the free SQL Server 2017 Developer Edition so you can test out new features.
This course is taught by me, Kendra Little
I’m a Microsoft Certified Master in SQL Server, and I also worked for many years as a Database Administrator in critical enterprise production environments. I learned early on as a DBA that the default settings that SQL Server gives you for controlling parallelism aren’t good – and I also learned the hard way not to believe any claims of “one simple trick” to configure this perfectly for all environments.
In this four hour seminar, I share my own process for tuning these settings for critical environments – plus a simplified process for any not-so-critical environments that you may need to administer, too.
Can I watch the SQL Seminar later?
Yep! I’ll make the GoToWebinar recording of the session available for the class after the seminar completes. You’ll have access to the recording for a year.
What’s the experience like?
When you register for this seminar, you’ll be enrolled in an online GoToWebinar meeting scheduled for the date you select in the dropdown. The invitation makes it easy for you to block out the seminar on your calendar, and it also contains your unique information to connect.
Prior to the seminar, I’ll send you setup instructions on how you can test your connection, and where to download the sample databases we’ll be using.
The day of the seminar, you’ll join the live GoToWebinar session. I’ll be live with my webcam and shared demo environment.
We’ll take a 10 minute break every hour or so. That way, everyone can move around and stretch, etc.