John

John Morehouse is currently a Consultant with Denny Cherry & Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, 2016 Idera Ace, Friend of Red Gate since 2015, Sentry One PAC member & Community Ambassador. John has passion around speaking, teaching technical topics and giving back to the technical community. He is a user group leader, SQL Saturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQL Saturday's as well as other conferences. If you want to find John, you can find him on Twitter (@sqlrus) or on his blog, http://sqlrus.com.

Blog Post

I’m Speaking!

After a long hiatus of not blogging, I’m trying to get back into writing.  So, to kick it off first thing in 2024, I’m speaking! I’m honored to have been...

2024-01-19

7 reads

Blog Post

Secure Travel

Last Updated on March 4, 2022 by John Morehouse Update: This post was originally published on March 8th, 2019 and a lot of things have changed over the last...

2022-03-04

48 reads

Blogs

SQL Bits 2025 Wrap

By

SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...

Simplify Kubernetes Security With Kyverno and OPA Gatekeeper

By

Here’s how these tools can make Kubernetes security easier and help you avoid common...

A New Word: Lackout

By

lackout – n. the sudden awareness that you’re finally over someone, noticing that the...

Read the latest Blogs

Forums

Shades and Reflecting on SQLBits and the Bright Future of Data

By dbakevlar

Comments posted to this topic are about the item Shades and Reflecting on SQLBits...

Merge techniques

By purushotham.k9

In Azure SQL DB, i want to merge records from the staging table to...

SSRS error: The Value for the image 'Image1' has a constant value...

By sgmunson

Full error message: SSRS error: The Value for the image 'Image1' has a constant...

Visit the forum

Question of the Day

Adding Defaults

I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.

ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE()
GO
ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate
GO
What happens when I run these two batches?

See possible answers