Skip to content
August 12, 2022

John Morehouse

sqlrus.com // dba // bat whisperer

  • Community Involvement
  • Presentations
  • Scripts
  • About Me
    • Copyright
    • Disclaimer
    • Blogger Disclosure
    • Contact Me
  • Subscribe
  • Community Involvement
  • Presentations
  • Scripts
  • About Me
    • Copyright
    • Disclaimer
    • Blogger Disclosure
    • Contact Me
  • Subscribe
Latest
Secure Travel
Understanding Volumes vs Storage Pools
Speaking at SQL Bits 2022
Understanding VMWare Components
Moving VMWare Virtual Machines to Synology

Azure VPN – Point to Site IP Addresses

John Morehouse January 12, 2018 2 comments

Mobile Azure

John Morehouse June 1, 2018 0 comments

Building a Personal VPN Azure Solution

John Morehouse June 8, 2018 5 comments
post

Secure Travel

John Morehouse Jul 16, 2021 5
post

Understanding Volumes vs Storage Pools

John Morehouse Jul 16, 2021 5
post

Speaking at SQL Bits 2022

John Morehouse Jul 16, 2021 5
post

Understanding VMWare Components

John Morehouse Jul 16, 2021 5

Is 18TB of Storage Enough?

On July 16, 2021July 15, 2021 By John Morehouse

Come to find out, nope, probably not.  My good friend Jim Donahoe (blog|twitter)was very nice to tell me that he’s running 100TB of storage in his house across multiple Synology devices.  I also know for a fact that another good friend, David Klee (blog|twitter), utilizes enough storage in his house to […]

SynologydataDS920+NASstoragevolumes5 Comments

Quickly Determining Azure SQL Database Size

On July 2, 2021July 2, 2021 By John Morehouse

Recently I needed to determine how much storage space each database on a logical server was consuming.  I was doing some DR testing and I need to give the client a rough estimate on how much each database was going to cost.  You can do this through the Azure portal […]

AzureAzureazure sqlspace usedsql database1 Comment

Understanding NUMA in SQL Server VMs

On May 7, 2021January 8, 2022 By John Morehouse

What really is NUMA and why do we as database administrators care? NUMA stands for “Non-uniform Memory Access” and allows for increased CPU & memory performance.  This is because a memory bank is physically adjacent to a CPU socket on the motherboard of the server.  Each combination of memory and […]

Administration VirtualizationDoNotRepostHyper-VNUMASQL ServervmwareLeave a comment

Issues When Using Temporary Tables in Nested Stored Procedures

On March 26, 2021March 23, 2021 By John Morehouse

SQL Server offers a lot of flexibility when working with objects like stored procedures and temporary tables.  One of the capabilities is to allow for stored procedures to call other stored procedures.  This is called “nesting” one stored procedure within the context of the calling stored procedure.  In addition, you […]

T-SQLT-SQL4 Comments

Happy New Year!

On January 1, 2021January 29, 2021 By John Morehouse

Happy New Year!! Looking back at my Happy New Year! post from the start of 2020, I of course, didn’t realize the brute force of the global pandemic that was about to hit.  Even with the dumpster fire that was 2020, good things still occurred even in the midst of […]

PersonalHappy New YearpersonalLeave a comment

Merry Christmas

On December 25, 2020January 29, 2021 By John Morehouse

Christmas is this week so not a technical post for this week.  Just a simple post wishing you and your family as many blessing as possible (especially in the year 2020) and good tidings during this holiday time.  I hope that 2020 wasn’t too harsh on you or anybody close […]

Personalchristmashappy holidayspersonalLeave a comment

Is On-premises SQL Server Still Relevant?

On December 11, 2020December 11, 2020 By John Morehouse

Unequivocally, yes on-premises SQL Server Instances are still relevant. While I’m a firm believer that the cloud is not a fad and is not going away, it’s just an extension of a tool that we are already familiar with.  The Microsoft marketing slogan is “It’s just SQL” and for the […]

AzureAzurecloudCommunityDBALeave a comment

5 Things You Should Know About Azure SQL

On December 4, 2020November 26, 2020 By John Morehouse

Azure SQL offers up a world of benefits that can be captured by consumers if implemented correctly.  It will not solve all your problems, but it can solve quite a few of them. When speaking to clients I often run into misconceptions as to what Azure SQL can really do. […]

AzureAzurecloud3 Comments

Posts navigation

Older posts
Newer posts

About Me!

John is the DBA with a bat, a Microsoft SQL Server DBA, Blogger, Forum Answerer, Friend of Red Gate, Idera ACE, Chapter Leader, Speaker, Sentry PAC member, Microsoft Data Platform MVP and a bat whisperer.

Follow Me On The Web!

Top Posts & Pages

  • Understanding NUMA in SQL Server VMs
  • Finding Cluster Log Errors with Powershell
  • Understanding Volumes vs Storage Pools
  • Issues When Using Temporary Tables in Nested Stored Procedures
  • Restoring a Database from Azure

Archives

Badges / Awards

Blogroll

  • Argenis Fernandez (@DBArgenis)
  • David Klee (@kleegeek)
  • Denny Cherry (@mrdenny)
  • Joey D'Antoni (@jdanton)
  • Kendra Little (@kendra_little)
  • Kerry Tyler (@AirborneGeek)
  • Mike Fal (@Mike_Fal)
  • Monica Rathbun (@SQLEspresso)
  • Thomas Larock (@SQLRockstar)

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 3,539 other subscribers

Tags

administration (30) Azure (19) Backups (2) Career Opportunity (3) cloud (4) Community (44) CTE (2) data security (3) DBA (6) disaster recovery (2) Docker (3) DoNotRepost (4) encryption (4) family (3) Foreign Keys (2) Goals (3) Indexes (4) Internals (9) Mac (2) MVP (6) NomCom (2) Optimizer (3) PASS (2) PASS Summit (8) personal (5) philosophical (13) Powershell (8) Presenting (36) Security (5) social media (2) Speaking (14) sql db (4) SQL Family (8) SQL PASS (5) sql saturday (28) SQL Server (14) sql server 2019 (3) storage (3) stored procedures (2) summit 2014 (2) T-SQL (13) T-SQL Tuesday (6) TSQL Tuesday (2) vmware (4) VPN (2)
Copyright © All right reserved. | Theme: OnlineMag by eVisionThemes