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.

SQL Server Data Pages on Linux

One of the new phrases coming out of Microsoft is that “SQL is just SQL” regardless of what operating system it resides on.   This was echoed during the keynote at SQL Bits 2019 by the Microsoft team, which you can watch here.   Later that weekend, I gave a session… Read more

1 comments, 134 reads

Posted in John Morehouse | Sqlrus.com on 22 March 2019

Checking Open Ports in Azure

Let’s be honest here, data security is really important to me.  Some people probably think that I go to extremes to ensure that my data as well as my customers data is secured.  With that, sometime ago, I wrote a blog post on utilizing a VPN server that I built… Read more

0 comments, 216 reads

Posted in John Morehouse | Sqlrus.com on 15 March 2019

Secure Travel

Traveling in today’s age of technology is a lot easier than in the past.   You can start your journey in the morning of one country and be half way across the world by nights end.   When traveling, data security is usually always at the forefront of my mind.  I recently… Read more

0 comments, 1,740 reads

Posted in John Morehouse | Sqlrus.com on 8 March 2019

Restoring a Database from Azure

In a previous post, I described how you can use Azure storage to store SQL Server database backup files.  This flexible option offers the ability to get your critical backups off site and in certain regions, they could be configured to be automatically redundant to a secondary region.  Having… Read more

1 comments, 232 reads

Posted in John Morehouse | Sqlrus.com on 1 March 2019

Adding Azure VM Boot Diagnostics

A couple of weeks ago, I blogged about boot diagnostics and how they can help you troubleshoot issues when virtual machines won’t start.  But what if you selected to disabled boot diagnostics when the virtual machine was created?  Can you go back and retro-actively add them back?

Yes, Virginia, yes… Read more

0 comments, 182 reads

Posted in John Morehouse | Sqlrus.com on 22 February 2019

Achievement Unlocked – SQL Bits

Several weeks ago, while on a flight traveling home from San Francisco, I received an exciting email.  I had submitted to speak at SQL Bits and during my flight I was notified that one of my submitted sessions had been selected.  This means that I’ll be traveling to Manchester, England… Read more

0 comments, 448 reads

Posted in John Morehouse | Sqlrus.com on 15 February 2019

Azure Virtual Machine Boot Diagnostics

If you have ever rebooted a virtual machine and feel like you are in the dark to it’s current state, you aren’t alone.  Thankfully, Azure provides a number of tools to aid in your experience in the cloud when it comes to “reboot darkness”.  Boot diagnostics allows you to see… Read more

2 comments, 223 reads

Posted in John Morehouse | Sqlrus.com on 8 February 2019

Modern Hardware with 64 CPUs

In today’s world, more often then not you might run into systems that have large beefy hardware.  Hundreds of gigabytes of memory, ultra fast solid state disks and many CPUs to push your workloads.  These types of systems are no longer unicorns in the wild but are becoming more and… Read more

4 comments, 2,437 reads

Posted in John Morehouse | Sqlrus.com on 1 February 2019

Microsoft Update Catalog

In today’s world of database administrations, there are a plethora of tools and resources that can be available to utilize to help solve problems, such as performance tuning, configuration, and many others.  Some are third party tools, some are free, and some are provided by the vendor themselves. Regardless of… Read more

0 comments, 167 reads

Posted in John Morehouse | Sqlrus.com on 25 January 2019

Finding Cluster Log Errors

Sometimes you know that a problem occurred, but the tools are not giving you the right information.  If you ever look at the Cluster Failover Manager for a Windows Cluster, sometimes that can happen.  The user interface won’t show you any errors, but you KNOW there was an issue.  This… Read more

2 comments, 1,837 reads

Posted in John Morehouse | Sqlrus.com on 18 January 2019

Azure – Backing up to URL

In a previous post, I talked about some of the available storage options that can be used to back up your databases directly to the cloud.  Doing this is a really good way to get your backups off-site and replicated in a single motion, depending on the region and… Read more

1 comments, 416 reads

Posted in John Morehouse | Sqlrus.com on 4 January 2019

Azure – Creating a storage account

Azure offers a lot of features that enable IT professionals to really enhance their environment.  One feature that I really like about Azure is storage accounts.  Since disk is relatively cheap, this continues to hold true in the cloud.  For less than $100 per month, you could get up to… Read more

2 comments, 2,480 reads

Posted in John Morehouse | Sqlrus.com on 28 December 2018

Azure Portal Enhancements – Switching Accounts

More and more I am impressed on the Azure Portal.  Microsoft continues to make enhancements to the user interface (UI) and add in new features.  One of these new features that I’ve recently become aware of is the ability to easily switch accounts.

As a consultant, I work with clients… Read more

1 comments, 236 reads

Posted in John Morehouse | Sqlrus.com on 21 December 2018

Azure Backup Storage Options

As a database administrator, I am very conscious of how data is being backed up.  Up until SQL Server 2012, you were limited to backing up your databases to a physical device.  That device could be a tape, local disk, or network storage.  After successfully creating a backup, if you’re… Read more

3 comments, 265 reads

Posted in John Morehouse | Sqlrus.com on 14 December 2018

[Video] Configuring Geo-Replication to SQL DB

With the hurricane bearing down on the east coast of the United States last week, making sure you have a good disaster recovery plan in place should have been a top priority for you.  If you happen to be using Azure SQL DB, adding geo-replication is a simple and easy… Read more

1 comments, 1,275 reads

Posted in John Morehouse | Sqlrus.com on 21 September 2018

Steps for SQL DB Geo Replication

Unless you are living under a rock, you have most likely heard of the hurricane that is bearing down on the east coast of the United States.  Some areas have mandatory evacuation and I have seen reports of 80’ plus foot waves so this hurricane is not a joke.

Another… Read more

0 comments, 2,543 reads

Posted in John Morehouse | Sqlrus.com on 14 September 2018

Extended Security Updates: No More Freebies

As data professionals, we should always strive to keep our systems updated and patched to ensure proper security of our environments.  Microsoft has moved away from releasing service packs to releasing just cumulative updates and the occasional hotfixes.  These hotfixes may or may not be security related, but it behooves… Read more

0 comments, 915 reads

Posted in John Morehouse | Sqlrus.com on 31 August 2018

Database Protection in the Cloud Era

The Cloud is a fun and exciting place to be.  Exciting as it may be, even in the cloud, protection of databases and the data they contain has to be forefront in your mind.  If it isn’t, that is just calling for a disaster to happen.  

Recently, I had the… Read more

0 comments, 271 reads

Posted in John Morehouse | Sqlrus.com on 10 August 2018

File Growth Rate – The GUI Lies

If you are like me, you use the SSMS GUI for various things.  Though, I tend to use scripts for the management of most things, I do check on the database growth rates of files using the GUI interface.

While I was recently,  doing a review of a client’s environment… Read more

1 comments, 1,147 reads

Posted in John Morehouse | Sqlrus.com on 15 June 2018

Building a Personal VPN Azure Solution

Since joining Denny Cherry & Associates Consulting, I tend to travel about once a month.  This isn’t a huge amount and is usually over a weekend (except for that opportunity to go to Australia that didn’t pan out).  Since I work in the IT field, security is highly important… Read more

0 comments, 421 reads

Posted in John Morehouse | Sqlrus.com on 8 June 2018

Older posts