Glad you where able to install.

As a side note please remember that "Always On" is just a marketing term from Microsoft.   Always On can refer to Always On Failover...

Also don't forget the changes with the cardinality estimator that where introduced in SQL2014, you will need to go over and test your queries, procedures, processed etc etc to ensure...

Yes that's correct, since the installer for RS was split from the main installer you can only perform 1 instance of SSRS per server.

If you try and re-run the installer...

If you want to do it the way Microsoft do it, take a look at xp_delete_file, but that only deletes .bak and .trn files so you need to ensure you...

You need a couple more "ends" at the END AS 'MEASURE'

END

END

END AS 'Measure'

Your not closing the outer case clauses for the parameter check

All depends.

You going VM's with SQL installed so theres no difference to your on-prem servers?

You going to SQL Managed Instances?

You going to Azure SQL Database?

They all act and behave differently. ...

The cert will be on your "active" portion of your transcript for 2 years after the exams/courses/certs retire.  After the 2 years it will move to the "inactive" section, so...

There will be no SQL 2019 exams.

Microsoft are moving away from "product" focused exams to "role" focused exams and are all based on the Azure platform.

After 70-761/70-762 70-764/70-765 70-767/70-768 are...

So you have setup a mail profile and you are able to send a mail successfully?

Are you wanting to be alerted to the "Stop" or the "Start" of the service?

If...

Microsoft will define the .Net version.  If you need to run a specific version of .Net you need to run a specific version of SQL server and SSMS.

Check the product...

Depends on your edition of SQL

Standard can only have 1 replica (primary & secondary)

Enterprise can have up to 8 replicas, (primary & 8 secondaries), only 3 secondaries can support sync...

That is correct that a log backup happens, the full backup only needs to be taken should a FULL not already have taken place.

As a full has already happened on...

What is your goal? What are you aiming for?

Are you wanting to become a Azure Cloud System Administrator?  Do you want to go down the data platform route? etc

If you need to restore, then you need to restore the FULL, then all the LOGS up to and before the time of the incident.

What your most likely want to...

Whats the status of log_wait_reuse_desc in sys.databases?

May be a case that you need to run a few log backups to get it to be able to checkpoint and shrink.