Data Definition Language (DDL) and Data Manipulation Language (DML) are statements used within the SQL Query Agent. DDL (such as CREATE, ALTER, RENAME) are used when defining the database’s structure/schema. DML […]

To query for a unique value, one would execute the following command

[ select distinct(field1) from TableName ]

Why oh why do we normalize data?

We normalize data because we can…. just kidding.

Normalizing data permits association within attributes and keys belonging to a database. By standardizing input and making […]

The Enron Situation was quite the scandal when I was a young chap. The executives decided it would be a great sneaky idea to “cook the books” so to speak. I personally prefer my books cooked medium rare but they […]

To attract and attain the most profitable customers, a business must have every single individual within the company on their “A-Game”. Workers need to be knowledgeable about their product and services, conduct themselves in a professional manner at all times and exemplify the quality worker. Products need to be constantly upgraded and developed…[Read more]

A Request for Proposal is a document used by organizations to open the doors for offers of services or goods from potential vendors. Although it is not a fully comprehensive solicitation, it gives the potential vendor enough information to entertain the idea of what type of products/services are needed and gives the customer an opportunity [...]

A database is a tool for collecting and organizing information which can be easily searched, accessed and updated whether manually or via automatic information systems (such as an inventory system). It’s purpose is to organize large amounts of information in a uniform and consistent manner. A data warehouse is created from multiple databases,…[Read more]

Business intelligence enables organizations to better respond to ongoing threats and opportunities to better plan for the future. Looking back upon history (not only in a business stance but from government decisions to individuals) is pertinent to learning from mistakes and reducing the frequency of failure. In today’s high tech, highly…[Read more]

Many governmental challenges arise as a result of globalization. When conducting business in a foreign country, one has to be aware of a multitude of operational and legal differences. From differences in laws to intellectual property rights (I’m looking at you China), a business has to always be thoroughly aware. Comity is vital for the [...]