Tag Archives: administration

Adding Performance Counters back for SQL Server

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

“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

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

Why Does My Log Grow–SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is a great topic, and really, every DBA or admin should blog this and be sure they understand … Continue reading

Posted in Blog | Tagged , , | Comments Off on Why Does My Log Grow–SQLNewBlogger