Month: October 2024

To send an email in SQL Server, all that’s required is a fairly simple call of a stored procedure created by Microsoft. EXEC msdb.dbo.sp_send_dbmail @recipients = ‘sherpa@sherpaofdata.com’, @body = ‘The stored procedure finished successfully.’, @subject = ‘Automated Success Message’; Now, there are several more parameters you can use. Below are some of my favorites that…… Continue reading Sending out Emails from your database

In our last post, we discussed data masking and setting it up for specific columns. Now, I don’t know about y’all, but I deal with hundreds of tables with several columns in each on a daily basis that truly need data masking. If I have to go through and set up a masking policy one…… Continue reading Simplifying Data Masking in Snowflake with Tags

The premise behind data masking is fairly simple – make it so that only certain people can see the data in a certain column. For example, social security numbers or credit card numbers probably shouldn’t be seen by everyone who has access to your database. I like to set it up as follows: (Obviously, this…… Continue reading Enhancing Data Privacy in Snowflake

If you’ve been working with data for several years like I have – mostly using the SQL language – then I have a term for you that other languages, like JavaScript or Python, have had for a few years. The term is “memoizable” and it means, in a nutshell, to remember. A memoizable function caches…… Continue reading The Power of Memoizable Functions in Snowflake