Tag Archives: administration

Common Checks

Posted on January 24, 2014 by way0utwest

One of the things that I recommend to DBAs is that as they write code to solve problems, they write some sort of check to catch future potential occurrences of the issue. For example, I worked with a product years … Continue reading →

Posted in Editorial | Tagged , , | 1 Comment

A Full Backup Includes Everything (with a caveat)

Posted on December 11, 2013 by way0utwest

Full database backups in SQL Server include all of the data, objects, tables, rows, functions, stored procedures, etc. If something is in the database when the data reading portion of the backup concludes, it’s in there. Note that “in there” … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on A Full Backup Includes Everything (with a caveat)

The Future of Auditing

Posted on December 5, 2013 by way0utwest

I was reading Captain’s Share the other day and enjoying a quiet afternoon at home. It’s a science fiction book about one man’s journey in the future as a captain of a space freighter. It’s an interesting series from Nathan Lowell that … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on The Future of Auditing

It Still Happens – Full Transaction Log

Posted on October 17, 2013 by way0utwest

Probably the most often asked question on SSC is about full transaction logs, and often full disks. It happened again recently. I don’t have an exact count of threads, but rough searches show this to have 70,000+ results, when most … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on It Still Happens – Full Transaction Log