>

Glossary

Some common terms used on this blog and my own definition, with sources and references if relevant - feel free to use and expand on:

Roles

DBA
Database Administrator. Manage, as well as develop for, one or more database servers. May include SQL Server, MySQL, MariaDB, PostgreSQL, Oracle etc. This blog mainly deals with SQL Server. A couple of great definitions of what a DBA is and how they work can be found at:
  1. https://www.brentozar.com/archive/2021/03/what-does-a-database-administrator-actually-do/
  2. https://www.brentozar.com/training/fundamentals-database-administration/
  3. http://datatechnologytoday.wordpress.com/2010/07/28/what-does-a-dba-do/
  4. https://thomaslarock.com/2014/12/seven-tips-solving-accidental-dba-problem/
support staff
IT teams work in many different ways. I use the term support to loosely mean IT or related teams that may be called on to fix production issues, in and out of normal hours. Support staff may include the DBA - but sometimes not.

Server- and database-specific

database
A structured collection of data, organised for storage and querying. SQL Server and other relational database management systems (RDBMS) organise into tables, views, stored procedures, functions, users etc.
system database
In SQL Server-speak, the master, model, msdb and tempdb databases. Can be ignored in queries by using a clause like SELECT * FROM sys.databases WHERE database_id > 4.
database user
In SQL Server, a person or group with a set of permissions relating to a database. Typically linked to a server-level login, but not always. Users may be members of a role like "database owner" or "read only". Users can be given specific permissions on tables (even down to the column level), views, stored procedures etc.
DNS CNAME
A DNS CNAME is an alias or redirect to point to a server or service. It can be used in place of a server or service when connecting - from any app, such as Windows Explorer, web browsers, SSMS etc. Using a DNS CNAME allows users to transparently connect to the server or service that the DNS CNAME points to, without being aware of the real location of the server or service. This adds opportunities like migrating the server or service, using cloud infrastructure, load balancing and "failing over" in case of issues. DNS CNAMEs are used every day in web browsers (www.google.com is a DNS CNAME, that points to the real server or service).

Concepts

operations, operational
Day-to-day, normal, "keep the lights on"-type work to support "the business". As distinct from longer-term tactical and strategic work.
issue
A problem, something preventing normal work. May require analysis as to root cause. May require a timely fix or workaround. It's important to consider whether something's an "issue" from your customer's perspective.
production
A "live" environment, consisting of networks, servers, applications, authentication services etc. And databases. The opposite of non-production.
non-production
Covers all non-"live" environments, sometimes referred to as "test", "development", "staging", "user acceptance" etc. The opposite of production.