Tag Archives: administration

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

Enabling Database Containment for an Instance – #SQLNewBlogger

Posted on October 4, 2017 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it. I wanted to … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on Enabling Database Containment for an Instance – #SQLNewBlogger

Remove an Active Lease on a Blob in Azure

Posted on September 12, 2017 by way0utwest

I was creating and dropping VMs in Azure, and found myself charged money for disks that I thought I’d deleted. I found later that deleting a VM doesn’t necessarily remove the disk blob. Here was one way that I removed … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Remove an Active Lease on a Blob in Azure