Tag Archives: administration

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

Renaming MDF/LDF Files–SQLNewBlogger

Posted on June 15, 2017 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I would guess many people would run into this situation at some point. A developer or DBA creates a … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Renaming MDF/LDF Files–SQLNewBlogger