No far from it.

Even in Azure you need to think about your HADR options and that’s both at IaaS and PaaS offerings.

While Azure SQL Database (PaaS) will move around the...

If it was me, I’d be looking at 2019 or even 2022 depending on what the timeline is for its release and your timeline for upgrade.

2019 has been around for...

Gail is around on Slack quite a bit now, if you want a joining link to the slack SQL community let me know.

I know she is busy as she (I...

No, publisher must be the AOAG not an individual replica.

The log reader technology needs the active log and can only run from the primary replica, it cannot run from a...

So, you have 3 machines in the AOAG, Server 1, 2 & 3.   Server 4 is completely stand alone, not in the AG or anything?

So the publication will be on...

So I have noticed the”Ask SSC” link from the menu has been removed.

That a on purpose change, is the plan to wind down Ask or was it an “oooops” moment.

Have you tested sending an email direct from sp_send_dbmail?

Have you restarted the SQL Agent after enabling mail?

Have you checked msdb.dbo.sysmail_allitems to see what the system thinks it has done with...

In this day and age I wouldn't even consider writing my own routines for SQL in PowerShell, I'd just immediately go for DBATools instead, as there is no point re-inventing...

As you posted in 2014 forum, have you created the needed load balancer and configured this at the cluster level?

https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-load-balancer-portal-configure

What is being done to combat the massive influx of spam posts which are happening multiple times a day at the moment?

Well that’s still a uninstall reinstall it just saves having to script everything from master/msdb and having to replay it once the reinstall has completed.

There is no way to do a downgrade to standard, you would have to do a complete uninstall and reinstall I’m afraid.

You may only upgrade

Dev -> Web -> Std ->...

So if it’s a test, please can you elaborate on each particular point of the answer?

We don’t just give out answers to tests without you showing some knowledge of the...

So you need to create a credential and then a proxy in the right proxy type, then you will be able to see this in the job drop down.

Depending what level you need AWS and Azure offer 12 months free of certain services.

RDS & EC2 from AWS of t2.micro

Azure SQL DB (S0 / 10DTU) and B1s VMs from...