You will need to perform a manual forced failover on the 3rd DR replica. 
Have a read here , but basically you will need to failover choosing with or...

Yes, with Basic Availability Groups you can only have 1 x database and IP assigned per BAG. 
If you applications needs 1 x connection string/listener name, BAGs won't work for...

Your issue is that the Date supplied '0001-01-01' results in out of range error, as it is less than the minimum DATE value accepted. 
Minimum Date should be DECLARE...

The answers did not satisfy the options. 
If you chose the "Classic deployment" approach, the answer could have been Azure Resource Groups focused and be wrong anyway.

Answers lacked...

You could make use of WMI query and alerting by starting sp_who2 embedded in a SQL Agent job. 
Just modify the threshold duration and utilization load percentage as required. 
After...

When I copy and paste your post in normal notepad:

and SSMS:

Have you played with regional settings and Language on the OS level? (stab in...

what roles is this group a member of?

Check the...

run the following to review your server permissions:

SELECT pr.principal_id, pr.name,
pr.type_desc,   pe.state_desc,
pe.permission_name 
FROM sys.server_principals AS pr JOIN sys.server_permissions AS pe  
ON pe.grantee_principal_id...

Nice question, thanks Steve

Yes, use CONVERT(VARCHAR(5),TimeOfVisit,108)

Unsure which column you want the time only in your query, but add or replace with cast(TimeOfVisit as TIME)
This will give you hh:mm:ss.nnnnn

10GB is the limit for your data file. 
If you have multiple data files, the limit applies to the collective sizing, so you can not have 2 x 10GB data...

Agree with you Japie, although I think there should be a function to override truncation on normal inserts. 
If I understand Steve correct, we'd like something similar to SSIS, to...

SQL Server Express does not provide the functionality to create maintenance plans, or schedule them. 
Please familiarize yourself with the limitations of the Editions here

You can use Ola's scripts, with Windows Task Scheduler: 

How do I get started with the SQL Server Maintenance Solution on SQL Server Express?

SQL Server Express has no SQL...