This used to be a very hot topic around SQL Server 2016 when automatic seeding first came out, then everyone learned how automatic seeding was just manual seeding but done for you and the topic went away. A decade later, it’s somehow back to being a hot topic. I guess all that is old is […]
I’ve been playing around with some different NVMe drives lately, looking at different performance characteristics and when I saw the output of some initial testing it made me want to write a quick post. Today, cloud is still the hotness (well, if you get past everyone saying AI like they said ML a few years […]
There has, for whatever reason, been a recent craze to figure out if a certain replica does or does not have the availability group create database permission. This is the permission that allows for automatic seeding to take place on the replica that is part of the availability group. I don’t quite understand the need. […]
