Tracy Boggiano

Apply the new Query Store feature to identify and fix poorly performing queries in SQL Server. Query Store is an important and recent feature in SQL Server that provides insight into the details of query execution and how that execution has changed over time. Query Store helps to identify queries that aren’t performing well, or that have regressed in their performance. Query Store provides detailed information such as wait stats that you need to resolve root causes, and it allows you to force the use of a known good execution plan. With SQL Server 2017 and later you can automate the correction of regressions in performance. Query Store for SQL Server 2019 helps you protect your database’s performance during upgrades of applications or version of SQL Server. The book provides fundamental information on how Query Store works and best practices for implementation and use. You will learn to run and interpret built-in reports, configure automatic plan correction, and troubleshoot queries using Query Store when needed. Query Store for SQL Server 2019 helps you master Query Store and bring value to your organization through consistent query execution times and automate correction of regressions. What You'll LearnApply best practices in implementing Query Store on production serversDetect and correct regressions in query performanceLower the risk of performance degradation following an upgradeUse tools and techniques to get the most from Query StoreAutomate regression correction and other uses of Query StoreWho This Book Is ForSQL Server developers and administrators responsible for query performance on SQL Server. Anyone responsible for identifying poorly performing queries will be able to use Query Store to find these queries and resolve the underlying issues.

The world is shrinking. As technology makes it easy for people to live in one country and work in another, easily collaborate across borders, and have supply chains that are international, we need to learn new rules and adopt new attitudes. Indra Nooyi, a female Indian American is CEO of Pepsi. Tim Cook, an openly gay man, is the CEO of the world's first trillion dollar company - Apple. A black man was elected President of the United States. Progress like this scares many people, and it is not going to stop. Managers can choose to ignore it, fight it, or embrace it. Research at the best business schools in the world have amply documented the importance of diversity in a workplace. Diversity brings tangible advantages to any company. For this reason alone, I would suggest that managers learn to embrace it. This book will help business owners and managers navigate these new waters and flourish. In order to understand this change and progress, it is important to understand the struggles of those who personify it. Book two in the Let Her Finish series brings you stories and perspectives that would otherwise be impossible for the average tech manager to see or understand. It brings important perspectives for the manager that does not want to get run over and left behind by the changes that are happening, whether it scares them or not.