For a Windows shop, is there any practical benefit, like in terms of licensing costs or performance, for running SQL Server on a non-containerized Linux instance? For example, could...

The journey of a thousand miles...

I'm surprised to see that Microsoft has stopped development of containers for SQL Server on Windows. I'm not clear if it's because it's too complicated of a task or...

A couple Linux resources for you.

• http://linuxcommand.org/tlcl.php (used in the video series mentioned in the editorial)
• https://www.edx.org/course/introduction-to-linux
• https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/how-to-linux-for-sql-server-dbas-part-1/

you can add WSL to your Windows 10 install, use...

I neglected to add a note about Windocks, but I've added one in the post. They do support Windows containers. However, not having Microsoft do so for SQL Server is...

Great tips, Brian. The type of thing I've done as well. Any data changes mean we make a copy and waste space for a few days until we are sure...

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