Author Archives: craig@craigsmullins.com

About craig@craigsmullins.com

I'm a strategist, researcher, and consultant with nearly three decades of experience in all facets of database systems development.

My Computer Mug Collection, Part 1

Recently I have been tweeting a mug a day from my collection of coffeee mugs given to me over the years by computer and software companies. I just tweeted the last one (I think), and since these posts seemed to … Continue reading

Posted in DB2, mugs, tools | 2 Comments

Don’t Forget the Free Space

When you design your databases you must take care to specify appropriate free space to allow for data growth. Free space, sometimes called fill factor, is a DDL option that can be specified when creating or altering your table spaces … Continue reading

Posted in database design, DBA, free space, performance | Leave a comment

Monitoring MySQL and MariaDB Instances

Database performance monitoring and tuning is one of the biggest DBA responsibilities. The old maxim that if something can go wrong, it will, seems to be the general rule in the world of database administration. So, DBAs need effective tools … Continue reading

Posted in MySQL, performance | 2 Comments

Everybody Lies!

I was walking though the airport in Las Vegas after the IBM Think conference this year when I saw a book with the intriguing title of: Everybody Lies: Big Data, New Data, and What the Internet Can Tell Us About … Continue reading

Posted in analytics, Big Data, book review, information | Leave a comment

SQL Injection Still Causing Trouble

An on-going and important aspect of managing database security is designing your applications to avoid SQL injection attacks. SQL injection is a form of web hacking whereby SQL statements are specified in the fields of a web form to cause … Continue reading

Posted in data breach, Database security, DBA, SQL | Leave a comment

Minimizing Database Outages with Replication

A primary goal of most organizations is to minimize downtime and improve the availability of their IT systems and applications. According to a recent study on achieving 2018 database goals by Unisphere Research, “Enterprises seek to base most, if not … Continue reading

Posted in availability, data integration, DBA | 1 Comment

Supporting Multiple DBMS Products with Navicat Premium

DBAs are tasked with various and disparate responsibilities that consume their day. I’ve written DBA roles and responsibilities (What Does a DBA Do?) here on the blog before, so if you need a refresher, check out the link and meet … Continue reading

Posted in automation, backup & recovery, database design, DBA | 3 Comments

On the High Cost of Enterprise Software

Enterprise Software Should Not Cost an Arm and a Leg I believe that enterprise software is too costly and, indeed, it would seem that many others agree with me or we wouldn’t see the explosion of open source software being … Continue reading

Posted in enterprise computing | 1 Comment

Implementing a Data Governance Initiative?

I recently received the following question and I think it is interesting enough to blog about. Q: My company is looking to implement a data governance initiative. We want to be careful to avoid merely employing a series of extemporized … Continue reading

Posted in data governance | Leave a comment