SQL Server Pamela Mooney in SQL Server High availability in SQL Server – a guide (DBA in training, part eight) DBAs must make sure data is highly available, and there are many SQL Server high availability options. Pamela Mooney discusses... 19 May 2021 23 min read
SQL Server Pamela Mooney in SQL Server The basics of SQL Server internals (DBA in training, part seven) In this article of the series, Pamela Mooney explains the architecture of SQL Server under the hood, including some query... 28 January 2021 27 min read
Databases Pamela Mooney in Databases How to know your server’s limits (DBA in training, part six) Comparing current performance to baselines helps DBAs know when there’s a problem. In this article, Pamela Mooney describes how to... 10 December 2020 15 min read
SQL Server Pamela Mooney in SQL Server SQL Server Backup Strategy: RPO, RTO, Recovery Models, and Restore Types Build a SQL Server backup strategy from SLA to implementation: understand RPO and RTO, choose the right recovery model (FULL,... 09 November 2020 21 min read
SQL Server Pamela Mooney in SQL Server SQL Server Security for DBAs: Authentication, Permissions, Monitoring, and Audit Comprehensive SQL Server security guide for DBAs - covering physical and data-file security, patching, authentication (Windows vs SQL), server and... 08 October 2020 28 min read
Career Pamela Mooney in Career How to know your server environment(s) (DBA in Training, part three) It doesn’t matter if you become an “accidental DBA” or are actively looking for a database administrator position, you may... 14 September 2020 11 min read
Career Pamela Mooney in Career How to prepare for a DBA job interview (DBA in training, part two) Getting that first job as a DBA is not easy for most of us. In this article, Pamela Mooney explains... 26 August 2020 18 min read
Career Pamela Mooney in Career How to become a DBA – the first steps (DBA in Training, part one) Many people with tech careers did not follow a straight path to get there. In this article, Pamela Mooney gives... 11 August 2020 15 min read