Why take this course?
Everyone tells you that SQL Server can be really fast. It's used in tier-one organizations. So why are your SQL Server applications so slow?
Are they getting even slower when more data is added?
Do you know which queries to try to fix? Do you know how to fix them?
Chances are high that you have a basic indexing or repetitive query issue. In this short course, Greg will take you through an easy 4 step process to get back on track by fixing the most common issues.
- Installing our free tools
- Capturing what's happening
- Analyzing what happened
- Fixing the worst offenders
In so many cases, doing just these four steps will let you fix the main problems, quickly - and without the need to buy expensive monitoring tools.
The short videos and complimentary tools provided by SQL Down Under are both quick to learn and an invaluable resource for SQL DBAs and developers. This query analysis method presents an extremely useful summary view making it easy to identify heavy hitting queries and overly chatty applications. I would highly recommended this intro course for anyone involved with performance tuning SQL Server apps and thank Greg for sharing this with the community.
- Steve Lynch, Senior Consultant, Synergetic Management Systems
Dr Greg Low is an international consultant, developer and trainer. He has been working in development since 1978, holds a PhD in Computer Science and a host of Microsoft certifications. Greg was the first certified master for SQL Server world-wide. He is the Managing Director for SQL Down Under, a Data Platform (SQL Server) MVP, host of the popular SQL Down Under podcast series, and a member of the Microsoft Regional Director program.
StartWho is this course for? (1:14)
StartWho is Greg ? (1:08)
StartWhy is indexing such a big issue? (2:01)
StartWhy are repetitive queries also such an issue? (3:08)
StartWhy do developers need to care about query performance more than ever?
StartWhat will I learn to do in this course? (1:45)