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

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 Cleveland) for their annual SQL Saturday. This will be… Read more

0 comments, 69 reads

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

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 it can be to get in person speakers.  Needless… Read more

0 comments, 265 reads

Posted in John Morehouse | Sqlrus.com on 12 July 2017

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

0 comments, 95 reads

Posted in John Morehouse | Sqlrus.com on 10 July 2017

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

3 comments, 710 reads

Posted in John Morehouse | Sqlrus.com on 13 June 2017

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 for the Capital Area SQL Server User group out of… Read more

0 comments, 128 reads

Posted in John Morehouse | Sqlrus.com on 12 June 2017

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 that reverses any string value.

For example, the phrase:

The…

Read more

0 comments, 182 reads

Posted in John Morehouse | Sqlrus.com on 6 June 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

0 comments, 2,028 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, 2,164 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, 171 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,610 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, 156 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, 175 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,187 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, 153 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, 167 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

6 comments, 353 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, 276 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, 283 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,152 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, 451 reads

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

Older posts