Tag Archives: administration

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

Using xp_delete_file

Posted on October 9, 2017 by way0utwest

First, this is an undocumented proc, and there’s nothing in BOL on this. Second, it’s a holdover from previous versions, so you’d be better served by using Powershell or some other type of scripting mechanism. This procedure is not supposed … Continue reading →

Posted in Blog | Tagged , , | 2 Comments