SQL Homework – December 2021 – Changing collation

I can only speak for the locations I’ve worked at of course, but in all of the places I’ve worked ... Continue reading

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

Daily Coping 9 Dec 2021

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

SQL Managed Instance – Failover Groups Quick Tips

Lets summarise some important learnings about SQL MI and failover groups. when you add a database to a failover group the secondary database has the same edition / compute...

Storage options & Disk Types in GCP

Want to learn and use Google Cloud Storage?

What is Cloud Storage & Bucket?

Type of Disk avilable in Cloud Storage?

Lets Start! Continue reading ?

Amazon RDS Custom for SQL Server – A new beginning

Imagine getting SA (sysadmin) access to your RDS SQL Server Instance! Well, that was not possible in the past, but during AWS re:Invent 2021, Amazon RDS Custom for SQL...

Building a pacemaker cluster to deploy a SQL Server availability group in Azure

There are new Ubuntu Pro 20.04 images available in the Azure marketplace with SQL Server 2019 pre-installed so I thought I’d run through how to create a three node...

Daily Coping 8 Dec 2021

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Hiding Email with a Dynamic Data Masking Function–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Dynamic Data Masking is a feature that provides...

Your next step in the cloud

Over the last nine months I’ve presented (virtually) eleven times on a variety of topics relating to SQL Server and the Microsoft Data Platform. Long-time readers will know I...