-->
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, 2,282 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, 2,085 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, 32 reads

Posted in John Morehouse | Sqlrus.com on 9 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,956 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, 303 reads

Posted in John Morehouse | Sqlrus.com on 2 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, 31 reads

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