My role is defined as Data Architect. What that means and what it is are two different things. I perform server monitoring and maintenance on SQL 7.0 and 2000...

Well..... Did you get those jobs?

My toughest interview was tough not because of the tech side but the management side. I was being laid off from a company in...

On normalization, he couldn't give a simple definition. He didn't recognize the terms first normal form, second normal form or third normal form.

Ergo, he couldn't explain denormalization.

He...

There are a number of good resources available for database design. Joe Celko's Data & Databases is my personal favorite. There is an excellent list at www.dama.org in...

Andy,

I have seen statistics that indicate the performance of clustered server will increase as the queries are shared across multiple servers. I would be interested in knowing whether...

We use view extensively for this scenario. Often time we find that the subquery is needed in other areas. Also, you get the benefit of being able to...

JMail rocks!

Though I hate using cursors, You could do os in this instance. If the I/O between the ASP and SQL server is too expensive, you could try a server...

I'm an employer and I recently interviewed a good looking candidate. His resume said all the right things. He indicated that he was a MSCD and MSDBA. Someone...