Monthly Archives: May 2013

A Question on Logical Modeling and Normalization

I received the following question and thought I’d answer it on the blog: Question: I work in a data-modeling environment with the responsibility of logically modeling (LM) data for mainframe and server databases. LM for the OLTP systems are done … Continue reading

Posted in data modeling, normalization | 7 Comments

Application Design and the DBA

Application design is more than just writing efficient database requests in application programs. Of course, application design includes database concerns such as interfacing SQL with traditional programming languages and the type of SQL to use. But every aspect of the … Continue reading

Posted in DBA, performance, SQL | 4 Comments

To Achieve Success DBAs Must Diversify

  A good DBA is a Jack-of-All-Trades. You can’t just master one thing and be successful in this day-and-age. A day in the life of a DBA is usually quite hectic. The DBA maintains production and test environments, monitors active … Continue reading

Posted in DBA | 2 Comments

Data Professionals: Invest in Yourself!

So, are you worth investing in or not? Most every IT professional continually looks for their company to invest money in on-going education. Who among us does not want to learn something new – on company time – and with … Continue reading

Posted in books, education | 3 Comments

The Business-Savvy DBA?

Heads-down DBAs who know technology, but not their company’s business, soon will be on the endangered species list. Be Business Savvy Although DBAs are technologists first and foremost, we need to be ever cognizant of the business reasons that our … Continue reading

Posted in DBA | 1 Comment