John Morehouse

I’m Hosting! Idera July #sqlchat

On July 10, 2017October 8, 2017 By John Morehouse

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 19th at 11:00AM CST for Idera’s #sqlchat on Twitter!! We […]

T-SQL Tuesday #91 – Start Talking

On June 13, 2017October 5, 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 […]

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

Azure VPN – Point to Site IP Addresses

Mobile Azure

Building a Personal VPN Azure Solution

Azure Networking: Designing for Change

Exploring the Next Gen General Purpose Tier in Azure SQL Managed Instance

Implement a RAG Solution Using Azure SQL Database

Getting Started with Azure SQL Database – A Beginners Guide