Pamela Mooney

Pam Mooney is a Senior Database Administrator who works for a financial institution in the St. Louis area who loves teaching, automating processes, mentoring, and investigating obscure parts of SQL Server. When Pam isn't working, she loves gardening, scuba diving, reading history, kayaking, and seeing new places and things. Find Pam on Twitter as @pamelamooney or on her blog, The Noncluttered Index (https://www.thenonclutteredindex.com).

Follow Pamela on

Pamela Mooney 28 January 2021

DBA in training: SQL Server under the hood

Learn SQL Server

In this article of the series, Pamela Mooney explains the architecture of SQL Server under the hood, including some query anti-patterns to avoid.… Read more

Learn SQL Server

Pamela Mooney 10 December 2020

DBA in training: Know your server’s limits

Database Administration

Comparing current performance to baselines helps DBAs know when there’s a problem. In this article, Pamela Mooney describes how to measure the physical resources drive space, latency, memory, and CPU.… Read more

Database Administration

Pamela Mooney 09 November 2020

DBA in training: Backups, SLAs, and restore strategies

There are a handful of options when backing up SQL Server databases. A DBA must understand the differences and come up with a plan that protects the organisation’s data. In this article, Pamela Mooney explains service level agreements, recovery models, and some strategies to ensure that the data can be restored quickly.… Read more

Pamela Mooney 08 October 2020

DBA in training: Security

Securing data is not always easy to do, but it should be the top responsibility for database administrators. From protecting the physical servers to preventing copies of backups files from getting into the wrong hands, there is a lot to consider. In this article, Pamela Mooney covers what DBAs need to think about when securing their organisation’s data.… Read more

Pamela Mooney 14 September 2020

DBA in training: Know your environment(s)

It doesn’t matter if you become an “accidental DBA” or are actively looking for a database administrator position, you may need to do some research to find the servers now in your care. In this article, Pamela Mooney provides some advice about what to track down first.… Read more

Pamela Mooney 26 August 2020

DBA in training: Preparing for interviews

Getting that first job as a DBA is not easy for most of us. In this article, Pamela Mooney explains what to expect when interviewing and how to prepare.… Read more

Pamela Mooney 11 August 2020

DBA in Training: So, you want to be a DBA…

Many people with tech careers did not follow a straight path to get there. In this article, Pamela Mooney gives some advice for those who would like to be a DBA.… Read more

Pamela Mooney 16 April 2020

How to Set Up Transactional Replication

Database Administration

Replication is one way to copy data to another database or server. In this article, Pamela Mooney describes how to set Transactional Replication.… Read more

Database Administration

OVERVIEW

BY NEED

BY ROLE

BY INDUSTRY