Voice of the DBA

Author: way0utwest

Declining Work for Mental Health

This year has been a busy one for me. I had 30 trips on airplanes away from home and around 100 nights not in my own bed. It’s been quite a year, and a little overloaded. There have been a few months were I traveled little, but more than a few where I was gone more than I was home. I spent 19 nights away from home in September.

A few weeks back, I realized that I had another long trip coming up in October (9 days) and the PASS Data Community Summit in November. My body is a little worn out, but my mind is also distracted and struggling to focus. I recognized the beginnings of burnout when I realized that I was slightly dreading the Summit trip. While I want to see friends and catch up, I wasn’t looking for a long trip.

On the spur of the moment, actually while sitting in an airport and waiting for a flight, I sent a note to the SQL Saturday Oregon organizers asking them to withdraw my speaking submission and not select me. I felt bad for doing so as I try not to create work for others or submit to events without the intention to go, but the extra 2 days in Seattle would make lift hard, and I thought this was the best choice for my mental health. I also chatted with my boss a bit about some work opportunities that were coming up and decided to decline a few other things, as well as skip conference submissions in Q1 2024.

I’m not burned out, but I do recognize that I’m overloading my body a bit. Physically it’s a bit worn out and I can see that in my frequency and effort at the gym. Mentally I’m slightly dropping the ball on a few things, working slower than I often do because I find myself slightly distracted and looking for more breaks.

One of the big learnings for me over the pandemic was that I need to ensure I take care of myself and treat myself as I’d treat someone else in similar circumstances. I’ve had coworkers and friends struggle at times in life, where I’ve made an effort to work more and help them work less. I need to remember that for myself and ensure I can lean on others where needed. Redgate is an amazing employer and everyone is willing to flex with each other to ensure work gets re-distributed or we move deadlines. My manager and I have discussed this, and we are monitoring my workload moving forward in our regular meetings.

One of the best things I’ve learned over the years is to say no. I say no a lot to various queries on my time. Often when I feel I can’t deliver on time. This year I was looking forward to these opportunities, perhaps a bit too much, and ran myself down a bit with over-excitement. I recognized that and made an effort to take steps to help myself before I burned out or started missing commitments.

The last month (and half of the next one) has been a bit rough, but I’ve mentally prepared myself for the work, and seeing relief coming in a couple of weeks is helpful. I’ve learned a bit more about myself this year, especially in relation to my slightly changing job and hopefully, I’ll do a better job managing myself next year (or my boss will).

Learning to balance work and life is important. Remembering that life, family, friends, hobbies, faith, etc. are more valuable than work, and we need to ensure we don’t overwork ourselves makes us better employees and better people. Any of us can get overloaded in the short term, but don’t let that become an accepted part of your life. Your employer may push, but learn to push back and protect your physical and mental health.

Steve Jones

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

October 20, 2023
A New Word: Gobo

gobo – n. the delerium of having spent all day in an aesthetic frame of mind, taking photos across the city, getting lost in an art museum – which infuses the world with an aura of meaning, until every crack in the wall becomes a commitment to naturalism, and every rainbow swirling in a puddle feels like a choice.

I wish I could get lost in an art museum, but it’s not my thing. I can enjoy them for a bit, and I like having various Van Gogh paintings as a part of my wallpaper, but only for a bit. I do, however, enjoy spending a few hours wandering a city, taking pictures, and enjoying the world for what it is. My wife and I do this more often than hitting tourist attractions when we travel. Instead enjoying life in another place as it exists during a normal day for many others.

I do try to stop and enjoy the world I see, big things and small, as I go through life. I rarely spend all day doing anything, but I do enjoy the moments when I can.

From the Dictionary of Obscure Sorrows

October 20, 2023
Practicing (Annoying) Better Security

At Redgate Software, we’ve been looking to “level up” our internal security game. While we have had very good security during the 16 years I’ve been there, there have been a few security issues with our products. The speed at which we address things, as well as the communications with customers, has impressed me.

