Voice of the DBA

Tag: syndicated

  • Daily Coping 9 Sep 2020

    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.

    Today’s tip is to forgive yourself when things go wrong. We all make mistakes.

    Things go wrong all the time. Especially at the ranch, where many things break, or get broken.

    Recently I took a day off to work on some baseboard trim in the house. We had some work done in a couple rooms, and the old trim was taken out and tossed. It didn’t match the rest of the house, and it’s been something I wanted to replace. At $6 a foot for a contractor, who wasn’t thrilled with a 2 room job, and a material cost of $1.42 a foot for about 120ft, I decided to do this myself.

    If you’ve done this, you know it’s not hard, but it’s not a piece of cake. Some attention to detail is needed, and some care. As I worked my way around the two rooms, I find the flor wasn’t quite level, and so sometimes the trim needed to bend over a slight rise or meet a dip. This resulted in a few joints not matching perfectly. Add to this that I cut a few pieces incorrectly as I got them down.

    I know some imperfections get covered with paint or caulk, but as I got close to finished, I wasn’t happy with two pieces. Rather than get upset, I just pulled them out, cut new pieces, one I cut 2 or 3 times, and made things slightly better.

    A small thing, but it’s a lesson I’ve learned from work and life that I will make mistakes. I should aim for, and work to, limit mistakes and try not to repeat them, but sometimes I do, and it’s not the end of the world. Move on, correct things as best I can, and forget about them.

  • Automation Ideas for T-SQL Tuesday #130

    tsqltuesdayThis month we have another great T-SQL Tuesday topic, and again, a host that I pressured into writing the invitation. Elizabeth Noble (@SQLZelda) and I were talking DevOps last year at a SQL Saturday, just as she was effecting some change at her employer. At an event later in the year, I challenged her to host, and here we are, with a great topic, Automation.

    That’s this month’s invitation. Elizabeth describes the process of using automation to smooth out their deployments to SQL Servers. They slowly built a CICD pipeline and migrated projects over and over to save her time.

    This month, what have we done to automate things? I have a few stories.

    Automating Data Collection

    One of the things that I am passionate about is the SQL Saturday events. I loved that PASS maintained a site, and made a feed of event data available, but over time, we’ve lost some data and I don’t think there is much impetus to maintain this over time.

    As a result, I build an automated process to grab data from the feeds and save it as an XML file on my local machine. I have the basic code up at GitHub, though I need to improve and refactor it a bit. These files change as the organizers update them, so I need a good merge process. Right now I tend to delete all 1-2KB files periodically, as the file is built once the event is approved. However, until all the speakers and sponsors are scheduled the file size is just a few KB. Most events are > 100KB once they are set.

    This is a basic way of grabbing some data, and I’m looking to build a few more data collection processes to grab data in my life and keep it around, just in case some service I use goes kaput.

    Automatic Databases

    I work at Redgate, and one of the things I’ve been spending more time doing is the automation of databases for development with the latest code and test data. This is a challenge, but a few of the things that I’ve done with Redgate that help are as follows:

    1. Use Powershell to automate the creation of SQL Clone images.
    2. Use PowerShell to update SQL Monitor alert values and add instances
    3. Use Flyway in a container to deploy changes
    4. Use our SQL Change Automation cmdlets to deploy changes to databases

    All of these items can be automated so that a user just needs to run a script, or sometimes just click a button.

    I’m slowly getting the PoSh code up on GitHub as I build demos and help customers get things done. Right now, getting organized is the biggest part of my job, because I find these questions coming over and over.

    I’m a bit proponent of DevOps and automation. Use tools and computers to do the tedious, repetitive work. Keep your day focused on solving problems and building/improving scripts.

  • Daily Coping 8 Sep 2020

    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.

    Today’s tip is to free up time in your diary by cancelling any unnecessary plans.

    I keep busy. In fact, I rarely take a day off from everything. If not work, I coach, I look to exercise most days, and even on weekends I look to tackle at least part of a project at the ranch.

    That being said, I have started to try and find days where I don’t plan things. I might tackle less things, since I’m disinclined to just sit around, but I won’t make a goal for myself and I might just wander through part of a project or a chore.

    I’ve also taken to cancelling plans at times to free up a few hours of life. Maybe I’ll cook something, or play guitar, or watch a movie, but when I have more than 3 scheduled things in a week, I might look to cancel one or two to find time to unwind a bit.

    I did this recently, when my wife and I were scheduled to go out with a friend. With multiple things on our schedule, we agreed to reschedule and push things back a couple weeks.

    Downtime is good, even if I don’t always want to take it.

  • Daily Coping 7 Sep 2020

    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.

    Today’s tip is to be willing to share how you feel and ask for help when needed.

    I struggle with this. I’ve grown up fiercely independent, even with family. I’ve had to work hard to make my way in the world, and I tend to try to do things myself.

    However, I know that’s not completely healthy, and I need to get help at times. During this pandemic, I’ve tried to remember this, and during a particularly hard time recently, I just had to walk away from something and ask my wife for help. I almost didn’t, but I am glad that I did. It was a relief and good.

    I need to do this more, and find ways to not only continue to support and help others, but also reach out and let others help me.