on June 22, 2018
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
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.
SQL Seminar Recordings
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
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.
- September 24-25, 2018
T-SQL School: SELECT Seminars
Learn Transact-SQL by writing queries each week: Twelve one-hour sessions.
- 1PM – 2PM PDT, each Saturday through Aug 11, 2018