Projects To Showcase Your Skills

It seems I’ve heard from a lot of people looking for jobs lately. I had a friend reach out and when I posted a note on LinkedIn I had someone looking for a job, I heard from a few dozen others that they were in the same situation. The last year has seen a lot of turnover in IT. There have been lots of big (and small) companies that have let staff go, for a variety of reasons. The why doesn’t matter to you if you’ve lost employment. You just need a new job.

At the same time, I hear from lots of customers and friends that they are struggling to find good talent. They have openings, but none of the people interviewing have good skills.

That’s an interesting mix of situations. There are jobs and companies want to hire people, and there are people needing jobs. However, there don’t seem to be enough good matches, and my guess is we have some skills mismatches here. In other words, candidates aren’t showing they have the skills employers need, or at least not at the depth employers need.

A lot of success I’ve had in the past is being good at some tasks with a database, but also showing employers I can learn about other tasks easily. Some of that is from blogs or answers on forums, and some of that is showcasing those skills in interviews. I think that many managers will accept they might need to teach you or train you on certain things, but they want confidence you can learn and grow.

Good interview soft skills help, but showcasing learning and growth helps as well. Blogging is a good way to show that, but what do you blog about? My advice to students is to explain how they solve the problems they’re given in coursework. Show what you learned, from where, and how you chose to solve a problem with the resources used.

I would say that experienced workers can do the same thing. Take on some sample projects that build or design a database. Work on a sample dataset and produce queries to answer questions, explaining what the goal is and then how you solve the problem. Show how you can improve a project by refactoring code, and then proving things are better with execution plans and performance numbers.

Show you have skills to get some things done, and the skills to learn how to solve complex problems. Hiring managers need to have this confidence in you.

If you have ideas for a project, let us know in a comment. What types of projects have you worked on that you were proud of the solution? What sample datasets have you used to learn? We all can improve our skills in some way, and perhaps a few specific ideas will get some of you moving in the new year.

Steve Jones

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

Posted in Editorial | Tagged | Comments Off on Projects To Showcase Your Skills

A New Word: agnosthesia

agnosthesia – n. the state of now knowing how you really feel about something, which forces you to sift through clues hidden in your own behavior, as if you were some other person – noticing a twist of acid in your voice, an obscene amount of effort you put into something trifling, or an inexplicable weight on your shoulders that makes it difficult to get out of bed..

There are a lot of times I’m not sure how I really feel about something. Whether it’s something in the state of the world (politics, government, culture), or it’s a technical item. There are many cases where I’m just not sure. I have to stop and think outside myself, and often think about how I would react if things were structured one way vs. another.

In the tech world, I’ve often been a little uncomfortable with EULAs and software licensing, but I also don’t quite know if I would abandon most copyright/IP/patent/ etc. I’m not sure if I think the world (or my life/career) would be better or worse.

Sometimes it’s smaller, like the way someone else tries to teach me a topic or present an idea, or perhaps the way that an event is organized. I don’t pretend that I know better, and try to remember that I might go about the item/task/etc. differently, but I don’t know if I would. It’s easy to react, and much harder to make decisions and act without the benefit of hindsight.

I do use agnothesia, trying to step outside of my own emotions and feelings and look at what a situation or idea changes in me, as if I’m studying myself. I don’t often come to any resolution or learn anything, but it helps me to remember I’m just one person, part of a larger community and society, and life can be hard when you don’t have all the answers.

Or as I feel, many at all.

From the Dictionary of Obscure Sorrows

Posted in Blog | Tagged , | 2 Comments

Skipping SQL Bits 2024

SQL Bits has been my favorite data platform event for years. Both it and the PASS Data Community Summit hold special places in my heard and I enjoy going, but the community, casual feel of SQL Bits is just a bit more fun for me.

I’m sad to be skipping SQL Bits 2024, but the timing doesn’t work for me. I saw Brent was also skipping (for different reasons), and decided to state my own reasons, since I have often attended. This was also Brent’s most commented on post in 2023, so I’m hoping to start the year off right on this blog Winking smile

Managing Workload

In 2023, I had 32 trips. By mid Oct, I was a bit worn out and struggling. I just wanted trips to be over with and get back home. Between my last pre-Summit event in early Nov and the PASS Data Community Summit, I was home for 12 days in a row. I hadn’t done that since May 2023.

As a result, I’m trying to be more careful with travel workload in 2024. My boss and I meet every week or two and we review the schedule for the next couple months to manage things.

I also coach volleyball in Q1 and I try not to miss events or practices so I try to limit my travel.

Scheduling

While I local SQL Bits, I’ve missed a number over the years because of scheduling conflicts. Their March events have conflicted with other events in my life, often outside of work. I preferred when they had an Aug/Sept event as well.

This March, I am committed in March from the 9-11th, and then have to be in Atlanta on the 13th-14th. I have the next week at home, and I could potentially go to the UK on the 18th, but I have to be back on the 24th to coach an event in Denver. That means leaving Sat from the UK at the latest, and leaving SQL Bits on Friday. I’ve done that before, but I have to miss some practices in Denver that week and it’s not worth it just to indulge myself in another event.

I also have to be back in the UK in April and travel the in between week in the US, so I’m thinking that this is a time when I could make the schedule work, but it would impact my managing my workload.

Skipping a Year

I’ve been blessed and honored to speak at many events. While I would like to go back and enjoy SQL Bits, I also want to make room for others and let them enjoy the experience. Missing a year is OK, and I’ll look forward to 2025 (and cross my fingers that the date doesn’t have workload or scheduling impact).

If you’re anywhere near London or can get there in March, attend the event yourself. It’s fantastic and a lot of fun.

Posted in Blog | Tagged , , , | 1 Comment

Changing the Origin in Git–#SQLNewBlogger

I needed to show a customer how to migrate from Azure DevOps to GitHub recently, and to smooth this process, we needed to repoint the origin remote.

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. You can see all posts on Git as well.

Changing the Remote

When you want to see remotes, you run this code:

git remote –v

As you can see, I have my origin pointed to Azure DevOps..

2023-12-19 11_46_54-cmd

Now, I can delete and add back the origin remote if I want, but there is an easier way. I’ll use the set-url parameter with this code:

git remote set-url origin https://github.com/way0utwest/DatabaseDevOpsMS.git

This points the origin to my new remote in GitHub. Once I run this, I’ll set the branch and push, as the GitHub repo is empty. This pushes everything to GitHub and voila, I’ve got code there.

2023-12-19 11_48_22-cmd

You can see this online

2023-12-19 11_35_59-way0utwest_DatabaseDevOpsMS — Mozilla Firefox

SQL New Blogger

I had to write this up in more detail for a customer as documentation. You might do this at work for someone, but I grabbed this focused, small piece of this and created my own blog, reusing a few screenshots.

Note: Don’t reuse screenshots of company assets. Recreate this in your own space.

This took me only about 5 minutes to write up after the other work was done. You could easily do that.

Posted in Blog | Tagged , , | Comments Off on Changing the Origin in Git–#SQLNewBlogger