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...

I thought it was a joke, but I've learned (the hard way) to never assume that people are joking 🙂

And I think you should be good to go then!  Good...

I just read through the code and to me I think what I said above should be correct.

The only thing is you will likely need to open the master key...

I am 99% sure you just need to restore the database as the DMK will come across with it.  Once you do that, it depends on how you were accessing...