RetiredDBA.com

RetiredDBA.com provides tidbits, ideas and insights to all things Microsoft SQL Server.

Home / Career / Free is Awesome! Right DBAs?

Free is Awesome! Right DBAs?

/
/
/



This is a book review of Grant Fritchey’s free book: ‘SQL Server Execution Plans – Third edition‘. Grant Fritchey is a SQL Server MVP with over 30 years’ experience in IT and he runs a blog at Scarydba.com .

The updated version of SQL Server Execution Plans is a huge 515 pages long. Chapters were rearranged and pretty much rewritten from scratch according to Fritchey. This gem is in PDF format thankfully! SQL Server Execution Plans contains 17 chapters chock full of information on SQL Server execution plans. The final chapter contains information on execution plan tools such as: SSMS tools, Plan Explorer by SentryOne, Supratimas, etc.

Fritchey states some of the new topics in the third edition include:

  • Automate capturing execution plans using Extended Events
  • New warnings and operators
  • Batch mode processing
  • Adaptive query processing
  • Additional functionality added for SQL Server 2014, 2016, and 2017, as well as Azure SQL Databases

DO not pass up chapter 16 on The Query Store! As Fritchey states ‘This chapter will cover the Query Store as it relates directly to execution plans and execution plan control…’. It’s a great read on how this SQL Server 2016 feature works. It contains detailed information on the query store options, retrieving execution plans from the query store, query store reports, using T-SQL to retrieve query store execution plans, removing execution plans from the query store and much more.

All the T-SQL code used in the book can be found via a web link listed in the book. Most of the T-SQL code can be used against the AdventureWorks2014 sample database. You can download several versions of the sample SQL Server database from github: Adventureworks

Fritchey states ‘…this book took over three years to rewrite and, during that time, three versions of SQL Server were released, and who knows how many changes in Azure were introduced’ So read SQL Server Execution Plans third edition by Grant Fritchey already! It’s a thumbs up from me and it’s absolutely free!

FREE is AWESOME! Right DBAs?

This div height required for enabling the sticky sidebar

Advertisers



Programmer Solutions Inc Websites

BUSINESS
CITY JOB RESOURCES
MIDWEST JOB RESOURCES
SOUTH JOB RESOURCES
WEST JOB RESOURCES
Industrial Supply DealsChicago Job ResourceKansas Job ResourceAlabama Job ResourceAlaska Job Resource
Office Supply DealsWashington, DC Job ResourceIllinois Job ResourceArkansas Job ResourceArizona Job Resource
EDUCATION
SPECIAL JOB RESOURCES
Indiana Job ResourceDelaware Job ResourceCalifornia Job Resource
Back To School MallDiversity Job ResourceIowa Job ResourceFlorida Job ResourceColorado Job Resource
SHOPPING
First Job ResourceMichigan Job ResourceGeorgia Job ResourceHawaii Job Resource
Health Care and FitnessFreelance Job ResourceMinnesota Job ResourceKentucky Job ResourceIdaho Job Resource
Just Best GiftsIntern Job ResourceMissouri Job ResourceLouisiana Job ResourceMontana Job Resource
Just Clearance SalesSeasonal Job ResourceNebraska Job ResourceMaryland Job ResourceNevada Job Resource
Just Comparison ShoppingSenior Job ResourceNorth Dakota Job ResourceMississippi Job ResourceNew Mexico Job Resource
Just OutletsVolunteer Job ResourceOhio Job ResourceNorth Carolina Job ResourceOregon Job Resource
Luxury Matters
TARGETED JOB RESOURCES
South Dakota Job ResourceOklahoma Job ResourceUtah Job Resource
Tradin StuffBlue Collar Job ResourceWisconsin Job ResourceSouth Carolina Job ResourceWashington Job Resource
Value BuyersExecutive Job Resource
NORTHEAST JOB RESOURCES
Tennessee Job ResourceWyoming Job Resource
TECHNOLOGY
Finance Job ResourceConnecticut Job ResourceTexas Job Resource 
FrontPage HelpHealthcare Job ResourceMaine Job ResourceVirginia Job Resource 
MCDBA DirectoryIT Job ResourceMassachusetts Job ResourceWest Virginia Job Resource 
Retired DBAPink Collar Job ResourceNew Hampshire Job Resource  
SQL Server DirectorySports Job ResourceNew Jersey Job Resource  
Transact SQL DirectoryWhite Collar Job ResourceNew York Job Resource  
  Pennsylvania Job Resource  
  Rhode Island Job Resource  
  Vermont Job Resource