Voice of the DBA

Tag: Redgate

  • A Virtual Trip Down Under

    I had a great holiday last week, getting away from my home for the first time in months. It’s been an extra strange time for me as I usually have a number of personal and business trips I’ve taken by this time, but with the pandemic, I’ve been at home, like most of you. However, we managed to find a campground open, and we packed up the family, dogs, and horses for a week in the South Dakota hills.

    I’m back, and while I won’t be getting on an airplane, I am going to travel virtually to Australia this week for quite an action packed Redgate Streamed APAC Edition. I’m slightly disappointed that I won’t be able to shake hands with Troy Hunt, but neither will Damian Brady, Greg Low, or Hamish Watson. I was on stage last summer with those three, and I immensely enjoyed the experience.

    This year we’re holding the event virtually in the Australia time zone, so I’ll be working late afternoon and evening my time for the event on Thursday, July 2. Time zones certainly get strange when I do things in Australia, and it’s the one place I’ve traveled where I feel really out of place when contacting this side of the world. The last time I was there, I watched my daughter’s evening volleyball game as I was eating breakfast.

    I get to deliver a talk, and then I’ll settle in to watch everyone else and enjoy the other talks. All of these are expert software developers and data professionals, and I learn quite a bit from them on a regular basis. If you want to spend time later this week, register for the event and join me, wherever you are in the world. The one good thing with these virtual events is that we can attend them if they fit our schedule.

    I’m excited to talk DevOps, software development, and, of course, security with the incredible Troy Hunt. This is an exciting week back for me, but also a busy one as I prep for a look at the software challenges down under.

    Steve Jones

    Note: Podcasts paused this week as I have construction taking place at the house and nowhere to record.

  • Bringing Redgate Streamed Down Under

    Next week is the Redgate Streamed APAC Edition, on July 2. At least, July 2 in Australia. I’m still not sure what time it will be for me, and I am double checking all the schedules since Australia and New Zealand make me feel more disconnected from everywhere else in the world. I loved my trip last year, but crossing the dateline was a weird experience.

    You can register for the event and attend. It’s 0800-1430 in AEST, but I’m not going to try and figure out where that is anywhere else. You’re on your own for that one.

    This time I’ll be presenting and hosting the event from Colorado in the US. I also get to do a short interview with Troy Hunt, who is in incredible expert in his field. I follow his blog, have watched his presentations, and am somewhat disappointed I don’t get to meet him in person. Maybe next year.

    We also have some other amazing speakers:

    • Damian Brady, Senior Cloud Advocate at Microsoft
    • Steve Jones, Microsoft Data Platform MVP & SQLServerCentral Editor
    • Greg Low, Microsoft Data Platform MVP and founder of SQL Down Under
    • Hamish Watson, Microsoft Data Platform MVP and founder of SQL Down Under

    I’ve been blessed to be on the stage with each of these experts, and I am looking forward to learning more from them next week. We’ll be talking security, DevOps, compliance, and more. Register today and join me next week for some learning, inspiration, and excitement.

    As a  plus, Redgate is donating to the Australian Red Cross and the WHO for each person that attends, so be sure to tune in.

  • A Byte of Redgate

    When the global pandemic shut down much of the world, we started the Community Circle at Redgate, with the idea that we would try and help others cope with the challenges of being stuck at home the vast majority of the week. There have been a number of efforts, many around learning, but also some other non-technical, non work related items. One of those was released recently.

    front-cover-212x300A Byte of Redgate is a cookbook with recipes from our employees and Friends of Redgate. You can read the story in this blog, and I’m excited to be mentioned. Andy Warren, fellow SQLServerCentral founder, mentioned that a cookbook would be a fun corporate project. I suggested it at one of our meetings and it turned into reality.

    You can download your free copy in pdf and epub formats now and try some new dish.

    I’ve found cooking to be a nice, relaxing, coping mechanism from the blandness of everyday life. I am trying out new recipes every week and enjoying the time with family that hasn’t had many evenings together as my kids have grown into adults.

    Whether you like cooking or not, pass along the link to those that do, or that you might want to make something for you. I’m looking forward to trying a few of the dishes for my family in the coming weeks. These are on top of my list:

    • Banana Bread (gluten free)
    • Tomato Soup Cake
    • BBW Chicken Shawarma Wraps
    • Charlott’s Kofta Curry
    • The Fussy Eater Frittata

  • SQL Source Control Link Errors on a New Machine

    I replaced my desktop recently and installed new software through Chocolatey.. One of the things I installed was git. I ran “choco install git” and then started using it. I cloned some repos and everything seemed fine.

    Then I cloned a repo of a SQL Source Control database, created a new database and tried to link the repo. I got an error on screen, which I forgot to screen capture. The error was 128, which wasn’t helpful.

    Fortunately, I did manage to copy the error to the clipboard. I pasted it in Notepad and saw this:

    2020-05-14 14_29_25-Are you a gatekeeper_ - Evernote

    Aha!

    I never configured git. Since I’m mostly working in my own repos, committing back to places that I will access from another machine, I haven’t thought about this. I know I’ve done this on the previous machine because SQL Source Control worked a month ago.

    What’s nice about git, and what I wish more software did, is that it tries to help you. In this case, it tells me that it can’t detect an email address and therefore can’t populate the commit metadata.

    What do I do?

    Run the commands and config my environment. I copied and edited the commands in a command prompt. And typo’d things one time.

    2020-05-14 14_34_24-cmd

    Once this was done, SQL Source Control worked.

    2020-05-14 14_35_06-Link to source control created

    SQL Source Control is a fantastic way to easily grab your database code and put it into a repo. Give it a try today if you never have tried it, but you’ve ever scripted out your object code.