Monthly Archives: May 2018

Getting All Users

Posted on May 15, 2018 by way0utwest

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 , | Comments Off on Getting All Users

Reaching the Refactoring Redoubt with #SQLPrompt

Posted on May 14, 2018 by way0utwest

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 , , | Comments Off on Reaching the Refactoring Redoubt with #SQLPrompt

Interviewing Avatars

Posted on May 11, 2018 by way0utwest

Imagine that you go to interview a candidate over Skype or even a phone call and the first thing you see or hear is: “Hi, my name is Hank, and I am an avatar. I will answer all your questions … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Interviewing Avatars

Finding Tabs in SSMS–#SQLNewBlogger

Posted on May 10, 2018 by way0utwest

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 , , | Comments Off on Finding Tabs in SSMS–#SQLNewBlogger