Thursday, July 15, 2021

Work Life: Attentive to detail? Detail-oriented? Why do people who claim this seem to be the worst at it?

Although this one instance today triggered this post, the main reason I post this is because I just have flashbacks to all the other individuals who also claim to be very detail-oriented.

I have worked with some extraordinarily detail-oriented people. I worked under a CEO of a company of over 500 individuals. I met him once. He remembered my name and some random information about what we spoke about over 15 months prior. Others may not have been as good but they were still impressive. And if there was one thing in common for all of them... none of them have ever said that they were detail-oriented.

If anything... perhaps I am biased to the data... I find everyone who has ever told me that they were detail-oriented especially after I tell them to correct a minor detail are the worst detail-oriented people. Always something on the line of "so sorry, I don't usually make these mistakes. I pride myself on being attentive to details.", "please let me know because I am very detail-oriented", or some other BS. They are not even average.

There was one guy that was so terrible that I nearly told my manager that I could no longer work with him because it was taking me longer to edit his work than to do it myself. I was really about to, but his work was so bad that even upper management said enough was enough. This was a lot because I've seen them accept pretty bad works before.

And today's example was a developer who talks a mile-a-minute to cover his inability to stay focused. He "prides" himself on his detail-oriented work. Yet every request has some pretty big blunders like misspelled object names, wrong server, wrong types. What really threw me for a loop was that he misspelled a name twice. One was an obvious catch like "label" vs "lable" but the other was OB210. OB is for outbound, so obviously that should be the letter O, but instead it was a number 0. It took me a little bit of time, and I actually tested that... it took me another hour or two because the "misspelling" of label was the actual spelling.

Yes there is human errors but this guy is up there. Developers have to provide me a list of their changes. Because he appears awesome, he gets a lot of new projects so many of his objects do not exist yet he will provide me a list of stored procedures like... spName, sp_Name, NameWithoutSp, NameWithSpAtEnd_SP, SPName, SpName, [spName], dbo.[spName]. It is just pure crazy how inconsistent this guy is. I can understand other developers do a little of this because the name was already that way but this guy gets to create his own names.

Third example, he created a bunch of destination folders. They have the same structure CustomerName_Type_CarrierName_something. A list of maybe 10 of them, then there is one folder that keeps failing because it is called CustomerName_Type_CarrierName _something. Who puts a space in the folder name? Then not catch it because it also needs to be set inside a configuration file where it is even more obvious there is a space.

Last example is he somehow screws up the SQL stored procedure names in such a way that even SQL gets confused. I use C# SMO to create automatically create scripts and he has one where it creates a name [SpName ] in the textheader but sql actual corrects the name to [SpName]. So this creates an error because the textheader doesn't match the actual name.

I just do not understand how these people have such huge egos and still look impressive.

Thursday, July 8, 2021

Work Life: Why do managers assign the person with the least meetings to schedule a new meeting?

Managers in general should be creating meetings instead of their underlings or other people's underlings.

Why do managers do that?

1. Because they like that rush of power (intentional or not)
2. They think they are too busy to do it
3. They do not want to appear to not understand what the meeting is for

What I think?

I guess there is nothing that can be done with someone who is power hungry. Feeling too busy is too disrespectful of other people's time. Not understanding what the meeting is for is not even the ask.

Scheduling a meeting with a person who's calendar is full, plenty of double-booking, etc., only makes any sane person just sit there for a minute or two to think things over... like does that person not understand that is calendar is full for the next 2 weeks or year? Do they think we can see why the time is even blocked out to at least see if maybe a block is less important? If they ever scheduled anything, they will realize that 99% no one can see what is there at all... it is just a big blob of unavailable times. So this is easily 5 minutes just to scan the calendar for an open spot. AND THIS IS JUST FOR ONE PERSON!! Most of the time I have to deal with multiple people...

How long would it take him to schedule? 1-2 minutes. Why because he can see his own calendar that he does not even maintain to keep up-to-date so that someone else can schedule a real meeting. He can clearly see that a spot is available. He can see which meetings typically run short.

More importantly, he has more authority to get other people to join the call. If I have a call with more than one manager... I spend another day or two just to reschedule because they respond that they cannot make it or a change in schedule....... then they have the audacity to not even recommend a new time.

So, in best case... 5 minutes vs 2 minutes. That is 2.5 times. If it takes him longer, it'll probably take me much longer, so 2.5X is probably best case.

Company Cost?

Let us take 2.5 times as the lowest difference in our time. Does my manager make 2.5 times what I make? If he's Warren Buffet, I probably should continue to waste the rest of the year rescheduling.. but that's an exception. Most middle managers probably don't even make 2 times my salary. So it is not even worth company time for middle managers to delegate scheduling to someone else.

Also my job isn't scheduling stuff. If anything that is what middle managers do. So what is the company even paying you to do? Sit in meetings and waste everyone's time? (I'd like to say that sarcastically... but it'll probably sound more like a weak laugh while crying inside)

On top of all that, this also wastes the managers time too. More time than if they just scheduled it themselves. Manager has to check calendar. See if it is more important. Then send email that they cannot make it. Read another email on the complicated list of when all the other people are available, put in another time. Then have to read another email because another key person cannot make it (usually their own person), and repeat. 

My Suggestion

Managers should open your outlook, click new meeting, click a time on the calendar, add me to the calendar, then send. It'll take you one minute to do. I will fill in the rest or give you the people who needs to attend.

And if you already know me... I send that list before you even create it.

Stop wasting both our time.



Friday, July 2, 2021

Buggish: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds. (no answer)

 I tried killing this SQL session, but it never disappears. When I use "KILL ## WITH STATUSONLY", I get:

SPID ##: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.


I know what is executing it which was my web tool that edits the sql server. I tried restarting the App Pool but this did not do anything. I eventually IISRESTART and the session disappears.