Category Archives: Blog

One Week to Music City Tech

Next week is Music City Tech, a three day conference consisting of Coding, Agile, and Data tracks, takes place in Nashville on May 31-June 2. There are a lot of great sessions on the schedule, covering a lot of software … Continue reading

Posted in Blog | Tagged , | Leave a comment

Jobs in PoSh to Create a Load

I saw this from Argenis Fernandez, and thought it was wonderful. 1..128 | % { start-job -name ‘job name’ -scriptblock { & sqlcmd -S instanceName -U sa -P ‘iLovePoSh’ -i /home/username/test.sql } } Create 128 threads, each running a background … Continue reading

Posted in Blog | Tagged , | Leave a comment

Update Oddness for SQL Server

I’ve been meaning to patch some of my development instances. With a little spare time while doing other work, I started the process the other day. My first step was to patch SQL Server 2016 with SP2. This went as … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Ten Years at Redgate

This year was my 10th anniversary of working for Redgate. The actual date was a bit ago, but they held off my celebration until I came over. These are nice at Redgate, better than at some companies where I’ve seen … Continue reading

Posted in Blog | Tagged | 3 Comments

Music City Data

I’ve never spoken in Tennessee. I’ve wanted to visit, but the I’ve only managed to drive through a part of the state or transfer in the airport. That changes at the end of this month. Music City Tech, a three … Continue reading

Posted in Blog | Tagged , | Leave a comment

Getting All Users

I saw someone that wanted to get all users from all databases on their instance. Seems like that ought to be simple, right? The user wanted to use sp_MSforeachdb to query users, but wanted a single result set for all … Continue reading

Posted in Blog | Tagged , | Leave a comment

Reaching the Refactoring Redoubt with #SQLPrompt

I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes and go through it. I wrote about Code Snippet Cove first, and this post finishes my movement around the map. … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Finding Tabs in SSMS–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Someone posted this as a question and I thought it was worth noting. I use SQL Prompt for formatting, … Continue reading

Posted in Blog | Tagged , , | Leave a comment

First Wave of Sessions for PASSSummit Now Available

The first wave of sessions for the #PASSSummit have been released. You can see the list at: http://www.pass.org/summit/2018/Learn/ConferenceSessions.aspx I am honored to have a session on the list. This year, I’ll be doing a session called Minimizing the Impact of … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Relaxing on the Tab Management Terraces with #SQLPrompt

I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes and go through it. I’ve written about a few of the other items on the map: Code Snippet Cove Trekking … Continue reading

Posted in Blog | Tagged , , | Leave a comment