Indeed, that's why we always perform DBCC CHECKDB after a database restore.

When you restored the prod db a second time to reporting, did you first drop de reporting db or did you restore with replace ?

In such case it will reuse...

What differentiates as Sequence ?

Why is "4001_0_3       1                                      08:00:00  "...

another option is to have the instances listen to port 1433.

How do regular consumers ( users / applications ) connect ?

If you activate sqlbrowser service on your instances, you don't need to provide the port number.

( of course not...

What kind of aliases are you talking about ?

• DNS aliasses ?

  • We use these to provide a "more meaningful" server naming ( but connections should also provide Instancename or...

Did you check default trace and/or system_health xe session ?

You can monitor your AG(s) with extended events:

ref: https://tracyboggiano.com/archive/2017/07/monitoring-availability-groups-part-3-extended-events/

Actually, the correct answer is: Who cares !

It is a PaaS solution that takes care of all Backups etc. at the pace / desire of the PaaS provider.

FYI: Brent wrote a nice 101 about Filtered Indexes "What You Can (and Can’t) Do With Filtered Indexes"

FWIW, whenever we disable a job, we leave a trace of it by renaming the job ! (we add a prefix e.g. 'DBA-MaintenanceWindow-'

Doing so, we know who/what did disable the...

Great feedback !

Can you elaborate on the build number of SQL2016 you are using ? Which CU ?

Did you open a case at Microsoft?

Don't you just love storing datetime/date/time information in (var)char columns.?

Now you're stuck with the downsides of this design option.

Don't let the engine guess what format the dates are stored in,...

We mostly use DNS aliasses to have applications connect to our clustered instances.

( more meaningful naming conventions as with our server names )

Doing so, we can migrate the sqlcluster without...

except for the bickering ... did - did not ...

Isn't there also a ratio processor/core(s) vs io chanels vs io threads to keep in mind?

Set aside the tool.

Where and how do you document / manage Databases in a VSTS/DEVOPS/GITalike infrastructure ?

Do you have separate db projects/solution to which devs can pull branches and checkin...