A few weeks ago, I wrote about polymorphism in Snowflake as a way to “get around” the issue with Snowflake procedures not allowing default parameter values. As the Snowflake platform evolves, more features are constantly being added – today I discovered that default parameter values are supported in procedures! Prior Example Review In the previous example, IContinue reading “Snowflake: Procedure Default Parameter Values”
Author Archives: Eric Heilman
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”
Failure IS An Option
In today’s social media-driven world it is easy to get caught up in the pursuit of perfect. Pursuing the perfect spouse, job, kids, or bank account balance and comparing our version of those things to the “perfect” version that others portray on different platforms completely skews that it is okay to fail. Let that sinkContinue reading “Failure IS An Option”
Eric Heilman 