Author Archives: John Morehouse

T-SQL Tuesday #91 – Start Talking

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 … Continue reading

Posted in General Conversations | Tagged | 3 Comments

I’m Speaking! Capital Area SSUG

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 … Continue reading

Posted in Presenting | Tagged | Leave a comment

Reverse It

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 … Continue reading

Posted in Administration | Tagged | Leave a comment

Ola Hallengren: Output File

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 … Continue reading

Posted in Administration | Tagged | Leave a comment

Experienced DBA: Rookie Mistake

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 … Continue reading

Posted in Administration | Tagged | 7 Comments

Knowing the Options

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

Posted in Administration | Tagged | 2 Comments

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

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 … Continue reading

Posted in TSQL Tuesday | Tagged , , | Leave a comment

I’m Speaking! SQL Saturday #617 – Pensacola

A sneak peek at the session that I will be presenting at SQL Saturday 617 in Pensacola, Florida Continue reading

Posted in Community, Presenting | Tagged , , , | Leave a comment

SSIS – Adding Connections

Even the small things are worth sharing. Looking at a discovering a new way to add connection managers to a SSIS package. Continue reading

Posted in SSIS | Tagged | 1 Comment

Quick Script: Finding Specific Columns

A quick script that can help you to find columns of a certain pattern. Continue reading

Posted in T-SQL | Tagged | Leave a comment