Posted on

New Courses: Extended Events, Parallelism, Indexes, and More

It’s been a fun, busy spring and early summer. I have loads of new courses to share, and great stuff is coming up soon!

A big thank you to all the SQLWorkbooks members who attended live events, or posted your comments and questions! Your questions are terrific, and you’ve made these events so much fun.

SQLChallenge Courses

SQL Symposium and SQL Learning League members get all SQLChallenges.

SQLChallenge: Create an Extended Events Trace (55 minutes)

Follow the challenge script to reproduce a problem with Query Store in your test instance of SQL Server.

Then, your challenge is to configure a trace that will capture the problem — and also learn more about when the trace will capture an event, and when it won’t.

Challenge difficulty: This 200 level challenge will be pretty quick for folks who have configured Extended Events traces before. If you haven’t done that yet, it may take a little more time — but it’s worth it! These traces can be extremely useful.

Design the Best Index For One Year Wonders – SQLChallenge (50 minutes)

Can you reduce the logical reads as much as possible for the sample query using a disk based rowstore index?

Challenge difficulty: This challenge comes with three levels of difficulty. Even the 200 level, creating a nonclustered index without using advanced features, is interesting in this case due to the nature of the query.

Write a Query to Find “Revived” Names SQLChallenge (45 minutes)

I love writing a good query! This challenge is all about TSQL

Challenge difficulty: This is a 300 level TSQL challenge. If you’ve written queries to solve this kind of problem before, you may be able to blast through it- so there’s an “extra credit” option for you to strut your stuff in that case. If this is your first time thinking through approaches to the problem, it may take longer — but this is a pattern that will very likely prove useful in your query writing future.


SQL Seminar Recordings

SQL Symposium members get to attend all seminars live, plus watch recordings anytime.

How To Decipher CXPACKET Waits and Control Parallelism (4 hours)

Learn how to configure SQL Server’s degree of parallelism, how to dictate which queries go parallel, how to force parallelism, and how to avoid performance-killing anti-patterns.

You’ll also get the scoop on interpreting CXPACKET waits and the new CXCONSUMER waits introduced in recent versions of SQL Server.

Learn Indexing By Solving Problems – SQL Seminar – June 2018 (7 hours 23 minutes)

Learn to design and tune indexes by taking this set of eight indexing SQLChallenges!

This course builds your skills at architecting disk based rowstore indexes in SQL Server, and teaches you how indexes work at the same time. The challenges in this course teach you about clustered and nonclustered indexes, filtered indexes, indexed views, and more.


Upcoming Live SQL Seminars

Join the SQL Symposium to get all online seminars, live and recorded. Or purchase seminars individually.

Conquer Blocking and Isolation Levels

Are your users getting wrong data back? Learn how to get correct data and minimize blocking in this eight hour seminar.

  • July 11-12, 2018

Query Tuning Jam Session

Sharpen your query tuning skills in this four hour course of live SQLChallenges and solutions.

  • July 30, 2018

How to Decode Memory Pressure

Learn to identify and monitor both external and internal memory pressure against SQL Server in this four hour seminar.

  • August 14, 2018

Learn Indexing by Solving Problems – September Edition

Learn to architect disk-based rowstore indexes in eight hours of indexing challenges and solutions.

  • Watch the previously recorded seminar right away here
  • September 24-25, 2018

T-SQL School: SELECT Seminars

Learn Transact-SQL by writing queries each week: Twelve one-hour sessions. Additional signups for this experimental new course are only available via the SQL Symposium.

  • Watch the recorded sessions so far here
  • 1PM – 2PM PDT, each Saturday through Aug 11, 2018

 


Considering Joining?

Coupon code summersql will get you a big discount on the SQL Symposium or the SQL Learning League through June 28th — and it’s a recurring discount too!

As always, you can control the length of your subscription anytime. If you just want one year, you can cancel immediately and still get access for the rest of the year.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.