# SQL Tips for Application DBAs

DevFeed: [SQL Tips for Application DBAs](<https://devfeed.tech/articles/some-sql-tricks-of-an-application-dba-33940.md>)

Original publisher: [Read original article](<https://hakibenita.com/sql-tricks-application-dba>)

Author: Haki Benita

Published: 2020-07-26T21:00:00Z

Content type: tutorial

Language: en

Sources: [Haki Benita](<https://devfeed.tech/sources/haki-benita.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [Development](<https://devfeed.tech/topics/development.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [schema design](<https://devfeed.tech/topics/schema-design.md>), [data migrations](<https://devfeed.tech/topics/data-migrations.md>), [etl](<https://devfeed.tech/topics/etl.md>)

Tags: [articles](<https://devfeed.tech/tags/articles.md>), [data-migrations](<https://devfeed.tech/tags/data-migrations.md>), [databases](<https://devfeed.tech/tags/databases.md>), [development](<https://devfeed.tech/tags/development.md>), [etl](<https://devfeed.tech/tags/etl.md>), [performance](<https://devfeed.tech/tags/performance.md>), [schema-design](<https://devfeed.tech/tags/schema-design.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

An application DBA shares practical SQL and database-development advice, including limiting updates to rows that need changes and considering constraint costs when loading or updating many rows.

## Source excerpt

Some tips and misconceptions about database development I gathered along the way.