Its gratifying to see that there are still some decent companies to work for in the IT industry. Far too frequently the decisionmakers have no concept of the true...

As long as the data can be unencrypted, it will be abused or hacked by someone. The only safe way to store it is with identifiers removed. The only...

You are looking to do a cross-tab query. If you have SQL Server 2005, you can use the PIVOT function. Use books online for examples. If you are...

Having hot-swapable equipment does not seem very cost effective for most environments. It sure would be nice for certain applications where downtime costs exceed hardware costs though.

I haven't used...

The problem with doing a good job is that often the people whom you do it for are unable to evaluate your performance with any accuracy. You are there...

This made me laugh out loud. Will have to pass this along to some of my colleagues.

Thanks

If money wasn't an issue, I would do volunteer work for a living. Perhaps teaching disadvantaged kids so that they would have some technical or other training that their...

Excellent article! I look forward to the next one in the series.

sounds like your real problem is the you need a unique index on the three columns to prevent future duplications.  There are several ways to do the deletion but what...

Are you trying to delete all of the rows that are duplicates or all but one?

leave out the *

After trying the sp_change_users_login, if the problem still exists, you may want to go into the services applet to see if any of the services needed by sql server are...

Generally speaking, the number of concurrent users supported by either product far exceeds the budget for licenses

This is one of the most useful articles I have seen here. Thanks

Karen Gayda

MCP, MCSD, MCDBA

I once worked for a company whose staff was so ignorant of database design they suddenly began getting errors on their website and could not understand why. They asked...