Tag Archives: sql server

It’s Time to Patch and Upgrade

Posted on January 5, 2018 by way0utwest

I don’t want to be chicken little here, but the Meltdown/Spectre bugs have me concerned. I don’t know the scope of the vulnerabilities, as far as exploits go, but I do know the lax ways in which humans interact with … Continue reading →

Posted in Editorial | Tagged , , | 2 Comments

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