Daily Coping 19 Aug 2022

I started to add a daily coping tip to the SQLServerCentral 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.

Today’s tip is to no plans day – Be kind to yourself and others.

Unlikely today. Yoga scheduled, and perhaps a high school volleyball game. I also have to get the database weekly editorial done, so this is on the list.

However, I had this day last weekend. I spoke at SQL Saturday Los Angeles 2022 and since I was already traveling, I asked my wife to come with me. She enjoyed a day at Venice on Saturday while I was speaking.

Sunday we had no plans. We woke up and had a late breakfast before driving downtown to the “Wake Me When I’m Free” exhibition of Tupac Shakur’s life and music. Loved it, especially this quote. I think this is how I view the world.

20220814_122549

We then drove up to Oxnard, enjoying the view along the coast. We had an early dinner and then came back for a bike ride from Venice to Santa Monica and back. A quick drink by the water before calling it a day.

20220814_191534

Nothing planned, just deciding at each moment what to do, and a great, relaxing time for us.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 19 Aug 2022

Daily Coping 18 Aug 2022

I started to add a daily coping tip to the SQLServerCentral 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.

Today’s tip is to share an encouraging news story to inspire others.

The drought is receding a bit in Colorado. I personally am concerned because we have land and fire is always a danger. Plus more drought means less hay, which means more $$$ for the hay we buy. It’s already near an all time high, so hoping more rain eases the situation a bit for the third cutting.

Also, COVID is declining. No matter how you view the pandemic, having less cases and hospitalizations means that we open more things and more people get back to their normal, 2019-era, lives.

Posted in Blog | Tagged , , | Comments Off on Daily Coping 18 Aug 2022

Creating TAIL on Windows for Text Files

UPDATE: Article changed based on the comment from Mr. Sewell.

I wrote recently about making a HEAD utility to find the top few lines from a text file. I used Powershell and scripting to make this work from any Windows command line on my machine.

Someone asked about TAIL, which is easy, so I did this as well and set up a tail utility.

Get-Content in Powershell will do this, so I took my head.cmd and did a save as in VS Code.

2022-08-15 15_02_49-Save As

Then I changed the “first” in the code to “last”, as shown here.

UPDATE: Based on a comment from Mr. Sewell, I updated the code.

There is a tail parameter for Get-Content, so let’s use that.

powershell "get-content %1 -tail 10 | select-object"

This gets me the end of a file. As an example this is below. Here’s a text file I have with various values. As you can see below, the bottom values are zeros.

2022-08-15 15_19_39-D__Downloads_Chart Export 08_15_2022 21_19.csv - Sublime Text (LICENSE UPGRADE R

Here’s my tail utility working:

2022-08-15 15_23_49-D__Downloads

UPDATE: I left the original piece below in italics, but with the tail parameter, this takes a few seconds.

If I run this on a larger, 1.5GB file, it takes a few seconds.

tail parameter change and quick execution

In case you’re wondering how this works on larger files, it can be slow. This took 3 minutes on my machine to get the last ten lines of a 1.5GB file.

2022-08-15 15_28_58-D__Downloads_imdb

Posted in Blog | Tagged , | 2 Comments

DBA to Data Engineer

When I was starting my career, I expected to be a programmer. That’s what people who wrote the software were called. At some point they adopted “developer” instead, shunning the programmer label. Now I see software engineers has replaced developer in many organizations. I’m not sure the job is much different than it was in 1990, other than the specific technologies used.

The DBA used to do a lot of system administration-type work on database instances. Check logs, set security, run backups, and maybe look at some queries. However, in many cases, their work was limited to things running inside the database software, or the database software itself (patches, related configuration for the host OS, etc.). I saw recently that DBAs have started to adopt the data (or database) engineer label as a new job title. Presumably, this pays more because, well, it sounds like it should. Data Professional sounds more comprehensive and skilled than Database Administrator. Database Engineer sounds better than both.

Is it better? I do think that many people working with databases are being asked to learn and do more (and new) tasks as a part of their daily work. We often need to support and maintain a wider variety of different systems. If it’s the same platform, then we often support more versions, especially with the 2-3 year cycle of releases of SQL Server. However, we may also need to learn a bit about other platforms, like Oracle, MySQL, PostgreSQL, etc. We can add the ability to work with and deploy new languages, like R or Python, and that might help us land a new position. Certainly understanding cloud database platforms and options, their deployment, and monitoring can be useful in asking for a raise or interviewing for a new position. Scripting, PowerShell, and DevOps are good skills to showcase as well. All of those might be in a Database Engineer description.

Why bother adding these skills? Especially if you have a good job and are comfortable. You never know when things will change. Your company might downsize, as Ken’s did. They might get bought by another organization and your job could change (or disappear). It’s possible that your family situation or some life event might make you look for a different job. There are lots of possible reasons why you need to change your current employment.

If you want a better job, perhaps more compensation, better hours, remote work, less late night calls, or something else, then it’s not a bad idea to beef up your skills. Learn to automate things in a better way, which might make your current job easier. Experiment in the cloud, maybe do a small PoC of how you might move or deploy a current workload into a VM, a PaaS service, or even a new platform. Can you migrate from one database platform to another? That’s a useful skill to showcase.

I have found that a lot of the really good jobs are a hodge-podge of different skills. Being adaptable, comfortable learning, and trying to grow are important skills to demonstrate. Even more important, learning to talk smoothly with others about why you made a decision or recommend something is a key skill to getting hired.

Sprucing up your titles can help, especially with HR where new titles often mean new salary ranges. SRE Engineers were only at Google at one point and their high salaries set a bar. Engineer, Scientist, Architect, these are all better than Administrator. Boost your skills (tech and soft) and you might find a new position that is even better than the one you have today with potentially a new title.

Steve Jones

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

Posted in Editorial | Tagged | 1 Comment