Category Archives: database design

The Impact of Row Size on Query Performance

Posted on July 3, 2023 by craig@craigsmullins.com

As part of my job as a database consultant, I regularly keep my eyes open for interesting topics in relevant blogs and forums. Recently, one interaction caught my eye, where somebody asked what kind of a performance impact could be … Continue reading →

Posted in database design, performance, SQL | Leave a comment

Strategies for Managing Database Growth and Scalability

Posted on May 27, 2023 by craig@craigsmullins.com

Managing database growth and scalability is crucial to ensure optimal performance and accommodate increasing data volumes. Here are some strategies to consider: Remember that the best strategies for managing database growth and scalability may vary depending on your specific database … Continue reading →

Posted in capacity planning, data availability, Data Growth, database design, maintenance, performance, scalability | Tagged , , , , | Leave a comment

New Features in Navicat Data Modeler 3.0

Posted on September 26, 2019 by craig@craigsmullins.com

Before implementing a database of any kind, a sound model of the data needs to be developed. This process, known as data modeling, requires an analysis of the things of interest to your organization and how those things are related … Continue reading →

Posted in data modeling, database design, DBA | Leave a comment

Navicat Enables DBAs to Adopt Modern Platforms and Practices

Posted on January 31, 2019 by craig@craigsmullins.com

Database administration is a tried and true IT discipline with well-defined best practices and procedures for ensuring effective, efficient database systems and applications. Of course, as with every discipline, best practices must constantly be honed and improved. This can take … Continue reading →

Posted in cloud, database design, DBA, mobile, SQL | Leave a comment

Common Database Design Errors

Posted on January 14, 2019 by craig@craigsmullins.com

Before we begin today’s blog post, wherein I explain some of the more common mistakes that rookies and non-database folks make (heck, even some database folks make mistakes), I first want to unequivocally state that your organization should have a … Continue reading →

Posted in data, data modeling, database design, DBA | Tagged | 2 Comments

Data Modeling with Navicat Data Modeler

Posted on October 16, 2018 by craig@craigsmullins.com

Data modeling is the process of analyzing the things of interest to your organization and how these things are related to each other. The data modeling process results in the discovery and documentation of the data resources of your business. … Continue reading →

Posted in data modeling, database design, DBA | 2 Comments

Don’t Forget the Free Space

Posted on June 25, 2018 by craig@craigsmullins.com

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

Supporting Multiple DBMS Products with Navicat Premium

Posted on March 16, 2018 by craig@craigsmullins.com

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

The Lifecycle of Data

Posted on September 29, 2015 by craig@craigsmullins.com

Most data is not static. No, data has a life in which it changes, is used for perhaps multiple purposes, and gets moved all over the place. So it makes sense to think about the lifecycle of your data at … Continue reading →

Posted in archive, compliance, data, database design, information, operational, reference data, tools | 1 Comment

Database Capacity Planning

Posted on September 22, 2015 by craig@craigsmullins.com

Most database implementations are anything but static. Once deployed, databases are queried, updated, loaded, unloaded, reorganized, and data is deleted and inserted from them on an ongoing basis. And data may be replicated to and from the database on a … Continue reading →

Posted in capacity planning, database design, DBA | 2 Comments