Microsoft has made some big promises for SQL Server 2008, a major update of its enterprise database product. Here's an outline of the key new features.

Normalization is one of the commandments of IT database pros, whether you are a data modeler, DBA, or SQL developer. Arthur Fuller defines each normal form and explores why most database designers ...

Hello,I have a few databases on a MSSQL 2005 server that where reloaded from backups from a SQL 2000 server a few month ago.Today, I noticed that these databases had a strange "status": "Shutdown ...

Our normal practices for backing up SQL servers is to use the regular SQL backup tools to perform full, differential and transaction log backups and this has always worked fine. Recently we ...