{"id":111283,"date":"2026-06-10T09:18:08","date_gmt":"2026-06-10T09:18:08","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?post_type=collection&p=111283"},"modified":"2026-06-10T13:41:17","modified_gmt":"2026-06-10T13:41:17","slug":"dba-in-training-how-to-become-a-database-administrator-the-complete-series","status":"publish","type":"collection","link":"https:\/\/www.red-gate.com\/simple-talk\/collections\/dba-in-training-how-to-become-a-database-administrator-the-complete-series\/","title":{"rendered":"DBA in Training (how to become a database administrator) – the complete series"},"content":{"rendered":"\n

Learn how to become a DBA (database administrator) – plus, learn the all the essentials of SQL Server, from the very basics of how it works, to security, high availability, and more.<\/strong> The complete eight-part series can be found below.<\/strong><\/p>\n\n\n\n

\n
\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tSQL Server<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Pamela Mooney<\/span>\n <\/a>\n\n \n in<\/span>\n \n SQL Server <\/a>\n <\/span>\n<\/div>\n\n
\n

\n High availability in SQL Server – a guide (DBA in training, part eight) <\/h1>\n

\n DBAs must make sure data is highly available, and there are many SQL Server high availability options. Pamela Mooney discusses… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tSQL Server<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Pamela Mooney<\/span>\n <\/a>\n\n \n in<\/span>\n \n SQL Server <\/a>\n <\/span>\n<\/div>\n\n
\n

\n The basics of SQL Server internals (DBA in training, part seven) <\/h1>\n

\n In this article of the series, Pamela Mooney explains the architecture of SQL Server under the hood, including some query… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tDatabases<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Pamela Mooney<\/span>\n <\/a>\n\n \n in<\/span>\n \n Databases <\/a>\n <\/span>\n<\/div>\n\n
\n

\n How to know your server\u2019s limits (DBA in training, part six) <\/h1>\n

\n Comparing current performance to baselines helps DBAs know when there\u2019s a problem. In this article, Pamela Mooney describes how to… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tSQL Server<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Pamela Mooney<\/span>\n <\/a>\n\n \n in<\/span>\n \n SQL Server <\/a>\n <\/span>\n<\/div>\n\n
\n

\n SQL Server Backup Strategy: RPO, RTO, Recovery Models, and Restore Types <\/h1>\n

\n Build a SQL Server backup strategy from SLA to implementation: understand RPO and RTO, choose the right recovery model (FULL,… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tSQL Server<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Pamela Mooney<\/span>\n <\/a>\n\n \n in<\/span>\n \n SQL Server <\/a>\n <\/span>\n<\/div>\n\n
\n

\n SQL Server Security for DBAs: Authentication, Permissions, Monitoring, and Audit <\/h1>\n

\n Comprehensive SQL Server security guide for DBAs – covering physical and data-file security, patching, authentication (Windows vs SQL), server and… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tCareer<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Pamela Mooney<\/span>\n <\/a>\n\n \n in<\/span>\n \n Career <\/a>\n <\/span>\n<\/div>\n\n
\n

\n How to know your server environment(s) (DBA in Training, part three) <\/h1>\n

\n It doesn\u2019t matter if you become an \u201caccidental DBA\u201d or are actively looking for a database administrator position, you may… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tCareer<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Pamela Mooney<\/span>\n <\/a>\n\n \n in<\/span>\n \n Career <\/a>\n <\/span>\n<\/div>\n\n
\n

\n How to prepare for a DBA job interview (DBA in training, part two) <\/h1>\n

\n Getting that first job as a DBA is not easy for most of us. In this article, Pamela Mooney explains… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tCareer<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Pamela Mooney<\/span>\n <\/a>\n\n \n in<\/span>\n \n Career <\/a>\n <\/span>\n<\/div>\n\n
\n

\n How to become a DBA – the first steps (DBA in Training, part one) <\/h1>\n

\n Many people with tech careers did not follow a straight path to get there. In this article, Pamela Mooney gives… <\/p>\n <\/div>\n

\n