Voice of the DBA

Category: Editorial

  • Independence Day 2022

    Today is July 4th, Independence Day in the US. While many countries have a similar day marking a similar milestone in their history, I live in the US, so it’s a holiday for me and I usually take the day off. Always a good time to rewatch Independence Day, though this year I may take a little time away from chores and watch the sequel, just because I haven’t seen it.

    While it’s a day of celebration here, it’s often a day that somewhat marks the halfway point of the year for me. Just over six months are gone and almost six more to come. I usually look at these milestones and think about whether it’s been a good year, am I approaching life as I want to, and are there things I might want to change for the next half of the year.

    2022 has been great for me, and I can’t complain about anything. I’ve gotten to travel, I had a great season coaching kids, my kids are all 21+ adults and doing well, I’m healthy, and I couldn’t really ask for more. The second half will continue things, though with a little less travel. April/May/June was a rough stretch of time away from home.

    Hopefully you can say that 2022 has been good for you, but if not, what will you change in the second half?

    Happy Fourth of July.

    Steve Jones

  • Christmas in July

    My son asked me to sign for a package on Friday. He was at work and had ordered himself some new joystick for a gaming thing. He told me this was his “Christmas to himself in July.”

    We’ve just past the halfway point of the year, and it’s been interesting. Both a semi-stressful moving on from the pandemic, and a fantastic opening up of life for me in many ways. I’ve had some great trips, experiences, and enjoyed time with people.

    This is a time when many will treat themselves to a Christmas in July, perhaps with a gift or a trip that let’s them enjoy life. I thought about that as I saw a few articles like this one on sales and deals. It’s Independence Day on Monday, a holiday in the US, and lots of retailers use this as an excuse for a sale. I won’t likely get anything techy, but I do need some new gloves since we are putting in 1000′ of new fence at the ranch.

    If you’ve had a good year, is there something you’d reward yourself with? A new mobile device? Maybe some tech-game thing? An upgrade to hardware? Maybe you’ll get a new car, like I did last year. Perhaps you’ll take a trip or partake in some event. I guess I fall into that category as my wife and I have tickets to the jazz festival in Winter Park in a few weeks. We’ll spend a weekend in the mountains as a reward for our hard work.

    If it’s been a tough year, maybe there’s something you treat yourself with to cope with this crazy world. Let us know what you will do, or maybe dream a bit and think about what you might wish you would do.

    Steve Jones

  • The Useful Cloud Tags

    One of the things I’ve seen in working with cloud based resources is that you get a lot of them in your account quickly. A database might end up with a server, an IP address, a network, security groups, and more. A few clicks of the mouse in the Azure Portal can create a new Resource Group that doesn’t just have the one thing you need, but 3, 4, or more other items.

    In addition to the quantity, there are also the problems of namespaces in cloud resources. Some of the items you provision are publicly named in a domain, such as database.windows.net. In these cases, the resources need to be unique among all cloud customers. Just like domain names, this means that you might have collisions with your favorite name. While I might like jones.com, there are a few other people that would likewise prefer this. The rest of us might have to choose jones2.com, stevejonesincolorado.com, or some other variation. In large organizations, you might end up with LA34532345454.database.windows.net for an Azure SQL Database.

    That means that the names of the systems don’t make sense to anyone, and many of the people that need to use or manage them will not even know which resource belongs to which system. This has been true for servers in many organizations for a long time, even with their own domains. Often there is some document, perhaps stored on the root of the machine or in an online share, that provides more information for people accessing the system.

    The cloud makes keeping track of systems harder, and there is a greater need to classify, categorize, and tag resources. Most of the cloud providers have built extensive tagging systems that help users add metadata to various resources and search/filter by these tags.

    Today I’m wondering which tags are useful in the cloud? How do you decide which tags, or type of tags, to apply? You might choose to apply an application name, a business department or owner, or some other type of information that helps you keep track of which resources are needed and how to deal with them. Is there some guideline on the type of key-value pairs you use for tags?

    I also would you want to easily have tags for on-premises SQL Server instances? We do have extended properties, but those are cumbersome. Would you want some sort of easy system query that retrieved all tags. Perhaps something like @@InstanceTags or @@DatabaseTags that retrieved all the data you’d stored in extended properties.

    We are only seeing more and more resources that need to be managed, patched, and deployed. Tagging is one of the ways that helps our organizations keep track of resources, especially if we provision them and we move on to our dream job somewhere else. Let me know how you handle things today.

    Steve Jones

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

  • Returning To An Employer

    I’ve had a number of jobs in my career. In many instances, I left on good terms, and I’d go back to the organization if there was a job that suited me. I’d like to think that many of these organizations would rehire me if I applied, as I did good work and had success. I’ve always been pleased when someone is disappointed at my resignation.

    Intel had a large layoff in 2015/2016 where over 13,000 employees were dismissed. The CEO at the time implemented a no re-hire policy, meaning those who were laid off, or I’m guessing those that quit during that time, were not eligible for employment in the future.

    That policy has been rescinded, quietly, as the company is struggling to find qualified and experienced staff. I think quite a few companies are in the same situation, and they all are competing for good employees. That’s good for us workers, if we have a good reputation, brand, and skills, and likely will lead to higher salaries.

    I see both sides here. Certainly the people that an organization decides to let go would likely be the lower performers, those that don’t get along with others, or perhaps those that make too many mistakes. However, I’ve been through layoffs, and I know that those aren’t the only people selected for termination.

    Managers dislike some people and will let them go. Sometimes managers like someone and keep them, despite them not being as high a performer as others. Workers with other opportunities, sometimes the best workers, might lobby or volunteer to be laid off and get a severance package, knowing they can easily get another job.

    I think most blanket HR policies that don’t allow for flexibility are a poor idea.  There might be some hard rules, like we don’t hire people with financial crime convictions to work with money, but there should be few of these. While most times there are valid reasons not to hire someone, we ought to review individual cases and make a decision about that person. I resigned one job in anger because of an individual (who later quit themselves). I would, however, return to the company and work with many of the other people employed there if I found a good position. Actually, the people almost always matter to me, not the job itself. I value who I work with more than what I do.

    My view is that technology is still one of the best jobs you can take, doing physically easy work for good compensation solving interesting problems. It can be stressful and a burden at times, but many other careers include those same challenges, often without a better compensation-to-effort ratio.

    I am a big believer in finding a great job in your career field that suits you. Doing that takes work, and it takes regular effort to both improve your skills and your brand. Networking matters, whether looking for a new job or avoiding a layoff (or asking to be laid off). Showcasing who you are helps, especially when many other candidates might want the same position you do.

    Whether we are in a labor market of high demand or high supply, you want to give yourself the best chance to land that dream job. Work on your skills, your brand, and actively manage your career. With a little luck, you’ll wind up with an amazing job for you, just like I did.

    Steve Jones

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