SQL Server is one of the best products to come out of Microsoft, but not every professional knows how to use it effectively. For example, some might find it difficult to create a stored procedure but ...

I'm doing some development on a dev server of ours for a site that's currently live on another server. They have their own server with a SQL Server database holding the data for the live site. So as ...

Ok, I'm at a client site where they want to make a program database independent. This is a rewrite of an existing program that used an Access database only. I asked the person in charge how they were ...

Microsoft has released the second beta of SQL Server 2005, and it looks to be a major step forward. DTS (Data Transformation Services) has been completely rewritten for this release, bringing tons of ...