"Close Oversight" <> "I can see you sitting at your desk".  If you think that you have to actually see someone at a desk in order to manage them, there's...

While I can appreciate the idea of being in the same space as others in the company to an extent, I don't miss most of the in-office experience. I've worked...

This is useful. We have several jobs where we want all steps to at least attempt to run, whether individual steps fail or not. Knowing which steps fail along the...

You use SSMS to do this, but I think the diagram functionality was removed from a couple of versions of SSMS. It is definitely back in the latest version (18.9.2...

Definitely been there, though my favorite was when someone gave us a "ragged right" CSV. So if you had 10 total columns, but some rows only used 8 or so...

I can definitely understand needing to reduce the frequency right now. Hope that eventually that can go back, but don't want to burn out the contributors. This is one of...

I appreciate the overview. I hadn't considered pulling in a docker image to play around w/ postgresql, but that makes sense.

I did want to note that the command to pull...

I did something similar to this not too long ago to get all of the users/logins for servers and their permissions for the servers and databases. Had to do it...

While I'm not particularly in need of them, I can see that there is value in them for others. However, it's ultimately your time being spent to write them up...

I think I remember playing around with an early attempt at handling data within SSDT projects and it wasn't quite intuitive. Post-Deploy and MERGE type statements do work, especially with...

Does this assume SSIS Server is installed somewhere already?  How detailed should the tasks be?  Not sure what came in the original question so not sure how detailed this should...

I'll agree with the general "tone matters" comments. If someone sets the sort of tone that your thoughts/input aren't wanted, that tends to leave to no thoughts being expressed.  I...

Out of curiosity, is this database ever refreshed? I noticed that there are several schema/objects that aren't part of AdventureWorks.

Well, another concern is if you're using Azure SQL.  Yes, there's Azure AD, but a surprising number of tools don't support that. That leaves us with SQL accounts.  When we...