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

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

Finding the NTFS Allocation Unit Size for Mount Points

The 64Kb Allocation Unit size is one of the easiest SQL Server best practice items to complete during your new builds, but from time to time, I still see...

The less you hear from or about the DBAs the better they are doing their job.

Something I’ve been thinking about recently is that DBAs are best when they are invisible. Now, this is also true ... Continue reading