Author Archives: John Morehouse

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

I’m Speaking! Code PaLOUsa!

A look at the session that I will be presenting at Code PaLousa in June 2017. Continue reading

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

T-SQL Tuesday #89 – There is No Cloud

April’s T-SQL Tuesday blog. A look on how moving or not moving to the cloud affects my role as a database administrator. Continue reading

Posted in TSQL Tuesday | Tagged | 1 Comment

Schedulers To Rule Them All

A look at an issue I discovered with SQL Server 2012 Enterprise Edition ISO that was installed. Continue reading

Posted in Administration | Tagged | 6 Comments

May MVP – Bob Pusateri

A look at my May nomination for the Microsoft MVP aware, Bob Pusateri Continue reading

Posted in Community | Tagged | Leave a comment

I’m Speaking! SQL Saturday #548 – Kansas City

I quick look at the presentation that I’ll be delivering at SQL Saturday #548 in Kansas City, Missouri Continue reading

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