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

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

0 comments, 355 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,321 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, 192 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, 217 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,221 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,480 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, 844 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, 230 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,080 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, 380 reads

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

Mobile Azure

Microsoft Azure offers up a lot of technologies that you can play around with.  One thing that you might not know is that they also offer up a mobile presence to help manage your Azure resource.  The application is available for download for your mobile devices from the app store Read more

0 comments, 225 reads

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

DBCC Clonedatabase and Query Store

Cloning things is all the rage these days…..even Storm Troopers.

Anyway, by now, you probably have seen documentation on Query Store and DBCC Clonedatabase.  Query Store, introduced in SQL Server 2016, is considered the “black box” or “flight recorder” of queries.  It retains a history of executed queries, including… Read more

0 comments, 1,540 reads

Posted in John Morehouse | Sqlrus.com on 25 May 2018

Working with Consultants

After being immersed into the consulting world again for 6 months now, I’ve gotten to work with clients in several different areas of world, although most of them are based here in the United States.  Over that time I learned every client is different and handles things differently, but that… Read more

0 comments, 384 reads

Posted in John Morehouse | Sqlrus.com on 27 April 2018

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, 384 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, 330 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, 236 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, 2,200 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, 119 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,652 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,226 reads

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

Older posts