Author: way0utwest

  • Daily Coping 10 Mar 2022

    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 notice 3 new things today.

    I was trying to get ahead on a few tips before my trip to the UK this week, but I wanted to save this one for the journey. I’ve flown to London perhaps 50 times, but I made an effort to notice new things on this trip (I also set reminders in my calendar).

    Thing 1

    When I transit through Heathrow, I am always entranced by the size of the A380 planes there. Usually there are 2-3 at T2 that I walk past. I’m not a big plan fan, but these things are massive.

    When I went through Monday, the Thai Airlines A380 was replaced by a “normal” plane.

    20220307_105607

    Thing 2

    The legendary Heathrow lines are back, at least I noticed them. I arrived at Heathrow at about 11am, well, that was the time after the long walk from the end of T2. When I got there, I saw this:

    20220307_110312

    The back and forth lines here at the T2 border were longer than I expected. I’ve often tried to land after 10am, which used to be a quieter time. The 7-9am flights packed this space. However, today they were worse. I actually got directed to walk past down the hall to wrap around and walk right back. This was to manage the lines.

    The line actually went back towards the flight connection area, wrapping back and forth and then through this spot to the e-gates and agents. My guess was that at the time I arrived and got into a line, there were 1,000 people here.

    I noticed a couple things. First, lots of griping. Typically I’ve been able to get through in 10 minutes, or less with the Trusted Traveler program. I have heard people lightly complaining in the past about a line, but today quite a few people were expressing their displeasure. A couple people complained about having to walk down the hall and back to create a new orderly queue, and a few about the number of people and the few e-gates available.

    My apologies as these were mostly ugly Americans. What’s crazy is I think the US lines in some places, like Chicago, are as bad or worse.

    In any case, I was able to transit through in about 45 minutes, this despite a few people around me saying they’d been there an hour, which I don’t believe.

    The second thing is that the line was almost always moving. I was trying to maneuver with a sprained wrist, get something out of my bag and take off a second shirt (it gets warm there). I had few chances to actually stop long enough to remove my shirt. People were processed very quickly through the border, fast enough to keep the line moving.

    Thing 3

    An annoying thing. I was (painfully) aware of how often people stop walking with their bags to look or check something, and how closely people stand in a queue (line).

    Every time I quickly change directions, or someone bumps my roller while I’m holding it, my wrist flares with a little pain. I try not to use it for pulling my bag, but I needed to do it a few times.

    I tried not to use that arm, but sometimes I needed to. The other shoulder was wearing out. In lines for planes, or border patrol, I was bumped numerous times. While trying to navigate airports, as someone that walks medium speed (not too fast or leisurely), I bet people stopped in the flow of walkers 10 times between Denver, Dulles, and Heathrow, forcing me to quickly swerve around them or stop.

    I try to be conscious of others, and if I need to look, step out of the way. I had to do that when I got out of the plane and was dragging the bag with the bad hand. I waited until there was a space I could stop and switch without preventing anyone else from walking past.

    I also realized I need a 4 wheel spinner. I have really liked my roller bag, but the weight of that and my laptop bag is getting a bit much. Or I’m getting old.

  • OLTP Star, Snowflake, and Galaxy Schemas

    This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can read various posts I’ve created as part of this learning experience.

    There are types of schemas the exist in data warehouses. This topic is definitely on the exam.

    OLTP/Relational

    The type of schema that many of us work with is the standard OLTP or relational model. We have lots of transaction tables, most should have a PK, some of which have PKs. The schema expands to meet different needs and can have lots of entities.

    As an example, here is a view of the AdventureWorks database.

    adw_er

    This isn’t fundamentally different from the schema types below, but there isn’t a central, or two central, tables here. Instead, we have a lot of different groups of tables. The structure is designed for normalization, and usually has lots of tables compared to a data warehouse.

    Star

    The star schema is often used in data warehouses. The name comes from the fact that the table arrangement looks similar to a star. There is a central fact table, which has some details of the main data, often something like sales, and a lot of foreign keys (FK).  The fact_sales_order is the fact table below.

    Then there are supporting tables around the fact table, linked by the FKs. These are the dimension tables, and contain details about a specific dimension or area. In the image below, we have date, employee, store, and other dimensions tables.

    5690_create-star-schema-data-model-using-microsoft-toolset.028

    This is a somewhat de-normalized structure, as the primary purpose is to report on a set of facts.

    Snowflake

    This schema builds on the star schema. Here there is still one fact table (Sales below), but the dimension tables have their own dimension tables, providing more details. Essentially, the dimension tables are normalized. An example is the Employee dimension, which has a linked Department dimension.

    Capture-163

    Galaxy

    The galaxy schema expands with a second fact table. In the image below, we have the sales and purchase as fact tables. There are dimension tables, which can be linked to one or more fact tables.

    Galaxy-Schema

    It isn’t that important you know how to build these schemas or design the entities for the DP-900 exam, but you do need to recognize the structures.

  • The Cloud as a Foundation

    The cloud for computing is a fascinating structure. I know there are plenty of jokes about the cloud just being someone else’s computer, and there are good reasons not to use the cloud. However, there are also lots of good reasons to use the cloud. Whether you choose to embrace it or avoid it, cloud computing is going to be a part of our careers for a long time. The use is growing, and more and more companies are shifting workloads to cloud services.

    How that will evolve, especially for data-intensive systems, will be fascinating. One of the interesting changes that seems to be taking places is the growth of database and data stores that fulfill specialized roles for customers. Snowflake might be one of the most well-known examples, but there are plenty more. The number of offerings is growing, and perhaps this is another evolution of how the cloud will integrate into more businesses.

    To date, most of the large cloud providers (Azure, AWS, GCP) are offering a full stack of different systems that you use to deploy code and run applications. These cobbled-together services and platforms often lock customers into a particular cloud, though that isn’t what many organizations would like. Especially in some regulated industries that mandate multiple clouds be used for redundancy. This article talks about the cloud as a foundation on which other customers can build services or platforms, especially data platforms.

    This is something I would like to see. Snowflake is something that a company can run on AWS, Azure, or GCP.  CockroachDB is another that allows customers to work with the platform on the provider of their choice. I like the idea of a wider set of platforms built upon cloud providers, but in a way that allows customers to move if need be, and also pressures cloud providers to keep pricing in line with each other.

    In my mind, the more we find innovative companies building cloud-native data stores and other products, the more pressure on existing companies to improve their offerings. Competition is good, and it brings us new tools, while also forcing existing companies to update their offerings. It’s not perfect, as sometimes we get new features without quality improvements in the base product, but without competition, we might not get that anyway.

    I am fascinated and pleased by the cloud. The more I learn and work with it, the more I appreciate this as a truly new way of approaching the building and operating of software.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher, Spotify, or iTunes.

  • Daily Coping 9 Feb 2022

    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 show an active interest by asking questions about others when talking with them.

    I like trying to engage with people in conversation. I don’t do it a lot, as I tend to be fairly introverted, but I have learned that when I decide to talk or listen to someone, I need to pay attention and focus.

    I did this with one of the kids I coach recently. We had a few minutes, and I asked her how a school thing was going. She had said something the week before about a challenging time, so I followed up, asked how it went, and a few other questions based on her answers.

    Reminds me of them times when my kids had really worked hard on something. This young lady detailed some challenges and how hard things were, but the enthusiasm and passion in her voice showed that she was proud of her work, despite the complaints she voiced.