Call me a dinosaur if you like, but I'm 100% with Alex Gay - don't use it and wouldn't use it for code I can write myself. Nearest...

Awfully Infuriating

Amazing and Idiotic

Assistance Included

This sounds like something doable, but likely something that is done outside of T-SQL. I only see a few dbatools replication commands, but for something like this, which is a...

Good points. As the only DBA in a few places, I haven't had a ton to do after the first 6 months when I clean up the environment. In those...

Short answer, ID10T error.

Longer answer, I was editing this as we had a formatting problem and I think I changed the answer here and then changed the question, without testing....

I see some SSIS people moving to ADF, but mostly just running SSIS from the connector.

Some non MSSQL people seem to like dbt, but that looks like a wild, crazy...

I think this is an Azure size. What do you want to change? Cores or RAM?

I would lean towards DesNorton's solution as I dislike triggers and I think they get hidden/lost from future devs/DBAs.

The sizes are here: https://learn.microsoft.com/en-us/azure/virtual-machines/sizes/general-purpose/ddv4-series?tabs=sizebasic

You have a 64 core, 256GB ram machine, correct? What do you want to grow? Cores? RAM? CPU generation? This page might give you some...

How does the dev "pull" the db? I might add the check there, not as part of replication, but as something that doesn't trigger anythin in SQL Server if their...

I'm not quite where Rick is, but I feel a lot of those things. I'm definitely old.

At the same time, I know that paying it back, helping others, and recognizing...

Lots of places don't use them. It's slightly crazy to me that people see this as hard.

Is this before the initial snapshot?

I'm not aware of anything that allows this.

What types of checks are you thinking here? Is this some automated way to add new subscribers?

This is a reason I've often put placeholders on drives (https://voiceofthedba.com/2014/12/01/creating-placeholder-files/) especially on servers. When I run low and we have a space argument or slow approval, I can...

Everything can be the devil, but most of the homegrown ways of managing infrastructure are worse, IMHO