Your Sheets are all Spread out

Wouldn't it be fitting if the term "spreadsheets" was derived from the notion of having sheets of rows and columns and important data strewn all over your desk? In many ways I already think of them in that way, mostly because spreadsheet users don't have database training. Such training is key to future uses and... Continue Reading →


Economies of Scale

Or how to design your database so it can be expanded, or scaled, in the future. Let's say your firm's data record is the owner, or the root, of your table hierarchy. There are two things you can do. First is to put a field into your primary table that points to the record indicating... Continue Reading →

The Royal Family

Probably the hierarchy most of the world is aware of. Well, here is another one, or at least a near limitless number of hierarchies. Your database structure. Between the relations in your data and the many lookup tables, a picture of your tables can appear quite ominous. It is essential that this organizational hierarchy be... Continue Reading →

The New Normal

Here's another reason why spreadsheets don't make the grade. Normalization. This is the practice of analysing sample data to determine whether or not a particular column or field should be 'off-loaded' to what we call a lookup table. I'll provide examples, but don't confuse this with our discussion of Relational. Relational is addressing the parent-child... Continue Reading →

It’s my Field of Work

As a designer of database applications I have plenty of tools and techniques at my disposal. One such item is the field. One might think of it as a spreadsheet column, only far more. Columns have several data types, but a database field has those and so much more. Though they may have text and... Continue Reading →

Grow up to be a Big Boy

Or act like a big boy now. A bigger company. Think for a moment of some of those tech-like data exercises that big companies have but you don't. Larger companies collect information on some aspects that may seem needless, but they do it to keep employee needs and safety in mind. Have you considered a... Continue Reading →

Simple is better

It's one thing to go nose to the grindstone building a data repository, but it's another to make something that no one can understand or even maintain. One of the first steps a professional developer takes is to simplify what once appeared complex. We have an advantage here because we come from the outside. Your... Continue Reading →

They do not care

Trying to find out what treasures you might store in the cloud is far beyond the provider's scope. The providers of cloud space are huge and don't care one bit about your small business secrets. Shame on you for thinking you are so important. They provide a valuable service. Take advantage of it or perish.... Continue Reading →

But My business is Different

Not so much. It's as different from others as it is the same. You all provide products or services. You have employees, expenses, assets, loans and customers. You also have a love of what you do, or you wouldn't be doing it. That is the downside. This deep seated personal belief that the culture you... Continue Reading →

Powered by

Up ↑