If you have to write out the audits in this fashion, triggers are the way to go. However, be very cautious using triggers. They can be extremely expensive operations since...

Ha! Thanks.

It's who we learned from, right. We found a friendly, amazing culture, so we perpetuated it. The "right way" to do the data platform thing is...

My experience is very different and very similar. I came into the DBA role through development and I'm a classic accidental DBA. The struggle is to both define your role...

It's really hard to offer sound advice on a query I can't see, against a structure I don't know, with unknown indexes, constraints, statistics and no knowledge of the execution...

Yeah, you can create the table variables into the In-Memory storage and it really does speed them up a bunch. I wouldn't recommend it for general use for all the...

yep. It's rolling...

The name of the filegroup doesn't matter so much as whether or not it was created using CONTAINS MEMORY_OPTIMIZED_DATA.

If so, yeah, that's the one you'll use for your...