Data

The very definition of Data is the factual information (as measurements or statistics) used as a basis for reasoning, discussion, or calculation. [Source] The data that I work with on a daily basis. The life blood of a company. Without data, no company can expect to make intellectual decisions that will affect their outcome positively. Without…… Continue reading Data

Featured post

Published
Categorized as DataSource

Sending out Emails from your database

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

Comparing Email Configuration in SQL Server and Snowflake

Today, I want to talk about all the effort that goes into setting up the ability to email in SQL Server and Snowflake. First is our old friend – SQL Server. I’ll leave this one to the experts at Microsoft. As has been the case over the last few years, they have some great documentation…… Continue reading Comparing Email Configuration in SQL Server and Snowflake

How to Efficiently Change Data Types in Snowflake for Optimal Performance

When working with data, I usually have an idea of what type of data I will push into a field. Sometimes, for whatever reason, it is decided to change the type of data allowed in the field. Today, I want to show how that’s done in Snowflake. I will start out working with a simple…… Continue reading How to Efficiently Change Data Types in Snowflake for Optimal Performance