Monthly Archives: May 2013

A Question on Logical Modeling and Normalization

Posted on May 31, 2013 by craig@craigsmullins.com

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 | 8 Comments

Application Design and the DBA

Posted on May 24, 2013 by craig@craigsmullins.com

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

Posted on May 20, 2013 by craig@craigsmullins.com

  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!

Posted on May 13, 2013 by craig@craigsmullins.com

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?

Posted on May 10, 2013 by craig@craigsmullins.com

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

The Proper Approach: Developing Systems Based on Models

Posted on May 7, 2013 by craig@craigsmullins.com

A big challenge facing organizations today is ensuring the appropriate information reaches the right people so that data is used appropriately and accurately. Information is the key to business success and its proper care and treatment should be of the … Continue reading →

Posted in data, data modeling, DBA, information, metadata | 6 Comments