Some SQL Tricks of an Application DBA

" summary

Covers practical database-development tips and longstanding DBA rules of thumb for application developers, with concrete techniques such as loading sorted data into tables to improve performance, making indexes invisible, and scheduling long-running processes during off-peak (odd) hours. Focus is on non-trivial, experience-based practices for working with relational databases to avoid common pitfalls and improve operational behavior.

AI-written summary · about

" related talks

• 46mAwesome SQL – tips and tricks for application developersVlad Mihalcea · Voxxed Days Cluj-Napoca 2019
• 01h 00m50 Things All SQL Server Developers Need to KnowAaron Bertrand · 24 Hours of PASS: Summit Preview 2015
• 48mThe DB tamerIlya, Fedor Sazonovy · JPoint 2024
• 02h 42mSQL (The Return): Demystifying Preconceptions and Using the DB EffectivelyFranck Pachot · Devoxx France 2023
• 43mWhat a Database Can Tell You About Application ProblemsSerhii Bielskyi, Denys Reznik · .NET fwdays'21 conference
• 39m10 Things Developers should know about DatabasesPeter Zaitsev · Percona University Montevideo 2019
• 35m10 things a developer should know about databasesCarlos Tutte · Nerdearla 2020
• 25mThe Secret Life of SQL: How to Optimize Database PerformanceBryana Knight · RailsConf 2017