Tag Archives: administration

Lowering the Noise

Posted on January 30, 2018 by way0utwest

Over my career, I’ve had the chance to work in a variety of environments of all sizes. I’ve managed systems that powered all sorts of applications, with a variety of requirements. In many cases, I’ve had certain databases that needed … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Lowering the Noise

Are You Always Up?

Posted on January 26, 2018 by way0utwest

I’ve had the opportunity to work for and with quite a few companies in my career. In some sense working as a database developer or database administratrator is very similar at many places. The “job’s the job,” as I’ve said … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Are You Always Up?

Disable or Drop

Posted on January 12, 2018 by way0utwest

When I started working with SQL Server and Windows, it seemed that the administrative side of many actions was limited. We could add and drop many items, but that was it. Relatively few tools allowed setting limits or disabling them, … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Disable or Drop

Keeping the Single User Connection

Posted on November 16, 2017 by way0utwest

A reader was having issues with a script. They ran their code from PoSh (Invoke-Sqlcmd), setting single user and then trying to rename a database and its files. However, occasionally, they’d lose the single user connection to another user. Frustrating, … Continue reading →

Posted in Blog | Tagged , | Comments Off on Keeping the Single User Connection