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

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

5 comments, 128 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

2 comments, 124 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,247 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, 115 reads

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

SSIS – Adding Connections

Sometimes you get reminded that you don’t know everything about SQL Server and it’s various products Every time I run into something like this I am going to write a quick blog about it.  It’s something new I’m trying

While recently examining an existing SSIS package  before implementing some needed… Read more

1 comments, 126 reads

Posted in John Morehouse | Sqlrus.com on 27 April 2017

Quick Script: Finding Specific Columns

I like scripts.  Scripts that help me do things.

Working in the financial industry, there are always things that you have to ensure are protected.  More specifically, social security number and date of birth.

If your environment is like most, there are legacy applications that have a database behind the… Read more

0 comments, 1,068 reads

Posted in John Morehouse | Sqlrus.com on 25 April 2017

I’m Speaking! Code PaLOUsa!

This summer I’m going to try something a little different.  I’ll be speaking at a technology conference that is not specifically for SQL Server.  That’s right, I’m branching out.  But don’t you worry, I’ll still be talking about my favorite subject, SQL Server Internals!

So I’m happy to say that… Read more

0 comments, 120 reads

Posted in John Morehouse | Sqlrus.com on 18 April 2017

T-SQL Tuesday #89 – There is No Cloud

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

1 comments, 140 reads

Posted in John Morehouse | Sqlrus.com on 11 April 2017

Schedulers To Rule Them All

Sometimes things just don’t make sense.

One of our production servers has 4×8 (4 sockets, 8 core) processors with hyper threading enabled.  This results in 32 physical cores or 64 logical cores.  Therefore, this particular server should have 4 NUMA nodes available.

However, I was looking at the dashboard for… Read more

4 comments, 298 reads

Posted in John Morehouse | Sqlrus.com on 17 March 2017

May MVP – Bob Pusateri

Whoa. I’m way behind in my blogging.

For the month of May, my MVP choice is Bob Pusateri (B|T).

Bob is a SQL Server DBA that hails from the windy city of Chicago, Illinois. He is very active within the SQL Community as an avid speaker… Read more

0 comments, 243 reads

Posted in John Morehouse | Sqlrus.com on 6 October 2016

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

This weekend I’ll be traveling to Kansas City, Missouri for their annual SQL Saturday. This particular event is like going home for me as my first time speaking at a SQL Saturday was in Kansas City.

One of my favorite things about this event is the BBQ Crawl the organizers… Read more

0 comments, 253 reads

Posted in John Morehouse | Sqlrus.com on 22 September 2016

Quick Script – Finding Most Recent Backup

Recently I have had to restore a number of databases into our training environment.   Looking up each backup individually would be time consuming and I prefer to save time whenever possible.  So, instead of lookup up the backup for each database I needed, I thought a quick script would be… Read more

0 comments, 1,120 reads

Posted in John Morehouse | Sqlrus.com on 19 September 2016

April MVP – Chris Yates

The April MVP nomination is Chris Yates (B|T).

Chris is one of those individuals that always have a positive outlook on life which infectious.  He hails from Louisville, Kentucky and over the past year I’ve had the pleasure of really  getting to know him.   Chris has a serious passion about… Read more

1 comments, 410 reads

Posted in John Morehouse | Sqlrus.com on 28 April 2016

Changing Of the Guard

As many of you know,  I stay very active within the PASS community.  In late 2007 I got my start, when I helped to organize and the Omaha SQL/BI user group.  I am very proud to say that group is still going strong as of today.  Unfortunately, I had to… Read more

0 comments, 335 reads

Posted in John Morehouse | Sqlrus.com on 14 April 2016

March MVP – Gareth Swanepoel

The March nomination is Gareth Swanepoel (B|T).

If you don’t know Gareth you should make it a point to get to know him.  He originally hails from South Africa but now resides in the United States with his family.

Gareth is a frequent presenter in the… Read more

0 comments, 363 reads

Posted in John Morehouse | Sqlrus.com on 31 March 2016

Nothing To See Here

In a galaxy far, far, far away a developer of a third party application somewhere in the Hoth system had to implement cell level encryption for sensitive data.  Their weapon of choice was to do this utilizing C# code within SQL Common Language Runtime (CLR).  Though the galaxy is full… Read more

1 comments, 390 reads

Posted in John Morehouse | Sqlrus.com on 29 March 2016

February MVP – Melody Zacharias

The February MVP nomination goes to Melody Zacharias (B|T).

Melody hails from our neighboring country to the north, beautiful Canada. While we all joke Melody about her quick and frequent apologies (Sorri), she definitely has nothing to apologize for when it comes to her dedication to… Read more

0 comments, 282 reads

Posted in John Morehouse | Sqlrus.com on 17 March 2016

January MVP – Mike Fal

In case you missed it, back in November I blogged about the importance of nominating individuals within the SQL Server community for the prized Microsoft MVP award. I vowed, then,  each month to nominate one deserving individual.  This is the first of 12 nominations that I’ll be blogging about.  I… Read more

0 comments, 257 reads

Posted in John Morehouse | Sqlrus.com on 10 March 2016

Resolved: A Duty to Act

If you are a member of PASS, you probably got an email from our President, Thomas LaRock.  I interpreted his email as essentially a reminder that when attending PASS events we should all be professional and responsible for our actions.   The email was very well written and wasn’t pointed towards… Read more

5 comments, 416 reads

Posted in John Morehouse | Sqlrus.com on 25 November 2015

MVP of The Month

If you follow Grant Fritchey (B|T) at all, you know that every month he picks a “Speaker of the Month”.  Grant attends SQL events over the course of a month.  Out of all of the sessions he attends during that month, he will pick a winner… Read more

3 comments, 325 reads

Posted in John Morehouse | Sqlrus.com on 19 November 2015

Older posts