Author: way0utwest

  • Defending Against Ransomware

    I don’t manage production systems at Redgate, and I’ve not seen us have any disruption in the access to systems across the last few years. At a number of events, however, I’ve spoken to friends that have told me about the problems they’ve had with ransomware. I’ve been quite surprised how often this happens, as I see headlines, but none of the half dozen or so people I spoke with have worked at any company in the headlines. This is likely a bigger problem than I thought.

    I don’t know if you’ve been attacked, but you should be prepared. Denny Cherry has had to deal with this at at least one client, and he wrote a few things down in this article. He doesn’t necessarily recommend you pay, though that’s certainly an option. If you do, you should be prepared for future attacks or other issues. Anyone that wants to hold your data hostage once might be inclined to do it again.

    Apart from backups, air gaps, and other preventative measures you might take, including limited access between some workstations and servers, you ought to be sure you can rebuild systems that work in a similar manner to the current ones. Do you know what the specs and settings are for all your systems now? So many people assume they could just go get that information from the system itself, but what if you VMs and VM host are compromised? What if your monitoring system is encrypted? Do you really know all the settings that have been changed from defaults? If your DR plan somewhere outside the network and can you get to it?

    This is a good reason why DevOps and infrastructure as code (IaC) are important in a modern organizations. In these cases, a VCS can hold the data you need to rebuild systems. This is a good reason by using GitHub or some remote VCS might be better than self-hosting your code. If you routinely rebuild systems for dev/test, you’ll have some idea of how to deploy, and if you think about IaC as a part of your DR process, you should be able to redeploy on new hardware (or existing hardware that’s wiped clean).

    Ransomware is a part of the new world we live in, and we ought to be prepared to defend against it. Ensure you’re ready today, because there will likely be a ransomeware or other types of attack in the future. The more prepared you are with better practice now, the more likely you’ll be ready to adapt to some other security need in the future.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • T-SQL Tuesday #126–Folding@Home

    tsqltuesdayIt’s T-SQL Tuesday time, and this one is interesting. This also relates to the desktop upgrade I wrote about last week. Glenn Berry is the host, and he asks us to talk about any work we’ve done with Folding@Home.

    If you’d like to be a part of T-SQL Tuesday, get a blog and post on the second Tuesday of the month. Follow the Twitter #tsql2sday hashtag of check out the sqlcommunity.slack.com channel for T-SQL Tuesday.

    Supporting a Cause

    Years ago I did some of the work for the SETI project, by setting an agent on my home machine. At some point I rebuilt the machine, forgot I’d had this set up and went on with life.

    With the recent Covid-19 pandemic, Glenn wrote about supporting the cause by using some of your CPU cycles to process data for medical teams. I was interested in this, along with some other ideas, and this was easy for me.

    I’ve been in the process of rebuilding my home machine, as I wrote about. While I’m slowly moving things over to the new machine, I am using it online as a client for the Folding@Home project, donating CPU cycles for whatever medical research I can. With my old machine also running, I’ve been getting quite a bit of work done overnight as I set both machines to use lots of resources.

    Other Covid-19 things I’ve been doing are the daily coping tips, which I’ve put in the SQLServerCentral newsletters, on my blog, and on the Community Circle. Small things, but more than a few people have noted they help.

    A few minor things:

    • T-SQL Tuesday live – a weekly open video call to just chat (this week’s call)
    • Live Stairways – teaching a class live, as I learn.
    • Open space get togethers with a few friend. We have a lot of land, and some friends, kids I’ve coached, and others are cramped in small suburban spots. We’ve hosted a few outside times, socially distanced, people brining their own chairs, just to help them cope.
  • Daily Coping 12 May 2020

    I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each day here.

    Today’s tip asks:  What are your most important values. Use them today

    One of my big values is to be understanding and kind. I naturally have a lot of empathy, and I try to go with that. I try to appreciate other viewpoints. I’m not always successful, but I do try.

    As my kids struggle with exams at the end of the semester, I have been avoiding trying to give them advice, suggest things, try to help, or admonish them for struggling. I appreciate the difficulties and am just being a listener and supporter.

    And I’m baking things they like to eat.

  • The Bite-Sized Redgate Summit comes back this week

    This week we have another edition of the Redgate Summit taking place on May 13, 14, and 15. We have different times each day to cover the world. The dates and times are:

    Europe, the Middle East, and Africa – May 13 3:00pm to 4:00pm BST Register

    Americas – May 14 3:00pm to 4:00pm CDT Register

    Asia-Pacific – May 15 11:00am to 12:00pm AEST Register

    The content is the same each day, with two topics being covered:

    • Using Local and Hosted Agents for Build with Azure DevOps
    • Working From Home Necessitates Communication Changes

    Each of these sessions is 20 minutes, with about 10 minutes for questions. Since the Advocates are spread out, and the sessions are short, each of us is handling a different day and time.

    Wednesday (Europe) – Kendra Little

    Thursday (Americas) – Grant Fritchey

    Friday (ANZ) – Steve Jones (me)

    I’ll actually be doing the broadcast Thursday evening my time, which works out to Friday morning in Australia. Hopefully this also means I get to go back and give live talks in Australia and New Zealand at some point.

    Register today and join us later this week.