It's just a question of using XQuery to pull it out. Here's an example from my blog on how to do it. Here's another example doing the same...

I don't have a handy script for that. However, generating one would be really easy. Run the report. Capture the query it uses. Done.

I honestly don't know what you're talking about. I tried a search for this and nothing came up. I'm not aware of a tool built by Microsoft that does what...

Jeff's got a great point with Brent's tools. However, they still don't do synergy. They're focused on the DMVs, which are fantastic, but not complete. There's info in Query Store...

...

He hasn't quite figured out how to tell us when he needs to go potty, so all we can do is get him seated on it until he...

Oh I hear you. The reason I could so easily spew out that rant is because of the number of times I've had to explain it. It got to the...

No. That should be all you need. I should point out, statement level captures can be quite large. So, you should make sure you filter the session to eliminate as...

That's the absolute fun thing about triggers. They're not part of the rpc_completed call from an app. They're also not part of the sql_batch_completed call from an app. They're run...

Ah, triggers aren't technically batches or procedures. You'll have to go to statement level monitoring to capture that.

Anthony has nailed it. Those indexes are basically duplicates. Potentially, in the event of scans, you may, sometimes, see that smaller indexed used because scanning fewer pages is better. However,...

To my knowledge, no.

However, it's all about what events you're capturing and how they're making their calls. If you capture sql_batch_completed and they're using all stored procedures and/or prepared statements,...

Based on the info, I can't give you a precise answer. However, the place to look is permissions on the linked server. There must be a difference there when you...

First, an answer to your question, then, some discussion on the nature of backups.

To just see the objects in a database:

SELECT COUNT(*) FROM sys.objects AS o
WHERE o.type...

This is a very general question, so I'm going to give a very general answer.

If you intend to filter your information based on a particular column, one presumes Rosterdate from...

Heh... this happens during meetings, as well.  Someone goes off on a tangent or with some...