Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft Azure SQL Database platform. Anyone responsible for writing or creating T-SQL queries will find valuable the insight into bottlenecks, including how to recognize them and eliminate them.
Some time ago, one of my colleagues asked me, “What do you like about SQL Server the
most?” I had heard this question many times before, and so I provided my usual answer:
“SQL Server Internals. I like to understand how the product works and solve complex
problems with this knowledge.”
Move data back and forth between database and application. The must-have knowledge in this book helps programmers learn how to use the official driver, MySQL Connector/Python, by which Python programs communicate with the MySQL database.
This book takes you from the initial installation of the connector through...