Sherpa of Data

Author: Kevin

  • SELECT Something New in Snowflake

    —

    by

    Kevin
    in

    Sometimes you think you have something down. With years of SQL Server experience, you would think you’d know at least the basics of the SELECT statement no matter the relational database. Well, my friends, you’d be wrong. With Snowflake, we could do many different things that we’re not used to seeing with a SELECT statement.…

  • Making the SELECT work in Snowflake

    —

    by

    Kevin
    in

    With our last blog post, we started discussing Snowflake and the SELECT statement. Now, if you remember, there is this great thing called a semi-colon. The main reason you should use the semicolon is to terminate all of your queries. Snowflake does this great thing by default, letting you run one query at a time.…

  • Checking Out Snowflake

    —

    by

    Kevin
    in

    Over the years, I’ve learned a decent amount of things when it comes to Microsoft’s SQL Server. Even with the new SQL Server 2022 which was just announced as being generally available just last week. But, sometimes, you just want to bust out of the old grind and do something a bit different. For me,…

  • Counting Down the Emails

    —

    by

    Kevin
    in

    Sometimes everyone has to do things outside of a database. One of those times, at least for me, was today. Over the past week, I have been getting emails from a SQL Server that has issues – hence why I was called in to check it out. In my inbox, I had hundreds of emails!…

  • Error Messages can be Helpful

    —

    by

    Kevin
    in

    Sometimes you just run into a situation you have to blog about. This time, I want to talk about the fun error messages that everyone is supposed to be watching out for. Whenever a process errors out, in most corporate environments there is usually one of two things that happen: Someone manually notifies a specified…

  • Transactions should (never) be distributed

    —

    by

    Kevin
    in

    For the last few blog posts, we’ve been talking about transactions. If you’ve missed any, be sure to click on the links below: Using Save Points with Transactions to Get Better How about we TRY and CATCH some Transactions? Setting up a Friendly TRANSACTION In the version of transactions that we going to discuss today,…

  • Using Save Points with Transactions to Get Better

    —

    by

    Kevin
    in

    When we last conversed, we talked about the TRY/CATCH block and how it works with transactions. If you somehow missed that, you can read about it here – How about we TRY and CATCH some Transactions? We’ll wait for you… All right, now that everyone’s back with us, we’ll talk more about everyone’s favorite –…

  • How about we TRY and CATCH some Transactions?

    —

    by

    Kevin
    in

    In our last post, we started talking about transactions and how they can help your databases have data integrity. Let’s continue that today with our friends TRY and CATCH. TRY is just telling SQL Server that we want to try out something. CATCH tells SQL Server what to do if it completely messes up. We…

  • Setting up a Friendly TRANSACTION

    —

    by

    Kevin
    in

    The last time we were together, I discussed DCL and TCL. That post ended with a quick paragraph on transactions and how they can help with data integrity. Today, I want to go more in-depth on this very important topic. Transactions always – and I do mean always – start with the phrase BEGIN TRAN.…

  • Accessing and Transacting Languages in SQL Server

    —

    by

    Kevin
    in

    Over the last few posts, we’ve discussed DDL and DML. This week I want to actually discuss the other 2 types of languages with SQL Server – DCL and TCL. DCL is the Data Control language. These are the commands that give security permission to a person – or group – to get things done.…