Tag Archives: sql server

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

A Tour of SQL Server Security Features

Posted on October 18, 2017 by way0utwest

Abstract Protecting data from unauthorized access becomes more important all the time. SQL Server includes a number of features that make data protection and security easier for developers and DBAs with a framework for protecting data. Come learn how Always … Continue reading →

Posted in Presentations | Tagged , , , , | Comments Off on A Tour of SQL Server Security Features

No More Service Packs

Posted on October 3, 2017 by way0utwest

The new servicing model for SQL Server is out, with a great explanation from Glenn Berry (there’s also a webcast). The summary is that going forward with SQL Server 2017, we won’t get Service Packs anymore. I’m somewhat sad, as I was always looking … Continue reading →

Posted in Editorial | Tagged , | 1 Comment