Monthly Archives: November 2017

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

Adding a Format SQL Button to the Redgate Toolbar

Posted on November 14, 2017 by way0utwest

I’ve gotten used to CTRL+K,Y to format SQL with SQL Prompt, but a customer wanted a button on the toolbar. It’s fairly easy to do, but I thought I should document the process for others. First, if you click the … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Adding a Format SQL Button to the Redgate Toolbar

In a basement, a long, long time ago… #tsql2sday

Posted on November 14, 2017 by way0utwest

It’s T-SQL Tuesday time and this is a good one. Read the invitation and proceed. Who Influenced Me? I’ve been working SQL Server for a long time. Since 1991, in fact, and had held 4 jobs as a DBA or … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

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