Tag Archives: administration

Global v Session Trace Flags

Posted on March 16, 2017 by way0utwest

I wrote a short article on enabling and disabling trace flags. You can read it, but I didn’t really discuss the implications of session v global trace flags, which is something I’d like to do here. In the article, I … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Global v Session Trace Flags

Backups Aren’t Backups Until a Restore Is Made

Posted on February 8, 2017 by way0utwest

One of the interesting things I saw in the recent GitLab outage and data loss was the fact that none of their backups were available. They use PostgreSQL and I’m not familiar with the ways in which the modern PostgreSQL … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Backups Aren’t Backups Until a Restore Is Made

The War Room

Posted on January 25, 2017 by way0utwest

I remember the first time I worked in a large, 10,000+ employee company, and we had a crisis with our systems. A number of us crowded into the cold computer room, gathering around a few workstations and trying to solve … Continue reading →

Posted in Editorial | Tagged | Comments Off on The War Room

Easy Database Space with dbatools

Posted on January 6, 2017 by way0utwest

One of the things that I’ve seen DBAs query for is free space in a database. In fact, this is one of the most common questions posted on SQLServerCentral by newbies that are trying to manage their instances and ensure … Continue reading →

Posted in Blog | Tagged , , , | 7 Comments