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.
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.
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.
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.
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 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
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
Sharpen your query tuning skills in this four hour course of live SQLChallenges and solutions.
- July 30, 2018
Learn to identify and monitor both external and internal memory pressure against SQL Server in this four hour seminar.
- August 14, 2018
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
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
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.