If you don't need the end user connecting as themselves, you could have it connect as a specific user on the remote machine.  Downside is you may need to create...

I think this really falls under "it depends".

Are you already licensed for 2019 (ie do you have software assurance OR do you need to buy 2019)?

Are there features in 2019...

I rarely do an uninstall.  What I do when I decommission a SQL instance is to stop the services and change them to disabled.  I've had odd hiccups when doing...

I agree with Grant here, and would like to add that you miss 100% of the chances you don't take.

I know in my organization, once a product hit a certain...

First thing, posting an Oracle question in the SQL Server 2016 forum section is likely not going to get many results (if any).

Next, I am confused why you posted here...

This is a multi-step process and depends on your requirements, but one approach would be to use what you have but turn the AVG into a windowing function and store...

On top of books, it may be beneficial to take some training courses.  There is a LOT of training available out there.

To add to what Grant said, I had a similar introduction to my DBA role.  I found a company that did work I was interested in. They were not hiring...

So to confirm - the problem is resolved by turning off XACT_ABORT?  That is a new one for me, but good find!

I would like to counter burke.marg's comment about peak performance being more important than readability.  My opinion, readability is the most critical piece of the puzzle.  If I need to...

as a wild thought - have you tired casting the credentials to the appropriate datatype?

Looks like you may need to do something like this:

https://gist.github.com/Jaykul/81fd8ee55ce4df656d36d23e59788151

The above is a powershell script to...

To add to what Jeff says - just because the standard definition is X, doesn't mean that company Y will follow that.  For example, I was a DBA by title,...

I think when you say "lean" you really are referring to normalized, and I do recommend normalizing tables that have a high number of write operations.

Tables with high number of...

Without seeing your setup, the full text of the error message, or knowing anything about the setup, I am making a LOT of assumptions below.

But if I remember right, error...

I don't see why you couldn't capture the data with XE.  Create the XE session to capture the data you want, have it save it to file or table or...