Lijun Zhang (12/26/2016)

I am planning to install a 2 nodes FCI using CSV as the primary replica, and a separate standard alone instance as a secondary replica for reporting.

The official...

I thought that too. I suspect some of those UK salaries are in £ not $. Well, I hope they are: http://www.sqlservercentral.com/Forums/Topic1847126-263-1.aspx

I missed this survey so I didn't fill it in, but I seriously hope that Snr DBA in London reportedly on $17k a year is only working a couple of...

It sounds Access-y.

If you have such restricted access it sounds as though you're not the DBA, so you can probably hand that task over to whoever is.

Thanks for replying; no, client_net_address is the address of the originating connection. I want to know where it's connecting to (i.e. I want to determine whether a connection is going...

It's not in London :-D. (Also I have a major hangover-memory from a wedding there a few years ago.)

The Iron Bridge does look nice.

I know, it's just getting there. I'd prefer not to stay overnight. (I doubt work would pay anyway, but will find out.)

What do you get back for

Use GTM;

SELECT name FROM sys.database_files

?

I want to go, but oh man, Telford.

Oh yeah, I see what you're saying; apologies.

Eh? They start at 0 though.

We've both just advised you not to. Have you got a test environment?

You'll probably want an OS upgrade too- I'd avoid doing an in-place upgrade, as already mentioned.

I think it should be ok, but are you planning to leave your DBs in the AGs for the duration? Keep an eye on the transaction logs if you do,...