Sherpa of Data

Author: Kevin

  • Merging Data Sources – Part 3

    —

    by

    Kevin
    in ,

    Now, when I last posted, I’m sure you thought I was done talking about the MERGE statement. You are so wrong, compadre! One more post is absolutely needed! There are a few issues with the MERGE statement. Well, as of this writing, there are 361 possible issues according to Microsoft Connect – the actual website…

  • Merging Data Sources Part II

    —

    by

    Kevin
    in ,

    The last time we were together, we learned how to use the MERGE statement when we wanted to insert rows that didn’t exist and update rows that didn’t. This time we’re going to add onto that. We’re adding the seldom used, but delightfully potent – delete rows that no longer exist in the original table.…

  • Merging Data Sources

    —

    by

    Kevin
    in ,

    Merging Data Sources, part 1

  • Getting rid of data

    Getting rid of data

    —

    by

    Kevin
    in ,

    In previous posts, we’ve talked about SELECTing data, INSERTing data, and UPDATEing data. Now, what do we do if we want to just get rid of the data? Now, in most scenarios, you really don’t want to get rid of data. As a data professional, it is definitely not a good idea to get rid…

  • Inserting the data

    —

    by

    Kevin
    in ,

    This time, we learn about inserting data!

  • Updating a data source

    —

    by

    Kevin
    in ,

    Learning to write an UPDATE SQL Query

  • Reading from a data source

    —

    by

    Kevin
    in ,

    Last time we listed out several things that can be done with or to a data source. Now all of the examples we’ll be using in this series will use a database as a data source. It will allow us to discuss another of my favorite topics — SQL — while we talk about what…

  • What is not a data source?

    —

    by

    Kevin
    in

    What can’t be used as a data source? Let me explain…

  • Data Sources

    —

    by

    Kevin
    in

    Data Sources! Data Sources! Data Sources! Yes, that’s a throwback to one of my favorite tech memes of all time – with Steve Ballmer (CEO of Microsoft at the time.) So, in all its shining glory I present: [youtube https://www.youtube.com/watch?v=Vhh_GeBPOhs] Where would we be without the lowly data source? Absolutely Nowhere! What really is a…

  • Data

    Data

    —

    by

    Kevin
    in

    The very definition of Data is the factual information (as measurements or statistics) used as a basis for reasoning, discussion, or calculation. [Source] The data that I work with on a daily basis. The life blood of a company. Without data, no company can expect to make intellectual decisions that will affect their outcome positively. Without…