Use Audit or XE. XE is more friendly for data storage and loading into a table.

tempdb isn't large or small. It is what it is. You might just need that much space for your workload. This isn't necessarily an indication of bad code, but it...

I've unspammed it. While it did look funny, I didn't take it that way. Mainly because I've seen quite a few posts from SCDecade.

I liken mentorship to having adult children. It's more advising at times, in specific places, and not guiding or telling them often, but just helping them when asked, or just...

The goal is to release completed work quicker. Every feature you've completed is inventory. It's work in progress while you wait for QA, packaging, scheduling, and deployment. The absolutely goal...

DevOps is a culture, but the culture isn't to write sloppy code faster. It's to release the changes, backwards compatible, quicker. From code commit to release is quick, not from...

More that you are applying an "all or nothing" for the policy to all objects, meaning that the predicates are one big group. If I needed to have a separate...

Sorry, got busy and forgot about this.

I think if things are related, it's good to have them in one policy, so that you see them. If you start to have...

Same here, I ran across this and learned something. I want to do more spatial questions, but it's hard because I am busy with things, and this is complex topic.

Management is concerned, and trying to engage people. Certainly many of us are introverts, but there is a difference between enjoying your own company, but being in social areas, and...

Testing is always a hole. A similar SQL Agent bug in 2005, from changing an enum. Here, I think someone just didn't cover this case, which is both disappointing, and...

Only a restore, as John noted, tests this. That is only at that point in time, and later the file might get corrupted, especially during copying, but doing this regularly...

success is for the job. The parts of the job might have issues, but depending on your proc, you might report success. Seeing the proc will help, but honestly, there...

You are at risk. You are assuming your full backup file is actually correct and not corrupt. If you restore it regularly, that's better, but image you back things up,...

Performance is more variable. You could read about the differences there. You also don't have the same control. You can't see hardware, and must work on any issues with looking...