Experience Innovative Online Hands-on SQL Server Learning via YouTube

 
We would like to introduce you to the first Online Hands-on Learning available for SQL Server.

Learn SQL Server Internals and practice the hands-on examples shown in the YouTube videos right away – LIVE – while watching! No bulky VMs to download, SQLTest tool simulates the hands-on labs for you! No registration necessary.

Here are some of the topics we have available at the moment:

  • Why does SQL Server choose Scan instead of Seek? Also check out the cost based optimizer and see for yourself: It sometimes chooses seek over scan even though the seek is a bit more expensive.
  • How about Resource Governor, are you aware that Resource Governor CPU Throttling does not work for mixed workload until SQL Server 2016? Before you promise your manager anything, practice some scenarios!
  • Did you know SQL Server Optimizer doesn’t cost CPU overhead related to expanding compressed data? Learn why you should never compress certain tables by checking out the hands-on video Data Compression – Pros and Cons.
  • Don’t count on the wait time, SQL Server will reset the ASYNC_NETWORK_IO wait time after a threshold, don’t believe any canned demos, check it out for yourself!

 

  • Concurrent updates and selects from adjacent rows on the same page from many sessions can lead to PAGELATCH_EX and PAGELATCH_SH contention, practice the solution.

All tutorials can be found on sqlvideo.com (YouTube embedded), hands-on example scripts included.

Enjoy the experience and please take a few minutes to give us feedback so we can improve our tutorials!

Are there any specific topics you would like us to cover among our next clips? Don’t forget to mention them as well.

If you want to take the learning a step further, join one of our in-person hands-on workshops! Schedule

Looking forward,

Ramesh and Carmen from SQLWorkshops.com

Subscribe to our newsletter

  • To receive free Community License for SQLTest.
  • To receive access to additional, bonus video tutorials and example scripts.
  • To keep the learning going.

Leave a Reply

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