Hmmm... No. You'd have to mark the system in some manner. You can avoid tables by using Extended Properties. That's an easy one.

Fundamentals are still the same from 2012, but if you want a better book recommendation, I'd look up Itzik Ben-Gan and get his book on T-SQL. Not only does it...

Strong recommendation, don't take anyone's advice on licensing. Go to Microsoft. They know. Everyone else just has opinions.

For what it's worth, I agree with @Ant-Green assessment, but I'd still go...

Total agreement with @pietlinden. There is no "fast" way to understand insanely huge and complex queries. It's all about breaking down the component parts and understanding what each does. That...

That's it to my knowledge.

Dacpac works as a deployment mechanism (although there are shortcomings). However, it's now how you track a history of changes to objects in the database. There's just no easy mechanism...

"Cloud engineer" is really vague. Cloud technologies cover just a ton of ground. Data, applications, services, storage, architecture, all of this is part of the cloud and you can focus...

Let's be really clear here, you can't update a row and read it at the same time, when the UPDATE takes an exclusive lock. NOLOCK, while used as a magic...

I'd say you either have to use VIEW SERVER STATE and/or VIEW DATABASE STATE, or you need to create your own custom views/procedures and then give them access through there....

Well, you could, with a ton of work, create a generic procedure that just needs a table name to make this work. You'd have to use dynamic SQL to build...

Hey Rod,

I know I'm not supposed to try humor any more because it just leads to me getting in trouble, but your co-workers could use a clue-by-four up side the...

Thanks for the feedback everyone.

Rod, I think the analysis paralysis thing is a problem for really smart people. Me, I'm more likely to come to the brown leaves conclusion far...

<sigh>

So I post a comment over at DBA Stack Exchange, because I know what I'm posting isn't an answer. I get dinged for it because it almost reads like an...

You get one row per batch if you collect batch_completed. You get one row per procedure call if you collect rpc_completed. You get one row per statement if you collect...

Further to what Brian says, that TOP might even hurt performance. So, yeah, ditch it. It's not adding functionality for you.

The only thing I can spot right now without an...