Think it’s time for a change?

I have mentioned it before and I really need to do it again...  using spreadsheets to house your data, even in the cloud, is no way to run a business. I have documented many ways in which your data-integrity suffers as much as your users do. I have explained, in simple terms, the ins and outs of... Continue Reading →


Learn to Walk before you can Run

There may be a concern regarding any new undertaking, especially one that is not in your primary area of expertise. Let me assure you that I understand this, having been a business owner myself, and that there are ways to structure efforts according to your appetite. Here are the steps we would tackle for any... Continue Reading →

I hate this rush on garbage day!

Not to be confused with Garbage in = Garbage out. Typically, dry waste comprises about 90% of non-recyclable material comes garbage morning. Why then is this such a stressful event? Think about it. Use LOGIC! If staging the dry garbage into the garage is annoying but a routine then do it earlier. Hours or days... Continue Reading →

This expression was common in offices around the turn of the millennium. It referred to the notion that even with a  database system running (in) your business, if the wrong data is entered, the result will be erroneous, misleading, corrupted or just plain garbage! This is where the novice gets into trouble. Even a simple,... Continue Reading →

Make a mountain out of a molehill

That could be your business, and should be. Your company started from a seed, an idea. If it is worthy, it should grow larger. The soil supporting that growth is your information, your business data. However, and sorry for more analogies, think of all your hard work as the watering can. Without the soil to... Continue Reading →

I’ma gonna schema to helpa you succeed

My apologies to the Italian community. I mean no disrespect. I just needed a lead in. Anyway, rather than describing what a Schema is in database terms I will borrow a definition courtesy of Wikipedia: "In psychology and cognitive science, a schema (plural schemata or schemas) describes a pattern of thought or behavior that organizes categories of... Continue Reading →

Programming your DVR is not the same

Aside from a language strictly used for semi-layperson access to most relational databases, which is called Structured Query Language (SQL), custom database systems and any systems involving a user interface, use Programming. Programming Languages come in many forms and have steep learning curves, but their common purpose is to calculate, direct computer resources, manipulate the... Continue Reading →

How to secure your 45s and LPs

It's called Record Locking, and one of the main benefits of using a Relational DataBase as opposed to spreadsheets. With spreadsheets sharing among users is tenuous at best. In order to ensure any data integrity, the whole file must be locked when one person is making a change, and it won't matter if it was... Continue Reading →

And now for a triple threat, the RFQ.

This should be easy for a business person to remember, however, in this case it doesn’t mean Request For Quotation. Let’s say you are using a spreadsheet, and you don’t want to see all of the client list, but only those who live in Albany, NY. You invoke the Filter option. In addition, you can... Continue Reading →

Powered by

Up ↑