Welcome to this new series -- in this column, I hope to impart some quick, short tips that will help you make quick work of managing and administering your SQL Server databases. First up is an ...

The design of a database determines what method is best suited for backing it up, and those methods vary quite a bit. In order to back up a database, you need to know how it’s delivered, but you also ...

A system failure wipes out all your data, corruption renders your data useless, an error leads to permanent deletion. Remember: Data loss always sneaks up on you. The ...