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

Database Doing DevOps

DevOps.  It’s one of the latest buzz words in many technical communities.  Database Doing DevOps  This phrase, however, is NOT heard in many technical communities.

However, it really should be.  Databases doing devops is probably one of the hardest things to tackle in the DevOps world.  With hard work though,… Read more

0 comments, 154 reads

Posted in John Morehouse | Sqlrus.com on 30 March 2018

Community

Community.

In the SQL Server community, we are basically one big #sqlfamily.  This is a story of how the family helped one individual and one of the main reasons I am involved, to begin with.

Meet Jerad.

In happenstance, both our children attend the same school.  He happened to recognize… Read more

0 comments, 148 reads

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

SSMS Output Window

In my experience, there have been occasions where SQL Server Management Studio (SSMS) becomes unresponsive for a length of time. In one particular case, this occurred while I was expanding the list of databases.  SSMS just sat there and waited for some unknown reason and became frustrating. The client eventually… Read more

0 comments, 100 reads

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

Using SWITCH On A Single Partition

Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding how to move a large amount of data around quickly.  The solution was related to an aspect of table partitioning that I was not aware of.  If you aren’t… Read more

2 comments, 1,877 reads

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

Using SWITCH On A Single Partition

Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding how to move a large amount of data around quickly.  The solution was related to an aspect of table partitioning that I was not aware of.  If you aren’t… Read more

2 comments, 7 reads

Posted in John Morehouse | Sqlrus.com on 2 March 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,097 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,992 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,885 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, 4 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, 5 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, 259 reads

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

Javascript Postback Download via Powershell

Recently, one of my clients had a need to automatically download a file from a public facing state government website.  Normally this can easily be done in a manner of ways.  Powershell is the first that comes to mind but you could also utilize scripting tools such as wget or… Read more

0 comments, 367 reads

Posted in John Morehouse | Sqlrus.com on 26 January 2018

Javascript Postback Download via Powershell

Recently, one of my clients had a need to automatically download a file from a public facing state government website.  Normally this can easily be done in a manner of ways.  Powershell is the first that comes to mind but you could also utilize scripting tools such as wget or… Read more

0 comments, 7 reads

Posted in John Morehouse | Sqlrus.com on 26 January 2018

Implementing SSL for Your Blog

With the announcement of the recent security issues, namely Meltdown and Spectre, we at Denny Cherry & Associates Consulting have been focused on security awareness this entire week.  To further underscore it, we are hosting a Security Webcast today, Friday January 19th, 2018 at 2:00PM EST (11:00 AM PST).  Make… Read more

0 comments, 307 reads

Posted in John Morehouse | Sqlrus.com on 19 January 2018

Azure VPN – Point to Site IP Addresses

Recently, I got to work with a client on something interesting. We implemented transactional replication to send data to an Azure virtual machine.  This was being done to perform some testing for a project.

Given that the two machines were NOT within the same Active Directory domain, we wanted to… Read more

1 comments, 1,049 reads

Posted in John Morehouse | Sqlrus.com on 12 January 2018

Trello – Overview

Last month in December, I posted an article about working from home.  In it I mentioned a couple of tools that I use to help try to stay productive and on task, one being Trello.  Trello is a free kanban tool that helps to visually organize projects, which are… Read more

0 comments, 211 reads

Posted in John Morehouse | Sqlrus.com on 5 January 2018

Trello – Overview

Last month in December, I posted an article about working from home.  In it I mentioned a couple of tools that I use to help try to stay productive and on task, one being Trello.  Trello is a free kanban tool that helps to visually organize projects, which are… Read more

0 comments, 340 reads

Posted in John Morehouse | Sqlrus.com on 5 January 2018

Out with the Old, In with the New

In a few days the year 2017 will come to a close.  The brand new year 2018 is on deck and raring to go. Out with the old, In with the New.

This is the time of year where people reflect on the milestones of the previous year.  Resolutions get… Read more

0 comments, 75 reads

Posted in John Morehouse | Sqlrus.com on 29 December 2017

Out with the Old, In with the New

In a few days the year 2017 will come to a close.  The brand new year 2018 is on deck and raring to go. Out with the old, In with the New.

This is the time of year where people reflect on the milestones of the previous year.  Resolutions get… Read more

0 comments, 200 reads

Posted in John Morehouse | Sqlrus.com on 29 December 2017

Working From Home

It’s now been one month since I’ve started to work for Denny Cherry & Associates Consulting.  Working for DCAC now enables me to work from home. This was a substantial shift for me as I’ve never done this full time.  Working from home offered a lot of flexibility that… Read more

3 comments, 60 reads

Posted in John Morehouse | Sqlrus.com on 1 December 2017

Older posts