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: February 2018

Finding Composite Primary Key Columns

You never know when the idea for a script will make an appearance.

I had to work with composite primary keys recently while working on a project for a client.  More specifically, I had to create a process that would dynamically (dynamic SQL?! Say it isn’t so?!) handle composite keys… Read more

5 comments, 1,994 reads

Posted in John Morehouse | Sqlrus.com on 23 February 2018

Backup & Restore Script with a Move

Ok, I’ll admit it. I like scripts that are handy and do things.  Especially if the scripts make my life easier.

Now, not every environment is the same.  Instances get configured differently or things change just due to the nature of the business.  In a previous life I would routinely… Read more

1 comments, 1,900 reads

Posted in John Morehouse | Sqlrus.com on 16 February 2018

4 Rules of Right When Running a Query

Last month in January, I participated in the Idera #sqlchat.  This is a monthly chat meeting that is organized by Idera Software and hosted by a SQL Server community member. This one was hosted by Monica Rathbun (B|T) and her topic for the month was “SQL Server Bad Habits in… Read more

2 comments, 2,823 reads

Posted in John Morehouse | Sqlrus.com on 9 February 2018

Trello – Integrations

In December I wrote about working from home in which I talked about Trello.  Trello is a virtual kanban board that allows me to visually manage projects & tasks.  As a follow up, I subsequently did a post where I talked about Trello more in-depth and how to use it.… Read more

0 comments, 245 reads

Posted in John Morehouse | Sqlrus.com on 2 February 2018