Daily Coping 30 Dec 2022

Today’s coping tip is to give thanks. List the kind things others have done for you.

I know that my life is great, but it’s because of a lot of help I get from others. I do a lot, but I can’t do it alone.

I thank my wife for supporting me and comforting me.

I thank my kids for the same, and for helping out around the house, which lets me tackle other things. Not the least of which is helping their Mom so I don’t have to do as much on the ranch.

I think Andy, my former business partner for the friendship, counsel, and reminders of things that I should think about, but sometimes don’t. He helps keep me balanced and thoughtful about the world.

I think my bosses at Redate this year, Tom and Annabel, for the support and help at work. Cecilia was wonderful in supporting me at events, and lots of others taught me things and helped me through the year. They helped me cope and thrive during a busy year.

I thank all the SQL Saturday organizers for their efforts during a tough year of restarting the brand. I think the speakers and helpers for volunteering and the attendees for coming. It was a year that exceeded expectations (blog). These people helped me with inspiration and confidence this was a good idea.

I thank my friends for the time, conversations, lunches, dinners, drinks, and wonderful times spent together, which fulfilled a lot of social needs.

I want to thank the kids on my volleyball team, both for the 2022 season and those I’ve started to work with for 2023. They give me hope for the future, they extend my family by being a set of surrogate daughters when my own is away from home most of the time (and not a child anymore), and they inspire me to work harder with their efforts.

There are plenty of other people to thank, but these are the top of my list.

I started to add a daily coping tip to the SQL Server Central newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 30 Dec 2022

Daily Coping 29 Dec 2022

Today’s coping tip is to ask for help and let someone else discover the joy of giving.

I do most of the cooking in the house, but I thought with family around, I’d get some help. I usually don’t mind preparing, but a few times I asked others to help out and handle some tasks or prepare a portion of the meal. Little things, as I like cooking, but I also thought others would enjoy the chance to contribute.

Hard for me, but it was still fun to let others help. I’ll try to do this more often.

I started to add a daily coping tip to the SQL Server Central newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 29 Dec 2022

Solar Projection v Estimates

We got a solar system in 2022 to try and fix some of our power costs and hedge against the future. We were fairly confident it would work well, but weren’t 100% sure. So far, it has reduced our power bill quite a bit, though it’s a bit hard to tell right now if this is actually saving much money.

However, the performance is above what was estimated. I’ve built a Power BI Report that tracks the actual production v the estimates. So fat, almost every month has beaten estimates and our power production is well above what we expected.

Given the fact that power prices have increased in CO and I expect more increases to come, this is nice.

I can’t embed the report here, but this is an image of the report:

Power BI report of production v estimates

I need to add some more costing here, but our current bill is often around $22/month, of which $13.50 is a connection charge. Usually we are paying around $8-12 of demand charges for peak usage from 4-8pm. Hard to get the family to slow down here, and there isn’t much solar during this time.

This is, however, much better than last Nov/Dec, when we had $220 bills. Even with the loan payment, I think we’re paying less than in the past.

Posted in Blog | Tagged , | 9 Comments

The End of Year Career Evaluation

This month’s T-SQL Tuesday invitation asked about end-of-year operations that you might take on your databases. I don’t know how many of you follow any specific end-of-year routine, but you may.

However, that got me thinking about an end-of-year career evaluation. It’s not something I’ve done, but I do often look back and forward and build some career goals. That has been helpful in ensuring I do some work on my career each year, even though I’m much closer to the end than the beginning.

If I were younger, I would look at my career in three ways: what I need to learn, what I want to accomplish, and how to move toward my goals. I’m actually going to tackle these three areas myself, but since we’re near the end of the year, these might be things you think about as well.

Technology changes so much, and we are often challenged by new requests, requirements, or circumstances to work with new software. I think the cloud has spurred this on, and as a result, I expect most people find they need to learn things constantly. Having a plan, and keeping a list of the technology is a good way to capture the entire bundle of challenges you face. Whenever someone asks you about something new, or you hear in a review that you should improve, add those things to your list. It’s likely you’ll never get to them all, and certainly, you won’t be an expert in them, but you can develop lots of competence and fluency in different areas.

The second thing to look at is how to take this big list of skills, languages, software, etc. and prioritize it. Cut the list down to something manageable this year. Or maybe just this quarter. Being organized can help you deal with the overwhelming number of items on your big list. In this stage, I’d order things by what’s interesting to you. This might be an understanding of YAML to update pipelines as code. It might be solving some types of complex queries in SQL that you struggle with. It might be learning to better express yourself clearly and succinctly in email. List the things you need to work on.

This isn’t easy, and this is really a prioritization of what is most important to you. You might talk with co-workers, your boss, or your partner to help decide what you can do. You should also think budget here, in terms of your time. Can you spend more than 8 hours a month on something? Carving out 2 hours a week is likely manageable, but more can be hard. Think hard about this, especially if your employer doesn’t give you any time while at work.

The last evaluation should be easier. It’s taking the things you are working on and building a plan to actually improve yourself. Do you need to draft better crafted emails and have people review them and give suggestions? Are you going to pick specific problems to solve in SQL? Maybe you want to tackle a specific Power BI report? All these are examples I’ve used myself, but you might have different things from your second list. This is the short-term plan you’ll implement.

I wouldn’t make this too detailed a plan, but I would include enough to guide you. Maybe this is actually spending a month of lunches on something? Or just two lunches a week? I wouldn’t schedule them all out, but I’d have some specific things I need to tackle, in some order, which at least gives me a plan. I wouldn’t include timelines here, but rather, what is the first thing to do, the second, and so on.

This sounds like work, and it is. That’s how you move forward, and how you shape your career to be what you want. Be deliberate, make decisions that are best for you, and then execute on those decisions. That will help you find the best career and job for you.

Steve Jones

Listen to the podcast at Libsyn, Stitcher, Spotify, or iTunes.

Posted in Editorial | Tagged | Comments Off on The End of Year Career Evaluation