I don't see it there either. Be sure you're on either an Enterprise or a Development instance. I'm on Development, but I can't find it. Documentation is sparse too.

I'm not sure I understand what system_health GUI you're referring to? Can you clarify a bit? There is a system_health Extended Events session. You can stop that, and modify it,...

So, formatting? Personally, I'd recommend doing that on the front-end. Databases aren't the greatest at formatting.

It just makes mistakes. Lots of them. Also, the hard part is getting your tables & such into the language model.

Now, Redgate, my employer, is adding a way to do...

I'd suggest taking a look at Flyway. It's open source, but there's also a paid version with a lot more functionality.

Flyway uses a migrations based approach to deployments. That...

Whoof! 500 rows took 12 minutes? Honestly, that should be something that occurs in, at most, a few seconds.

Indexes may help (they can also add overhead to deletes as Frederico...

I'd start with the source. Here's Microsoft's take on upgrading SSRS. If you get stuck or need details, there are probably other resources that can help.

Testing will be your...

But, I have to tell you... even experts may have to try more than once and it frequently means running the code and measuring reads while comparing to execution...

In addition to all the stuff already mentioned, I'll add my book on query tuning (link in the signature, yeah, that one does cost money) gets into a lot of...

There is no one answer here. Personally, I have been pursuing knowledge of PostgreSQL in addition to SQL Server.

Why that and not something non-relational like MongoDB? Well, after studying a...

You'll want to update SSRS as well.

Also, you're at the magic inflection point, going past SQL Server 2014 (and do go past it, don't upgrade to 2014 and stop, not...

It's probably permissions though. That's the most common issue here.

I assume you're using something to automate the running of DBCC. When that something gets an error, have it send an email. That's it. So, how are you running DBCC?

Estimated plan can tell us a lot. Sure, actual plan tells you more, but just plucking the plan out of cache goes a long way.

This is very much an opinion question, so please take this answer as such.

Yeah, you need additional monitoring.

The basics are there, sure. The AWS console will tell you if the...