We’ve had almost no problems with our internal systems, unlike a few other places I’ve worked. We haven’t had the phishing/virus/breach/ransomware issues that I’ve seen at other employers or heard about from friends. I do think our IT staff is diligent and careful, as well as forward-thinking. It also helps that we’ve had a relatively small employee staff that worked in physical offices for most of our existence.

Recently, we’ve been on a security push to tighten up the way we deal with systems. As we grow our staff, and as we add more offices, there is a recognition that our attack surface area is growing. We also find more and more people using non-Redgate-owned devices. This year we’ve had a series of policies rolled out that we are supposed to adhere to in order to ensure strong security, as well as compliance with data privacy rules such as the GDPR.

One of these is a bring-your-own-device (BYOD) policy. For years I’ve used my personal mobile phone for Redgate, with a few settings enabled to allow a remote wipe if I lose it. However, I’ve also had a personal desktop that I use for daily work in my home office. I’ve never enabled a lock on this as my wife occasionally uses it to get a picture or other document. Or send me something I forgot to sync in the cloud.

Part of our new policy is that I need to enable a lock on my desktop, as there is privileged Redgate information on there. Not much Redgate data, but the machine does connect to our business OneDrive and SharePoint systems. This lock should be a 2-minute timeout, which means that I come back to my desktop after coffee, laundry, or something else to find it locked. After years of always locking my desktop in corporate offices, I somehow find this more annoying. Especially as I’ve gotten used to rarely typing my 15-character password. I mess this up regularly and have to (more slowly) re-type my password a few times.

I know this is better security, and I am always conscious of locking my laptop in our various offices when I go in. However, I find it annoying at home. Especially when I pop in away from work to look up something on the Internet. I keep telling myself this is good security, and good for both Redgate and our customers. I’m still annoyed by the change, but I know it’s for the best. Like many who work in organizations, I’ve been lazy about some security aspects for years, and the change is a disruption. I’m sure some of you feel the same way about the rules and protocols that your employers have implemented.

You’re not alone in desiring a more convenient workplace, but security is a series of overlapping measures that work together to protect data. Practicing and adhering to good security is a lot like a daily backup. Most of the time it’s something never need, but when there’s an issue you’ll be glad you followed the process that day.

Steve Jones

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

October 18, 2023
Creating a SQL Clone Image from a SQL Clone Database

A customer asked if a new image could be created from a database that was itself a SQL Clone. It can, and I’ll show that in this post.

This is part of a series of posts on SQL Clone, which is a virtualization product from Redgate Software.

Creating a New Image

To start with, I’ll look at the clones that I have deployed on a test server. As you can see below, I have a database, called “SimpleTalk”, on a local instance.

I’m going to use this to create an image. First, I’ll click “Create Image” on the left. I’ll choose SQL Server, since I will use the existing cloned database as the source.

I pick the instance and database. As you can see, I’ve chosen the database that was listed above as a clone.

Next we skip the classification screen. This is a test db, so no data in there to worry about.

I’m not going to modify this, as this is a test.

Now I pick the destination, which is a local share.

I give this a name which differentiates from the original db and other images. I normally want to name all images as _new or _current for rotation purposes, but here I’m adding a test name since I’ll delete this right away.

You can see this start working.

And it completes in about the time for a restore. If I had added masking, this would run a little slower.

I have the image created, so it’s time to test this with a new database.

Validating the Image with a Clone

Click “Create clone” on the left menu and you get a dialog that asks for an image. I’ll pick the one I created above.

Once we chose the image, we can modify it. We won’t here.

Now we add an instance and a name. I’ve entered those below.

Once this completes, I can see this database, and my other clone in the SSMS Object Explorer.

If I query both databases, I get the same data, since I haven’t changed either one during this process. Note below that each one of these queries is from a cloned database.

The SQL Clone cloned database is just a database. SQL Server sees it as any other database, as SQL Clone presents the mdf/ldf/ndf as any other database. You can back it up like any other one.

If you are looking to save storage space for multiple copies of databases, or give each user a consistent copy in seconds, check out SQL Clone.

October 16, 2023