Life: Do I need more water to sleep well at night? Second night experiment

I have been terrible with my water consumption since my last attempt about a month ago, and I haven't been sleeping through the night. Fortunately, I do not stay up (for the most part) and can fall asleep after I move to the couch. I'm not sure why changing my sleeping place helps with my sleep.

Yesterday while cleaning my place, I drank more water and again I was able to sleep without any interruption. Odd part is that I actually feel more tired than usually when waking up. The energy catches up soon though and now I feel I have more energy than usual.

So unsure if water is my problem, but seems suspiciously correlated. It may also have to do with the cleaning and possibly racing the neighbor's kids. I am so out of shape that the little "jog" may have been a workout for my body.

Reference

https://douglastclee.blogspot.com/2021/07/life-do-i-need-more-water-to-sleep-well.html

Work Life: I hate IT people who cannot figure things out (vent)

I have spent countless hours of my life showing "IT" people how to do things, especially things that my role is not even supposed to do. 

Currently as a release manager, I also manage:

1. Entire department wiki (including managing user access)
2. Troubleshoot defects
3. "IT" people's IT support desk
4. Onboarding IT access
5. Explain, re-explain, re-re-explain processes that are not even related to me
6. Gatekeeper for managers

#3 is the worst of the worst. At this point of my career, I hate supporting this the most. Why are we hiring IT personnel that cannot figure things out? I do not even mean learning cutting edge technology or tools. I am referring to just getting access to a network folder. In most corporations, this is done through a ticketing system.

The worst culprits of these people are boomers or older. Is it that hard to go to the ticketing system that everyone already uses and looking through the options? It is not my tool. I figured it out. So, just open the page and just skim through the text. Our ticketing system only has 7 options, the third option is called Request Access. One of the saddest parts is that I already walked them through it in the past. It is only three steps. The third step is basically an open form where the user has to ask the question that they just asked me: "please give me access to blah blah blah."

And then..... the worst of the worst culprits are when they are managers who request the exact same thing 10+ times. These are not even my managers. So now not only do I have to ask why are we hiring these people, but also how did we promote these people?!?!

I do these at first because I am only a jerk in the inside. But I also slowly include the steps to do their requests. Each time they ask after that, the turnaround becomes larger and larger... sometimes to the point where I literally sit there staring at the email thinking how it would have been faster for me to do it than just sitting here but then they'll never learn eventually just not doing it for another X days where X is the number of times they have requested the exact same thing.

Buggish: Microsoft SQL SP Rename for SMO TextHeader and ScriptHeader

 Background: I use SMO to promote objects from one database to another.

Issue: I get error "The name specified in the TextHeader property of StoredProcedure 'StoredProcedureName' must match Name property."

Cause: The one cause I found related to this is when a developer renames the stored procedure. I am assuming they use the sp_rename function. For some reason, this proc does not update the TextHeader or the ScriptHeader. When pulling these properties, these still reference the old name. In my old post, this was a speculation. The reason I found this was because this specific promotion includes renaming an existing stored procedure. In the past, my best guess is that they renamed during development so never needed to submit a rename change in higher environments.

Workaround: My fix is to use SSMS to get the alter stored procedure and execute as is. This unfortunately updates the updated date, but better than being stuck.

Fix request: When renaming object, make sure to update other properties that references the old name like TextHeader and ScriptHeader. 

Reference

https://douglastclee.blogspot.com/2020/09/buggish-c-smo-error-name-specified-in.html