Author Archives: John Morehouse

I’m Speaking! SQL Saturday #653 – Columbus

I’ll admit it, every time I think of Ohio I have flashbacks to the Drew Carey show.  The show was set in Cleveland, Ohio.  Don’t ask me why. I’m excited that this weekend, I’ll be traveling to Columbus, Ohio (not … Continue reading

Posted in Presenting, SQL Saturday | Tagged , , | Leave a comment

I’m Speaking! Evansville Technology Group

SQL Server user group is a backbone of the SQL Server community.  I currently help run the Louisville SQL Server user group and prior to that I ran the Omaha SQL Server user group for many years.  I know how difficult … Continue reading

Posted in Presenting | Tagged , | Leave a comment

I’m Hosting! Idera July #sqlchat

Have you heard of these following terms and/or phrases? Database Continuous Delivery Database Lifecycle Management (DLM) DevOps [Insert other buzzword bingo entry here] You probably have.  Even if you haven’t, let’s chat about it!! Come join me on Wednesday July … Continue reading

Posted in Community | Tagged | Leave a comment

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 | 1 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