Author Archives: Johnny

Cardinality: The Power of Leverage and how to use it in your business.

Cardinality is the “lever” of relational databases. It’s what allows one table to “relate” to another table. The classic example is to think of a customer table and a sales order table. One customer may have several orders. However, you don’t want to have to repeat all the information about that customer on every sales order. Continue reading

Posted in Best Practices | Leave a comment

Critical Point When Presenting to Managment

When presenting to management, you need to consider these critical keys. Continue reading

Posted in Best Practices, Presentations, Video | Leave a comment

3 Amazingly Simple Techniques To Accomplish Your Goals

Here are three amazingly simple, yet unbelievably powerful, techniques that will help you keep your resolutions. Continue reading

Posted in Best Practices | Leave a comment

Reconciliations: From raw to report

It’s 2am and you’re reconciling data. Something’s off, and it’s hard to tell where. I wrote about how to cut data reconciliations by 90% before, but here’s a different spin on reconciliations: look at it from creation to display. What you need to do is jump from the end of the problem to the beginning of the problem. Here’s my suggestion on how to do this: Continue reading

Posted in Best Practices, Excel | Leave a comment

7 Steps That Save You Hours of Troubleshooting

The Open Systems Interconnection (OSI) model is used all the time, we just don’t think about it in these terms. While there are 7 layers to the model we don’t always need to use all of them. Using the process is what is most important Continue reading

Posted in Best Practices, Excel | Leave a comment

Certified Bull

A certification seal for bull. Use it in PowerPoint presentation or Word and Excel documents. Continue reading

Posted in Best Practices, Communication, Presentations | Leave a comment

What Major Company Online Privacy Changes Mean For You

Our currency in an online environment is our behavior tracking. Where we go online, what we buy, who we buy from, who we are connected with, and what we think about brands/companies/issues are what we pay with in exchange for free searches, social networking, and entertainment. Continue reading

Posted in Best Practices, Communication | Leave a comment

2011 Was About Changing Your Mind

2011 was about changing your mind. Why the change? What happened that caused this change? Are we getting to a point in business where we’re being transparent with our customers, and as a result we see what’s normally been discussed behind closed doors? Continue reading

Posted in Best Practices, Purpose | Tagged , , , , , | Leave a comment

How to learn faster and get up to speed

YouTube is an amazing tool for learning languages and programs. A perfect example is SteveFox1973 who makes basic Microsoft’s Sql Server Integration Services (SSIS) videos. Continue reading

Posted in Best Practices, Video | Leave a comment

The First Rule When Networking With People

Networking with people can be either a huge amount of time, a drain on the other person, or something mutually beneficial. Learn the first rule in networking to start things off right. Continue reading

Posted in Best Practices, Communication, Presentations | Leave a comment