Yes, the query looks exactly like you mentioned, Michael. I like the idea of splitting by usage scenarios, especially where there seem to be a couple of the more...

Jeff has nailed the answer. I just want to add that, yes, in Azure you can use Plan Forcing to ensure that a given plan gets used. It's part of...

Changing the database changes the default behavior. Changing the specifics of the connection changes that connection only.

Yep. What Phil says.

Otherwise, you can set up an Extended Events session to capture object_altered. Same goes for created and dropped.

I have a few blog posts that show how Causality Tracking works. The concept is really simple. Things like a login and a DML statement are connected. So, group...

Always remember, open source is free of licensing costs. That doesn't mean it's free. You're going to pay somewhere. You may pay in reduced functionality as many of the open...

So what you're doing here is creating a whole series of result sets with that dynamic query. There's not a way to put stuff together, of course. Instead, you should...

It all depends on how the dacpac is applied. If people are just right clicking in SSMS, your level of control is zero. If there's a script that is used,...

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