A database administrator, who designs, sets up, maintains and secures database systems, looking after availability, performance, backups and recovery, and deciding who may access the data.
Also called database administrator.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains DBA in context, with comparison tables and the common traps.
Terms in this definition
- Schema
The middle part of a Unity Catalog name (
catalog.schema.table), grouping tables, views, volumes, functions and models inside a catalog. A grant on it covers everything in it now and later, and nothing inside can be reached withoutUSE SCHEMA. - Performance
Routing method in Traffic Manager that directs users to whichever endpoint offers the lowest latency.
Related terms
- Entity Framework Core
Microsoft's object-relational mapper for .NET. Its migrations change a database's schema; for automated deployments Microsoft suggests migration bundles, and SQL scripts where a database administrator needs to review the SQL first.