Author: way0utwest

  • Resetting an Azure SQL Database Admin Password

    This is likely something that most people know, but it was a bit confusing for me. This post is really here to remind me and help cement this in my mind.

    I went to connect to a QA database that I don’t use very often, and for some reason, I couldn’t remember the password. I tried a number of them, but none worked. Not the best situation to find yourself in.

    I then decided to just reset the password and went to the database Overview. This is what I saw:

    2019-11-26 17_53_06-Sandbox (dkranchapps_Sandbox) - Microsoft Azure

    I could have sworn there was a “Reset” option here. I even tried searching a few places and there were people that mentioned there being a reset. Why wasn’t I seeing one?

    Because I was in the wrong place. Reading closer a post on the Tech Community, I see that I need to be in the SQL Server server blade, not the database.

    Once I realized that, I clicked over to that spot in the portal. Looking at my SQL Server, and I see the Reset.

    2019-11-26 17_56_42-dkranchstaging - Microsoft Azure

    Slightly confusing, and certainly something I hope I remember from here, but if a new developer is working with databases, they might not realize this.

  • HSA for Training

    Most of us don’t get any sort of training budget from our employer. In fact, some of our employers expect us to learn more and get certified on our own time and our own dime. Relatively few of us get to attend a conference that our employer pays for, which is a shame. I think conferences can be exciting and encouraging in helping you drive your career and knowledge forward.

    This is one reason that Andy Warren and I started SQL Saturday. We wanted to bring the conference experience to many people whose employers might not pay for a trip. That has grown to over 100 events a year, all around the world, primarily thanks to tons of local efforts and the support of PASS.

    For most of us, however, training involves some cost, often financial. Some people pay for a class or conference themselves, many pay for books, and some get their employer to provide funds. Asking an employer, however, is a chore, and this can be intimidating for many people.

    Managers often are whimsical about approving training budgets, even for things like books. Either the employee really has to justify the cost (conference) or they may feel silly about asking for a small amount (a book). Managers also need to track and somehow justify their spending on training and balance this among employees. This creates friction and hassles for everyone.

    Perhaps there’s a better way. For those in the US, you might be familiar with the Health Savings Accounts (HSA) for medical expenses. In these, an employee can put away their own money for use on whatever medical costs they may incur. There are tax advantages here, but perhaps that would be something that would work for training.

    Imagine an HSA for training, where the employer would designate an amount that each employee could use for training. This would be per year, with carry over amounts. The total budget per year might also be based on job and seniority. There also wouldn’t be a need to seek approval, but rather, notify someone that you were using funds for some educational experience.

    In any case, the employee would have a fund that they could use at their own discretion, and be both responsible and accountable for training. Maybe there are caps on accrual, or a limited list of places to spend the money, but this would remove some of the friction of keeping employees trained. We treat them like adults and expect them to make good decisions for their career. If there are issues, we handle them on a case by case basis.

    I’m wondering if any of you have a training budget that is better structured. Perhaps some of you always get your requests approved, and perhaps some of you never ask. Let us know today what you think of this idea, and would this encourage more learning at your organization?

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • The Ransomware Hero

    One of the common attacks against many organizations today is ransomware. I’m constantly surprised when I see friends and they tell me they’ve been attacked, but the incident never made the news. I think many people would be upset with businesses if they knew the extent of attacks, but I also think that this would force more organizations to implement better security if shareholders and customers were aware of the incidents. This might even get employees and others to be more careful about the things they click and do, though that might be wishful thinking.

    In Illinois, in the US, there is a guy that is fighting ransomware and helping out both organizations and individuals. For free, which is much better than paying the fee, something plenty of organizations have done. Michael Gillespie runs ID Ransomware, a site that helps you determine what type of attack you’ve had. It can also possibly give you or generate a key that will allow you to decrypt your files.

    This man does this in his spare time, while working as a computer support person. It’s an amazing story, and one that is a little sad. Here is this man that doesn’t want to charge, and wants to help, but has struggled financially while doing so. Things have gotten better, and more people are supporting his efforts, including Emsisoft, who has hired him part time.

    If you get struck, it might be worth a visit to ID Ransomware and see if you can get some help. If you do, convince your boss to donate some payment to support Michael’s efforts. It’s a good cause, and certainly cheaper than paying a fee or losing lots of work while you try to sort out the problems.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • A Quick Look at Travel

    I was experimenting with visualizations the other day, and started playing with SandDance, a tool from Microsoft that you can use in Power BI or Azure Data Studio. I’ll write more, but I loaded up a quick look at the last couple years of travel for me. Here are airlines v destinations:

    2019-11-25 16_02_17-SandDance_ unitedactivity.csv - Sample Data - Azure Data Studio

    Since I live in Denver, obviously that should be my top destination, but a few others are surprising. I go to London quite a bit, but LAX was surprising to me. It shouldn’t be, as I’ve flown through there quite a few times to get to London.

    I’ll write more about this later, but I thought this was an interesting visualization.