-->
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: April 2015

SQL Saturday 392 – Atlanta, GA

Have you been to Atlanta, Georgia ? Nope? Well it’s time you plan that trip and come see me speak May 16th, there at SQL Saturday #392.  This will be my first time presenting at their SQL Saturday and I’m really looking forward this great event. According to… Read more

0 comments, 827 reads

Posted in John Morehouse | Sqlrus.com on 30 April 2015

Quick Script: Finding Database Owners & Security Admins

Security Is Everybody’s Responsibility

Recently, while diagnosing a permissions issue on a Production database, I realized that I didn’t really have any idea who had elevated permissions to any of databases on the instance. Particularly, I was interested in who the members of two specific database roles were, if any;… Read more

0 comments, 302 reads

Posted in John Morehouse | Sqlrus.com on 23 April 2015

2015 Program Committee

Last year, I was very much honored to be selected to deliver a pre-con with my friend brother Chris Shaw (B|T).   I was both excited and nervous at the same time. Regrettably, there were some rough moments in the days that followed the selection announcements, when… Read more

2 comments, 361 reads

Posted in John Morehouse | Sqlrus.com on 16 April 2015

T-SQL Tuesday #65 – Failing Over with PowerShell

This month’s T-SQL Tuesday topic is being hosted by Mike Donnelly (B|T).  The topic of choice is a fantastic one, its simply just to teach something new.

So let’s do this.

Our current windows patching process is manual.  On a given weekend every month, we log… Read more

4 comments, 577 reads

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

Detaching a Database – File Security Gotcha

I’ll admit it, there are times where detaching a database is the best way to get something accomplished, but it is my least favorite way of doing anything.  Using this method can leave yourself open to issues, such as security, if things go wrong.  I think that it’s an important… Read more

5 comments, 592 reads

Posted in John Morehouse | Sqlrus.com on 9 April 2015

Procedure Creation – Correct Syntax, Wrong Database

Recently, on a Friday evening, we released an update to one of our core applications.   As expected, it went smoothly and no issues were noted.  On the following Monday morning, however, the story took a different turn when end users started reporting issues.  One of the issues encountered was related… Read more

0 comments, 380 reads

Posted in John Morehouse | Sqlrus.com on 2 April 2015