Voice of the DBA

Category: Editorial

  • Data Sovereignty Issues

    Many people think about the cloud for cost reasons first, often because they can transfer the expense from a capital to operating budgets. Others think about the flexibility the cloud vendors offer to spin systems up and down, change configurations, and adapt to requirements quicker than many internal groups can. A few consider scalability, where we can grow or add systems to meet our needs.

    What about data sovereignty? I ran across an article recently that talked about the new SAS cloud on Azure, but located in different places for different reasons. Customers in the EU can use the German version of this. Those customers in the UK, because of Brexit, might choose the UK data center.

    It’s an interesting idea, where we might not think about just which specifications and services we use, but where they are located. That can pose challenges for architects and software developers, who may need to route customer requests to different data stores, based on their location. I’d think this is easier for database professionals, as we just duplicate stores in different places.

    This does mean that we’d need to manage backup, integrity, ETL flows, etc. in multiple locations, and we’d had the need to roll some data up across different data connections, but technology is making this easier all the time.

    The legal requirements and protections of having data in different places are still being argued and worked out. Microsoft fought a battle, and there was some resolution for how to handle cross border data issues, but I’m not sure this is settled law yet. Time will tell, but if there is any value to customers in where data is located, I suspect some of us will need to consider how we store data in different physical locations.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • Is there a Difference in Virtual Events?

    I’ve been to many SQL Saturdays across the last decade. I know I’m close to having spoken at 100 events, and I’ve enjoyed going to different cities, meeting lots of new people, and enjoy the local atmosphere. I love exercising at University Lake in Baton Rouge before their event. I’ve enjoyed wandering around Memphis to see sites, the music in Nashville is wonderful after a day of speaking. Getting up early and visiting Central Park in NYC or jogging through the city in Oslo are great memories. Evenings in Madison, San Jose, and Sioux Falls, and many other places have kept me entertained.

    Above all the hospitality of organizers and attendees has been wonderful. I still get plenty of warm welcomes from organizers of virtual events, but the local flavor is gone. In fact, I’m not sure that there is a difference between SQL Saturday Salt Lake City Virtual and SQL Saturday Slovenia. Organizers are still sending out gifts, and doing all the things that I’ve appreciated in the past, but it’s not the same.

    In fact, as both a speaker and attendee, I don’t see a difference between virtual events, and I wonder how many of you feel the same way. Are we just having events on different days of the week or different weeks and they all blend together? Is there any event that stands apart from the others, or do you just appreciate having events occurring constantly and weekend and being able to fit them in your schedule.

    I’m torn as to whether there is value in more of these virtual events, other than scheduling. I certainly can see that having SQL Sat Slovenia and SQL Sat Minnesota on Dec 12 makes sense, as the time zones allow people to attend sessions when they are convenient. As a speaker, it would be neat to “speak” at a Slovenian event and a US event on the same day, something I’ve thought to try in the real world. As an attendee, is there a season SQL Sat Plovdic occurs the same day as SQL Sat Slovenie? I’d rather one of them be a week apart since they’re both in the same time zone.

    I do like the accessibility of these events. Many more people can attend at that might not be able to spare the time, or make the trip to a live event. The cost to add more attendees isn’t something organizers worry about, and I could see there being a SQL Saturday on every Saturday throughout the year. That would be amazing.

    It likely doesn’t matter if we allow organizers to link an event to their city, or differentiate it from other events. To me, whether it’s New Stars of Data, GroupBy, SQL Saturday wherever, or any other event, it’s neat that I have lots of chances to watch a live talk and interact with a speaker. It’s still lacking something that a live event has, but I do appreciate the opportunity to tune into a talk and try to learn something when I have the time.

    I do think we need technology improvements to better deliver sessions, speakers need to learn to present differently when the entire screen might not be available, learning to explain what we’re doing, zoom in more, and use bigger fonts. I also think we need some type of mixed recorded/live/camera/chat evolution would make the experience better.

    I’m am thankful that we can continue to run events during this pandemic and find plenty of people to speak. I am even more grateful that I have the chance to continue learning.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • Practice Your Skills with the Advent of Code

    It’s that time of year, when the Advent of Code goes live. It started this week, with a few exercises released last week. You can still join in, and even go back and look at previous years (2019, 2018, 2017, 2016) and go through them. It’s a good exercise for your mind.

    To be fair, I’ve never completed the challenge in any year. Usually life gets in the way, and I get distracted. I’ve gotten through 15-20 in some years, but often the time required to work through the complex algorithms gets me a little discouraged. I’m not a 10x programmer, but I try.

    One thing I’ve done most years is to try and work through the problems in multiple languages. Typically my choices have been to try and solve each item three times, using T-SQL, Python, and PowerShell. I find it interesting to compare the languages and see how to handle the test data and also get the solution to work in each environment.

    If you want to stretch your programming mind and have some fun, give the challenge a try. Posting your solutions to a blog or even open a GitHub repo (or other VCS platform). It’s a good way to showcase your knowledge, at whatever level it is. You might even learn something if others comment on your solutions.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • Seeking Growth

    The word of the day is na·ive·té:  lack of experience, wisdom, or judgment.

    I used this word in a post, and wound up checking the spelling, since I constantly want to include an “i” instead of an “e” in middle of the word. As I saw the definition, I started to think about what this really means.

    We all experience this at times, after all, how can we gain experience except by working in a field where we lack it. The wisdom and judgment, hopefully come with experience, time, and (not too large) mistakes.

    The thing I’ve found often for myself is that I try to avoid situations where I am naive. I lean towards those places where I have some confidence, some wisdom, and experience. I work on my strengths most of the time. Certainly I’ve seen lots of people embrace that. We polish those things we enjoy, we have success with, and from which we get good feelings.

    When I coach, I see this often. Arguably, this is not the best use of most of your time. You ought to work on those things you don’t do well, those weak points, the places where you are naive. Improve the lower end, and the entire finished product is better.

    Or is it?

    I think you need a balance here. It pays to continue to refine you top skills, but it’s also good to grow and embrace things where you have little skill. Step into areas with the acceptance that you may make mistakes. Grow and learn, and embrace new ways or working, or even refinements to your skills.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.