Tag Archives: administration

Database Mirroring Needs FQDNs

Posted on July 3, 2017 by way0utwest

A quick basic post, and one that I’ve forgotten. Since blogging is a good way to remind myself of things, here goes. I was testing Database Mirroring (DBM) recently for an upgrade situation. I’ve set up it up in the … Continue reading →

Posted in Uncategorized | Tagged , , , | Comments Off on Database Mirroring Needs FQDNs

Handling Data Corruption

Posted on June 29, 2017 by way0utwest

I wrote about dealing with data loss recently, ansking what your plans are for a situation. Some of you might rely on digital systems, some rely on humans, and some just accept some data loss. All of those are valid … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Handling Data Corruption

Adding Performance Counters back for SQL Server

Posted on June 26, 2017 by way0utwest

I had a strange situation the other day, where a number of things went wrong with my instance. First, I lost permissions to detached databases. The SID was listed in the file permissions, but apparently unlinked to an account. Next, … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Adding Performance Counters back for SQL Server

The Need for DRE

Posted on June 17, 2017 by way0utwest

“Today’s database professionals must be engineers, not administrators” That’s a quote from an interview at O’Reilly on Database Reliability Engineering. I don’t want to quibble about whether those of us working in technology are engineers in name or not, but … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on The Need for DRE