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

I think the big questions that come to mind are:

1 - are you fully patched?

2 - is the latest .NET installed?

3 - how are you calling the linked server?  Is...

To me it looks like it isn't a SQL Server issue, but something with "PIPC" or "pisdk".  Not sure what those are, but google makes it look like it is...

There is a lot of area to go with your question.  Not seeing high CPU, memory, or disk queue may or may not tell you much.  For example, if your...

Looks like a permission related error to me.  Since it works with the local account, it is probably configured to allow that account to view contents (browse at a minimum),...