Same old story.

Thanks for sharing.

I haven't begun to use all of SQL Prompt's features. But it's code completion is much better than SSMS built-in intellisense. I have found Smart Rename & Find Invalid...

That's not...

OK, I'm a little confused as to what it is that you're looking to get here.

You're describing lock waits, which system_health captures. Locks that exceed 30 seconds get reported. It's...

Oh, right. That's the Extended Events GUI, not system_health. Sorry. I misunderstood.

System_health is just a monitoring tool. It shouldn't be messing with your systems in any way. You can set...

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