©andryone
We backup data to be safe from hardware failure or data corruption. But when we loose the backups we have just shot ourselves in the foot. This last week two subpoenas were issued to Webster Bank and Wachovia in connection with some lost tapes that had “data from millions of customers”. The tapes in question [...]

[Read more →]

©cogdogblog
How many do I have? Do I have at least one? What’s the greatest? What’s the least? Give me the top 5 rows. These are just some of the types of questions that are often asked when trying to evaluate table data.

Many of the problems I see in answering reporting questions, and everyday DBA work, [...]

[Read more →]

©cogdogblog
As your database grows so will the need to get information from more than one table. This article shows you the different join options and some simple examples to raise your familiarity.

Wouldn’t it be nice if every piece of data were stored in one table? Well this is obviously never going to happen. The simple [...]

[Read more →]

©azrainman
Isn’t it always the case. Someone gets caught or put under the spotlight and THEN something gets done. It’s no different for the high ranking U.S. Health officials. After taking a lashing for not finding problems with drugs or medical devices quick enough they have sought the help of a data system called Sentinel.

Sentinel will, [...]

[Read more →]

©cogdogblog
We do not always want to SELECT everything from a table. The matter of finding the information required is a function of implementing the optional WHERE clause of the SELECT statement.

In the previous Part II of this series we took a look at the “simple SELECT’ statement. This involved the four required pieces of a [...]

[Read more →]

©terren in Virginia
What goes around comes around. I don’t think it is much different in the personal computing space than the enterprise space. For enterprise systems we tend to de-centralize then centralize, just long enough to catch our bearings then we de-centralize again.

The WSJ had an interesting article on the next gadgets Apple might be [...]

[Read more →]

©cogdogblog
Most often we query information from a database where that information is stored inside a table structure. Most explain a table as a series of rows and columns. Much like a spreadsheet where the spreadsheet is the TABLE, each line (horizontally down the page) in the spreadsheet is considered a ROW, and then sets of [...]

[Read more →]

©MACSURAK
Did you know that, as reported in WSJ:

70% of the Internet users in the U.S. are over the age of 30?
70% of the Internet users in China are UNDER the age of 30%.
In the US, people spend their time composing e-mail messages and using the Internet for searching for information.
In China, people spend their time [...]

[Read more →]

©cogdogblog
The spelling is so easy and even rolls off our lips with simplicity. The fact of the matter is this language has caused more agony than one can imagine. I get dozens of emails and forum posts every week, wanting to know how to extract or insert data from a RDBMS.

Developers I have worked with [...]

[Read more →]

©Will Palmer
I just finished reading an article in the WSJ titled ‘Competitive Approach Taken to Outsourcing’.
The first question that crossed my mind was: When is any business venture NOT competitive?

The article goes on to make some very interesting points:

In 2003, 70% of all outsourcing was given to US service providers
In 2006, GM restructured its use [...]

[Read more →]