It's interesting, that I have clients doing both things mentioned above. Some still do big rollbacks, usually with a plan, albeit not a well tested one. Quite often I see...

xEvents is what I'd use. Get an idea of how often the view is queried with a session that is limited to just that object.

Be good to know how/why you shut this down. Wrong instance? Accidental click, etc.

Getting PRs accepted is always cool. I tend to do more in MS Docs, but it's nice when they take my changes.

Docker is very cool. I need to get back...

couple things.

First, any changes you've made to a profile would not be valid for these questions. We are not recreating an environment nor trying to define everything. you should always...

Ads always ask for more than the job. I don't know that I've seen one that was accurate since I stopped tending bar.

If you think you have to meet every...

My son worked in the computer lab in uni the last few years. They built images for machines that they could roll out via PXE boot across campus in minutes...

This might help. The step might be running under the owner, not the Agent account

https://www.red-gate.com/simple-talk/sql/database-administration/setting-up-your-sql-server-agent-correctly/

Double check the ownership of the job. If you can post more info, that's helpful.

When I see that list, I'm not at all scared. I've seen many descriptions, not just in tech, but in medicine, legal, hospitality, etc. where a job ad is created...

I ask gently, but I really hate doing anything else. I don't always like where the discussion goes, but as long as it's not abusing or profane, I won't censor...

I'd prefer this not turn into some political discussion. Both sides, or really all sides, use these techniques to sway others.

Outside of politics, plenty of others use statistics and data,...

There's far to many. From sp_config to all the database settings. MS has not made this easy.

A few people have tried:

• https://sqljana.wordpress.com/2018/09/12/sql-server-compare-the-configuration-of-two-instances-using-sys-configurations/
• https://archive.codeplex.com/?p=scriptsqlconfig

I was looking at some shoes a friend recommended the other day on my laptop. When I opened a game on android, an ad for the company was at the...

The plans should be the same, if all knobs/config settings are the same and the data/stats are the same. If you mean you're attaching the database separately to standard and...

I'll still disagree. This might be as simple as a table for sales

ZipCodeLogic
Salesperson ZipCodeStart Reason
----------- ------------ ---------
1           0...