Alan Gordon, SSP’s Data Operations Manager, recently wrote a blog post, “Data Therapy: 10 Tips to Optimize your Database Administrator,” for the Nonprofit Technology Network.
“Fast, good, cheap. It’s the unicorn we’re all searching for, but does it really exist? The answer is yes, but only if you know where and how to find it. Sadly, most of us are going about it all wrong.
One of the most frustrating aspects of being a database administrator (DBA) is the sense of urgency born from lack of planning. When we rush to glean data, it is almost always at the expense of data integrity. Running queries and doing the analysis isn’t rocket science; however, there are only eight hours in the work day, and some requests require sign-off from more senior staff which can slow down an urgent request.”