Tag Archives: sql server

Restoring a Copy Only Backup–#SQLNewBlogger

Posted on December 27, 2017 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. There was a question posted recently at SQLServerCentral about whether a copy only backup could be restore with a … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on Restoring a Copy Only Backup–#SQLNewBlogger

Not Useless Features

Posted on December 1, 2017 by way0utwest

Some time ago I noticed Adam Machanic had written a post titled The SQL Hall of Shame. In it, Adam notes there are features that Microsoft will introduce in SQL Server and then let die. These are the useless features that … Continue reading →

Posted in Editorial | Tagged | Comments Off on Not Useless Features

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

Changing the Default DB for a Login–#SQLNewBlogger

Posted on November 13, 2017 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Recently I got into a bit of a pickle. I was detaching some databases for a demo, which is … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Changing the Default DB for a Login–#SQLNewBlogger