John Morehouse

I’m Speaking! Capital Area SSUG

On June 12, 2017June 12, 2017 By John Morehouse

I like it when I get referred to speak at various functions. Whether it’s a user group, conference or just something informal, I really enjoy speaking (yes, I’m crazy) and giving back to the community. This time I’ll be speaking for the Capital Area SQL Server User group out of […]

Reverse It

On June 6, 2017May 30, 2017 By John Morehouse

Recently I had a conversation with a colleague that wasn’t aware of the REVERSE function in SQL Server. I had sent them a code snippet and they inquired as to what the purpose of the function was. Essentially, this function that reverses any string value. For example, the phrase: The […]

Ola Hallengren: Output File

On May 30, 2017May 30, 2017 By John Morehouse

I’m a huge fan of Ola Hallengren‘s free utility scripts. If you aren’t familiar with it, it’s a great tool to manage backups, index maintenance and the overall health of your SQL Servers. It is utilized around the globe and it is completely free. Although his script is very thorough I […]

Experienced DBA: Rookie Mistake

On May 23, 2017May 23, 2017 By John Morehouse

M.A.S.H 4077. Mobile Army Surgical Hospital. One of my all time favorite TV shows that I still watch to this day. There is one episode that has always stuck with me is one where Hawkeye has to deal with death of a friend during surgery. Afterwards, Colonel Blake imparts advice […]

Knowing the Options

On May 16, 2017May 16, 2017 By John Morehouse

Quick look at @@options and a script that will be a little more useful to see what options are enabled for your current session.

T-SQL Tuesday #90 – The Elephant’s Name is Database

On May 9, 2017May 10, 2017 By John Morehouse

T-SQL Tuesday is a monthly blog gathering for the SQL Server/Data Professional community It is the brainchild of Adam Machanic (B|T) and is not limited to just things around the SQL Server database engine. Each month a blogger hosts the event and anybody who wants to contribute can write a post about that […]