During a recent build of a Snowflake data environment, I encountered a challenge while translating my SQL Server code to Snowflake. As any seasoned database developer knows, dealing with staging tables and SCD (Type-2 slowly changing dimension) tables is par for the course in data warehousing. In the realm of table creation, there’s the classicContinue reading “Snowflake: Creative Create Table Tactics”
Category Archives: SQL Server
SQL Server: “New” String Functions
String manipulation in T-SQL code is not a new concept. I intentionally used “new” to indicate that some of the string functions discussed in this article were added after SQL Server 2016, which was the version I was using until a recent upgrade. Microsoft is constantly adding new features to SQL Server, many times itContinue reading “SQL Server: “New” String Functions”
Snowflake: Greatest and Least Functions
In a recent post, I discussed the GREATEST and LEAST functions in SQL Server 2022. Both of these functions exist in Snowflake, but after some testing, I found that they behave differently in Snowflake than in SQL Server when dealing with NULL values. While the functions behave differently, there are options to “get around” theContinue reading “Snowflake: Greatest and Least Functions”
Eric Heilman 