Tag Archives: administration

Servicing SQL Server in the Future

Posted on January 28, 2014 by way0utwest

Service Packs have become the way that many of us patch the various Microsoft products we use. Many administrators find patching to be time consuming and difficult to justify, even for security patches, and as a result, often wait for … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Servicing SQL Server in the Future

Management at Scale

Posted on January 27, 2014 by way0utwest

Would you like to manage 20,000 databases by yourself? What about 20,000 instances? It’s not quite the same thing, but Facebook recently announced that each of their data center operations staff manages 20,000 servers. That’s an impressive number, and it comes about … Continue reading →

Posted in Editorial | Tagged | Comments Off on Management at Scale

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)