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.

SQL Coding and Tuning for Efficiency

Coding and tuning SQL is one of the most time consuming tasks for those involved in coding, managing and administering relational databases and applications. There can be literally thousands of individual SQL statements across hundreds of applications that access your … Continue reading

Posted in books, performance, SQL | Leave a comment

IT Through the Looking Glass

Sometimes I look for inspiration in what may seem — at first glance — to be odd places.  For example, I think the Lewis Carroll “Alice in Wonderland” books offer sage advice for the IT industry.  I mean, how many … Continue reading

Posted in business planning, IT | Leave a comment

Gaining Value from Analytics

Data volume and higher transaction velocities associated with modern applications are driving change into organizations across all industries. This is happening for a number of reasons. Customer and end user expectations for interacting with computerize systems has changed. And technology … Continue reading

Posted in analytics, Big Data | Leave a comment

Hey, DBAs… Should You Be a Jack-of-all-Trades?

You know what a Jack-of-All-Trades is, don’t you? It is that person that always seems to have know-how on a topic or project that is helpful. They have a comprehensive knowledge of all things data- and IT-related and they are … Continue reading

Posted in DBA | Leave a comment

Have You Thought About the Impact of eDiscovery on Your Data Management Strategy?

When thinking about data management it is unlikely that your first thought is about legal requirements. Nevertheless, the legal side of data management must be considered in this day and age of regulatory compliance. To some, the sheer volume and … Continue reading

Posted in compliance, data, data breach, Data Growth | Leave a comment

What the Null? Handling Missing Information in Database Systems

In relational database systems, a null represents missing or unknown information at the column level. A null is not the same as 0 (zero) or blank. Null means no entry has been made for the column and it implies that … Continue reading

Posted in NULL, SQL | Leave a comment

Who Owns Data?

Who owns data? This is a complex question that can’t be answered quickly or easily. It requires some thought and you have to break things down in order to even attempt to answer it. First of all, there is public … Continue reading

Posted in data, Data Quality | Leave a comment

A Look at Data Professional’s Salaries

The annual ComputerWorld IT Salary Survey for 2017 was recently published and it contains a great wealth of interesting data. So, as I’ve done in the past, this post will summarize its findings and report on what is going on … Continue reading

Posted in data, DBA, salary | Leave a comment

Why isn’t e-mail more easily queryable?

Today’s blog post is just a short rumination on finding stuff in my vast archive of email… Do you ever wonder why e-mail systems don’t use database management technology?  Don’t you store some of your e-mails for long periods of … Continue reading

Posted in e-mail, SQL | 1 Comment

One of the Top Database Blogs on the Web

Very proud to announce that the Data & Technology Today blog was selected as one of the top 60 database blogs on the web by Feedspot. You can read all about it here – as well as learn about 59 … Continue reading

Posted in data | 1 Comment