Over the last few days, a task that only runs once per day has failed for unknown reasons. First, I’ve thought back on the regular responses to understand why it could have failed. Did something get published to Production that caused this new issue? (Thankfully, I’m the only one that pushes to Production in Snowflake…… Continue reading Finding Out What’s Going On in your Database
Month: January 2025
Consistency is the Key to Success
There is little worse than having to figure out which of several different ways to do something previous employees decided to do things. Over the last week, I began managing several SQL Servers as the DBA for a client. No worries there – it’s what I do. I began reviewing the first SQL Server. Backups…… Continue reading Consistency is the Key to Success
More Thoughts on Cloning in Snowflake
Recently, I was asked to compare data from a table in Snowflake with the same table’s data from a few hours before. As always, no one had thought about copying the data into another table before they started working with it. They just remembered an approximate time they started working with the table — 10…… Continue reading More Thoughts on Cloning in Snowflake