Skip to content

Sherpa of Data

Helping people to understand data in all of it's forms

  • Home
  • Blog
  • Tools
  • Presentations
  • Presentation Exercises
  • About
  • Contact

Month: July 2023

Next Friday Will Be Here Before You Know it

Sometimes, you’ll be asked to show the next Friday after a given date in a report. Sometimes, it’s the next Monday. Let’s work thru how to do it in both SQL Server and Snowflake for comparison… One of the two ways we’ll go over in SQL Server is using the DateFirst operator. This operator actually…… Continue reading Next Friday Will Be Here Before You Know it

Published July 25, 2023
Categorized as Snowflake Tagged Snowflake

This is the end… of the month.

In SQL Server, we’re used to finding the end of the month via a few different methods. We can always use the DateAdd and DateDiff functions to get our data – which sometimes takes a bit of work – or we can use the EOMonth function. Notice that the DateAdd and DateDiff functions return a…… Continue reading This is the end… of the month.

Published July 18, 2023
Categorized as Snowflake Tagged Snowflake

Distinctity. Yes, it’s a thing.

There are a lot of things that can be said about the keyword DISTINCT within Snowflake. One of them you’re probably used to, and one of them you probably aren’t. SELECT DISTINCT DEPARTMENT_ID FROM public.employees; In this case, DISTINCT is simply ensuring we have unique data. If you remove the DISTINCT keyword, the version I’m…… Continue reading Distinctity. Yes, it’s a thing.

Published July 11, 2023
Categorized as Snowflake Tagged Snowflake

More Fun Dealing with Strings

When you’re working with a database, it’s very hard to not deal with strings at some point in your journey. There are lots of different functions that you will be working with when you’re working with strings. Today, I want to go over some of the basic ones that you’ll use in Snowflake. The first…… Continue reading More Fun Dealing with Strings

Published July 5, 2023
Categorized as Snowflake Tagged Snowflake

Recent Posts

  • Don’t Just Watch Snowflake Costs – Analyze Them with Trend Insights
  • Dashboard Dreams and Snowflake Schemes
  • Unlocking Insights with Cost Data in Snowflake
  • Finding Out What’s Going On in your Database
  • Consistency is the Key to Success

Archives

  • May 2025
  • April 2025
  • February 2025
  • January 2025
  • December 2024
  • November 2024
  • October 2024
  • September 2024
  • August 2024
  • July 2024
  • May 2024
  • April 2024
  • March 2024
  • January 2024
  • December 2023
  • September 2023
  • August 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • November 2022
  • September 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • October 2019
  • September 2019
  • August 2019
  • June 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • November 2018
  • August 2018
  • April 2018
  • March 2018
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
Sherpa of Data
Privacy Policy
Proudly powered by WordPress.