In my previous article I discussed the fundamentals of SQL and provided an overview of SELECT, the first of the four main SQL commands. In this article, I will cover some beginner/intermediate topics:

• Sub-queries
• Joins
• Table Creation

You need to learn SQL, not tomorrow, not in a few hours. You need to learn SQL right now! The good news is SQL, which stands for Structured Query Language, isn't that hard to learn.

I come across all these beautiful articles around the Internet of Things (IoT) filled with graphics, network diagrams, and a generic finger reaching out to touch some translucent screen in the distance. As if a finger, some Adobe Photoshop items, and a network diagram are all we need to make the IoT work...

It's been a while since I last posted and I have been up to quite a bit. One of the areas I have dug into is Healthcare Information Systems. In the past I mainly interacted at the facilities level so to gain visibility into what happens on the clinical and surgical side of the business has been quite interesting. In this post I am going to pull back the curtains on HL7 (think XML for Healthcare) and describe the various aspects of healthcare informatics! Are you ready to learn all you need to know about HL7 and Healthcare Informatics?

Big Data is in the vogue. As a business leader, technology enthusiast, or aspiring technologist you need to be aware of the different database technologies what they can accomplish and how they align with your business needs. This article is by no means an exhaustive look at databases but rather a 30,000 foot flyover to help you familiarize yourself with an ever-expanding solution set. This was originally going to be called 5 database technologies in 5 minutes but the article started to get really large and I decided to split the article up.

I just finished reading two interesting articles about hacking BAS systems and thought I would share my thoughts with all of you on how a BAS could be used to hack a building. First off, we still have some educating to do around BAS as a whole in the industry. Reading through Brian Prince's article at Dark Reading titled Google Building Management System Hack Highlights SCADA Security Challenges brings to mind one of the first areas in which we need to educate our IT counterparts.

Networks, they are the lifeline of modern systems and they are the bane of many owners and contractors! I'm not going to solve world hunger with this article but I will promise that you will leave here with a the Network Fundamentals that you need in order to do your job!

Identifying Your Network Needs

When someone purchases an automobile, they usually do so to meet a specific need. The same is true with a network. This article gives you the top 5 areas to consider when performing network design: