Monthly Archives: November 2017

One More Trip and Down for the Count

The last month has been a rough one for me, with lots of travel. I was on trips for 4 out of the last 5 weeks, and the week I was home I had a remote presentation to do. Travel … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Keeping the Single User Connection

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 , | Leave a comment

Adding a Format SQL Button to the Redgate Toolbar

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 , , , | Leave a comment

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

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 , , | 1 Comment

Changing the Default DB for a Login–#SQLNewBlogger

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 , , , | Leave a comment

How Long Before You Upgrade?

This editorial was originally published on Apr 11, 2014. It is being re-published as Steve is out of town, with a few minor changes to dates and values. It’s 2017. SQL Server 2000 is 17 years old, but there are … Continue reading

Posted in Editorial | Tagged | Leave a comment

Should We Move to Azure?

This editorial was originally published on May 23, 2014. It is being re-published as Steve is out of the office, with a few minor editorial changes. Update: We made a number of changes last year, upgraded the forums, and have continued … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Off to DevOps East

The travel countdown is down to 2 trips this year. The second to the last is this week, as I’m off to DevOps East, a conference in Orlando, FL that tries to bring together lots of DevOps experts and advocates … Continue reading

Posted in Blog | Tagged , , | Leave a comment

ROLLing UP Totals–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was editing an article recently that talked about ROLLUP, and I wanted to play with this a bit … Continue reading

Posted in Blog | Tagged , , | 2 Comments