Author: way0utwest

  • 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.

  • Daily Coping 10 Dec 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. All my coping tips are under this tag. 

    Today’s tip is to support a charity, cause, or campaign you really care about.

    I did this recently, when Jeff Atwood was raising money for the Georgia Senate races in the US. I donated, entered his contest, and won an iPad. I didn’t expect to win, and donated because I wanted to, but this was a bonus.

    20201201_153530

    That inspired me to donate as well to Kiva. I’ve sent them money in the past, and did so again, giving them a little, and then lending out more to help others trying to grow their own businesses. I’ve had good luck with repayments, which let’s me lend again, but even when someone fails at their business, I’m glad I helped them make an attempt.

    2020-12-02 16_44_31-Portfolio _ Kiva

  • A Quick Break

    I had planned on family visiting this week, and took a couple days off. However, with the rise in COVID cases and restrictions in CO with a lack of snow, the trip got cancelled. I started to cancel my vacation, but then my wife suggested we still take a break and get away.

    So I’m taking a break for a few days. Coping tips still coming, but taking a few days to unwind this week.

  • 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.