Category Archives: Blog

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

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

DevOps Basics – Ignoring Files in Git

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it. One of the … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

Prepping for Summit 2017

It’s about time for the PASS 2017 Summit. The event essentially starts on Monday with pre-cons and the unofficial networking dinner. Be sure you RSVP and come to the dinner if you don’t have plans. The official event is Many … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Basic FORMATting– #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw the addition of FORMAT() to the T-SQL language, but didn’t play with it much. Recently it appeared … Continue reading

Posted in Blog | Tagged , , | Leave a comment