Pop describes a stored procedure for restoring the most recent full backup of a SQL Server database and then applying all transaction logs. Handy to have around in case of emergency...… Read more
Robyn Page's crib sheet was a Simple-Talk classic, providing a terse but thorough roadmap of all of the important SQL Server backup-related considerations. It returns, newly revised.… Read more
Find out about Database Snapshots, new to SQL 2005 Enterprise Edition, which provide a read-only, "virtual" copy of a database, at a given point in time.… Read more
This article discusses three common problems DBAs are likely to encounter when columns have an identity property that will auto-increment its value when data is inserted. These problems are humorously referred to as the identity crisis.
… Read more
In the race to secure data, encryption is often overlooked. Philip Basham takes a look at the ramifications of data loss and how it can be prevented.… Read more
What to do now that you’ve become an object of management’s attentions Judging by mainstream news coverage over the past few weeks, the issue of data theft, particularly loss of backup tapes, has reached the tipping point. It might mean that your relatively anonymous existence within your company could come to a screeching halt.Here are … Read more
Backup is good for you, like eating a good diet and getting exercise. Unfortunately, folks are about as successful with backups as they are with diet and exercise.… Read more