Snowpipe is essentially an ingestion tool to load data into Snowflake tables without manual intervention. Snowpipe detects the presence of a load file on a stage and automatically ingests the...

If you want sovereignty over your data it has to be encrypted and you have to have the keys, not the provider. I'm not sure how many providers allow that...

is anyone using a KVM switch to jump between a home PC and a work laptop?

I have two monitors, a keyboard and mouse currently connected to my home PC. ...

• This reply was modified 2 months ago by Ross McMicken.

***Warning***

A bit of a vent and a bit of a question ahead, feel free to skip this, but I need to vent somewhere...

***Warning***

In the parlance of a particular Reddit...

Back in 2003 or so our production databases started disappearing one day. We called the DBA and his response was "I'm testing a new migration tool. It has a flag...

How do you control production deployments without source control? How can you be sure that the code that was tested is what gets deployed? In our world, nothing gets deployed...

So you are forced to write SQL shorthand... 😉 😎

This always bothers me when one cannot...

Try google with these search terms sql shredding xml to tables

I haven't done this for quite some time, but that's how I found a performant method the last time I...

This seems incomplete. What is the basis for the totals? Sales to a given customer(there is no customer column)? Total amount of a single product made or sold? You could...

I first felt somewhat old when I realized I was old enough to be a new college hire's parent. The next step was when I realized I was old enough...

Many companies do not appreciate the vulnerability of data dropped into public tools, and it's not just AI. A large multinational oil company discovered that proprietary documents translated by Google...

Yes well noted and conveyed the same to business and application owners. They are well are of the repercussions and will take a call on this. Thank you...

I would do what I am doing now where most of my time is spent in Snowflake or SAP Hana. I do some work in legacy SQL Server systems, but...

Potential for ransomware attacks can be reduced by eliminating the ability of employees to browse their personal emails on Gmail, hotmail, etc. That ensures that all email goes through your...

The reason those letters were in those locations is due to letter frequency in English, putting the most frequently used letters on the left in descending order. Current frequency lists...