The SQLServerFast Execution Plan Video Training

Welcome to the SQLServerFast Execution Plan Video Training!

What is the SQLServerFast Execution Plan Video Training?

The SQLServerFast Execution Plan Video Training is an extensive set of videos, at this time not complete yet, to help SQL Server professionals learn and understand all they’ll ever need to know to read and understand execution plans; and to use this tool to identify causes of bad performance, and find ways to improve performance.

The focus in these videos is on being accessible and understandable, but also complete and correct. This means that videos will be of different duration. Most will be between 20 and 40 minutes, but expect exceptions on both ends.

How is the SQLServerFast Execution Plan Video Training structured?

The video above explains the generic course outline. Note that most of this is the current plan, and it’s not set in stone. During course development, I might realize I need to change the plan. If that happens, I will do so. To me, the quality of the final product is far more important than stubbornly sticking to an original plan.

Where can I find the SQLServerFast Execution Plan Video Training?

For technical reasons, each block of the SQLServerFast Execution Plan Video Training is hosted on a separate page. The table below lists all blocks, with a hyperlink to their respective pages.

Block name Duration Price * Demo scripts
Block 1: Understanding Execution Plans – basic level 6 chapters;
play time 2:09:34
Free Download
Block 1: Understanding Execution Plans – advanced level 5 chapters;
play time 2:40:37
$29.95 per chapter;
$124.95 for the whole block
Download
Block 2: Reading data – basic level 4 chapters Not yet available Not yet available
Block 2: Reading data – advanced level 3 chapters Not yet available Not yet available
Block 3: Combining data – basic level 6 chapters Not yet available Not yet available
Block 3: Combining data – advanced level 4 chapters Not yet available Not yet available
Block 4: Sorting and grouping – basic level 5 chapters Not yet available Not yet available
Block 4: Sorting and grouping – advanced level 3 chapters Not yet available Not yet available
Block 5: Various data manipulations – basic level 4 chapters Not yet available Not yet available
Block 5: Various data manipulations – advanced level 2 chapters Not yet available Not yet available
Block 6: Technical operators – basic level 5 chapters Not yet available Not yet available
Block 6: Technical operators – advanced level 5 chapters Not yet available Not yet available
Block 7: Data modifications – basic level 4 chapters Not yet available Not yet available
Block 7: Data modifications – advanced level 4 chapters Not yet available Not yet available

 

*   Prices are set in dollars, but will be automatically converted to equivalent currency based on where you live. Additional taxes might apply.

Can I run the demos on my own machine?

Of course!

In fact, I encourage playing with these demos. Run them, change things, run them again, and see what changes. There’s no better way of learning than to break stuff (preferably not on a production server, though) and then try to fix it.

The table above has download links for the demo code of each module.

Almost all demos use the standard sample databases created and distributed by Microsoft: AdventureWorks (download here) and ContosoRetailDW (download here). I might occasionally use other databases; this will be indicated in the demo script.

Do you have a planning for the unfinished blocks?

Yes, I do. But I am not going to share it.

As stated above, my primary objective is supplying the highest possible quality. Tied deadlines can result in cutting corners. I rather keep my planning internal. That gives me the flexibility to postpone releases if more time can increase the quality.

Do I really have to make an account?

Unfortunately, yes. A free basic account is enough, but you do need one.

All my videos are hosted on a platform, Vimeo, that handles all the work of making them available for streaming, processing payments, and tracking who has content. This saves me a lot of time.

But it does, unfortunately, require the creation of a Vimeo account. After all, how else would Vimeo know you already bought access to a video if you want to watch them again later?

Why didn’t you answer my question?

My apologies. I didn’t know you had that question. In fact, I still don’t.

But feel free to click here and ask me whatever you want. I’ll try to answer as soon as possible!

Menu

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close