-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

John Morehouse | Sqlrus.com

John Morehouse is currently a Database Architect with Farm Credit Mid-America out of Louisville, KY. He is a blogger, avid tweeter, and a frequent speaker at SQL Saturday's as well as other conferences. He is also heavily involved with the Professional Association of SQL Server (PASS). In his spare time, you can usually find John reading up on SQL Server topics as well as chasing his two boys around the house.

Archives: May 2017

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 is completely free.

Although his script is very… Read more

2 comments, 2,680 reads

Posted in John Morehouse | Sqlrus.com on 30 May 2017

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 is completely free.

Although his script is very… Read more

2 comments, 206 reads

Posted in John Morehouse | Sqlrus.com on 30 May 2017

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 of a friend during surgery. Afterwards, Colonel Blake imparts advice… Read more

7 comments, 62 reads

Posted in John Morehouse | Sqlrus.com on 23 May 2017

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 of a friend during surgery. Afterwards, Colonel Blake imparts advice… Read more

7 comments, 2,339 reads

Posted in John Morehouse | Sqlrus.com on 23 May 2017

Knowing the Options

Have you every executed a query in SQL Server Management Studio, looked at the execution plan, and noticed that it was a different plan than what was generated on the server?

A potential reason for this could be a different option settings.  The options represent the SET values of the… Read more

3 comments, 332 reads

Posted in John Morehouse | Sqlrus.com on 16 May 2017

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 anybody who wants to… Read more

0 comments, 1,999 reads

Posted in John Morehouse | Sqlrus.com on 9 May 2017

I’m Speaking! SQL Saturday #617 – Pensacola

In early June, I’ll be traveling to Pensacola, Florida for their annual SQL Saturday. This will be my second time attending their event.  Last year was fantastic and I am looking forward to returning.

The sun, the beach, and of course SQL Server training! How can you beat a weekend… Read more

0 comments, 275 reads

Posted in John Morehouse | Sqlrus.com on 2 May 2017