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
27 reads
John Morehouse | Sqlrus.com
Deploying VMWare into Azure
Last Updated on January 18, 2024 by John Morehouse Did you know that you can deploy native VMWare virtual machines into Azure? Yeah, I didn’t either until earlier this...
2023-12-29
43 reads
Accounting for Virtualization Head Room
In this post, I discuss about not forgetting to allow for additional head room when planning out new hardware, especially for HA/DR needs.
The post Accounting for Virtualization Head Room...
2023-12-07
32 reads
Hot Adding CPU to SQL Server
Last Updated on January 24, 2023 by John Morehouse © 2022 – 2023, John Morehouse. All rights reserved.
The post Hot Adding CPU to SQL Server first appeared on John...
2022-12-09
73 reads
Preventing Noisy VM Neighbors for SQL
Last Updated on January 24, 2023 by John Morehouse In today’s modern world, virtualization is often used to help mitigate cost as well as to provide flexibility in scaling...
2022-07-08
29 reads
Running SQL Server on Synology
Last Updated on January 23, 2023 by John Morehouse Synology has a wide range of capabilities but sometimes it still falls short. In a previous post, I mentioned moving...
2022-05-06
1,144 reads
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
74 reads
Understanding Volumes vs Storage Pools
In hindsight, I should have done this differently. In a previous post I discussed how I carved up 18TB of storage into various storage pools. Now that I have...
2022-03-02 (first published: 2022-02-18)
671 reads
Speaking at SQL Bits 2022
A look at the sessions I'll be presenting at SQL Bits 2022 in London this year. Excited to return to a great conference and hope to see you...
2022-02-11
53 reads
Understanding VMWare Components
Last Updated on January 9, 2022 by John Morehouse Recently I was looking to install VMWare components in my local network of things so that I could gain additional...
2021-12-10
25 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers