Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com
Hand-picked content to sharpen your professional edge
Editorial
 

Triggers

Triggers. Who doesn’t like a good, lively debate about triggers? With the extreme cold that we’ve experienced this past week in the northeastern U.S., I feel like a little heated debate wouldn’t be a bad way to forget about the cold.

But alas, I’m not here to talk about database triggers. Sorry, we’ll have to save that debate for another day. (or maybe not, right?)

Instead, what’s really on my mind is a horse named Trigger (Trigg for short). I had the pleasure of housesitting for some dear friends over the last 10 days, a house that came complete with two horses, one donkey, one sheep, five chickens, two ducks, one peacock, four goats, and one dog. It was an adventure I needed for a number of reasons right now, and honestly those animals were helping me more than I was helping them. The adventure I thought I was about to embark on for 10 days, however, quickly became something very different on the third morning.

I had been warned that the horses in particular tended to have a Houdini-like quality about them, especially in the cold when grass is limited and icy ground hinders mobility. I was warned to make sure every door was latched or closed behind me when going in and out of stalls. And I was diligent to keep everyone in their proper place… until I woke up Friday morning to a sheet of ice on every surface no matter where I tried to walk.

By the time I got to the barn to feed the animals, slipping and sliding as I went, I grew quickly concerned when one of the horses wasn’t in their stall. Normally when I walked in, they both greeted me with annoyed and impatient neighs, eagerly waiting for their allotment of hay.

But Trigg wasn’t there.

So, I opened the stall door and walked to call him from the doorway that led outside.

Still no Trigg.

At this point, the second horse, Truett, was very impatient and I quickly walked back into the barn to feed him, thinking that Trigg would appear by that point.

Still no Trigg.

Growing slightly concerned, especially given the ice, I walked back through his stall and outside to start searching for him in the second outbuilding where the tractors, extra hay, and Mr. Peacock lived.

Did I mention it was slippery and icy?

Sure enough, there was Trigg, standing behind the ropes he wasn’t supposed to get through, chilling out in the peacock stall and unable to figure out how to come back through the ropes he wasn’t supposed to have crossed in the first place. (hence the reason he wasn’t coming when I called) Once I removed the ropes and he started to walk back towards the barn, I got delayed by the goats now in my path and the ice on the ground.

And yes, I had totally forgotten that I didn’t fully close the stall door when I had walked through to come find him.

(that’s called foreshadowing, by the way)

Just as I started down the hill to the barn, Truett was awkwardly coming towards me anxious and worked up. As I tried to calm him down and figure out what was going on, I suddenly saw Trigg outside of the barn on the other side of the fence, slowly walking towards the slightly exposed patches of grass poking through the snow in the yard.

I quickly thanked Truett for letting me know something was wrong, “ran” through the barn yard and stall, grabbed a halter rope and some hay, and hurried as quickly as I could outside and across the icy driveway to the grass. In fact, now that I think about it, I still don’t know how Trigg got across the top part of the driveway to the grass in the first place.

As I slowly approached him with some hay and gently called his name, Trigg would take a few steps forward each time I got closer. So I decided to go down the hill a few feet and try to come up in front of him, offering some of the deliciously sweet hay in my hand. But Trigg was too smart for my tactics (or so he thought) and he took off before I could take a couple of steps.

Have I mentioned yet that it was cold and icy?

In that moment, as Trigg took off down the hill towards the driveway, time slowed down and the next two seconds felt like an hour. As he reached the driveway, I knew exactly what was about to happen and I couldn’t do anything to stop it. Hoofs and icy surfaces don’t mix.

Shocked and confused after the initial impact of falling on his side, Trigg kept trying to get back up, each time falling and getting more frantic. One thing is for sure. This was not the morning he or I was expecting.

I’ll spare you the details of the next two and a half hours. Trigg did eventually stand backup, only to fall down again. We eventually had a vet, another horse owner, and multiple people from church present, ready to do anything we could to help Trigg. And, for most of this time, I was in communication with the owner who was vacationing in the Dominican Republic.

At the three-hour mark, after pushing, pulling, prodding, and lifting with all we had, Trigg was exhausted, cold, and seemingly unwilling to give any more effort to stand up one last time, even though we had finally been able to move him into grass where he wouldn’t slip if he tried to stand again.

(This editorial is already long enough that I’m sparing you the details of all the stuff we tried in between, including the examination that the vet was finally able to do causing usto be fairly certain there wasn’t a major broken bone but not knowing what was injured. This was an ordeal in every sense of the word!)

As we all stood there trying to move Trigg with our minds and wills at this point, the vet and friend that owned horses finally told the owner that we would try for 15 more minutes, but at that point, it was starting to borderline on cruelty to let Trigg slowly suffocate lying on the ground as he was.

I’m not lying when I say that the vet had the bottle and needle in her hand, ready to relieve Trigg of his pain. It’s a horrible thing, and I couldn’t believe this is where the morning had ended up.

But, if you’ve made it this far, you surely know I wouldn’t be telling this entire story just to tell you that after four hours, we had to let the horse die because he simply refused to get up anymore.

( “and Trigg… who did NOT die…” – ode to the ending of Charles Dickens “A Christmas Carol”)

That’s right, more than four hours after this entire thing started in the slow motion of a horse galloping onto an icy driveway, and without us coaxing him yet again, Trigg suddenly made one last attempt on his own to stand up… and made it! Once stabilized, the vet was able to do a quick internal examination of the bones to verify there wasn’t a traumatic bone injury. A few minutes after that, Trigg decided of his own free will to hobble on three legs over 100 feet back to the barn. He was hurt, but he was alive, and for the first time that day the scent of hope started to waft through the air.

Nine days later, and despite a constant onslaught of brutal cold and ice all week, I’m happy to report that Trigg is continuing to improve, although the road ahead is still not certain. The horse I just spent time with a few hours ago is not the horse he was moments before stepping onto the ice, but he is also a far cry from the horse that was lying on the ground, shivering and seemingly unwilling to give it one last go.

It’s caused me to think a lot this week about how often a project, or relationship, can feel like Trigg lying on the ground with no apparent way for it to move forward or find success. I’ve thought about how easy it is to walk away when those moments come, because that’s the easiest and most obvious thing to do. But when I don’t walk away, at least sometimes, the breakthrough comes and what I end up with isn’t the same as before, but often stronger and thriving in a different way.

I could do without the cold and ice for a very long time to come. But I’m thankful for watching a transformation from one thing into another over the last week.

And for that, I simply want to say, “Thanks, Trigger.”

(P.S. Yes, I did intentionally include at least one article on triggers this week just because. )

Ryan Booz

Join the debate, and respond to the editorial on the forums

 
The Weekly News
All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit.
Vendors/3rd Party Products

Redgate’s new PostgreSQL book is now available for free download

Redgate's new book, 'Introduction to PostgreSQL for the data professional', is now available for free download. Hear from authors Ryan Booz & Grant Fritchey about their inspiration for the book and the challenges they faced along the way.

Redgate Monitor Support for Azure PostgreSQL Flexible Server

Azure Flexible Server joins the suite of PostgreSQL hosting platforms supported by Redgate Monitor, which also includes Linux hosts or VMs, Amazon RDS and Aurora. Our goal is to provide you with a single-pane-of-glass view of your entire PostgreSQL estate, whether it’s running in Azure, AWS, or on-prem, ensuring simpler troubleshooting, better insights, and faster performance tuning.

Splatting in Flyway to Avoid Tedious Typing

This article covers splatting, explaining the advantages of using it with Flyway. We create reusable parameter sets and combine them as needed, using PowerShell. This simplifies multi-parameter Flyway commands, and makes it easier to execute consecutive Flyway operations within a pipeline.

AI/Machine Learning/Cognitive Services

Introducing Impressions at Netflix

From Netflix TechBlog - Medium

Part 1: Creating the Source of Truth for Impressio...

AI in SQL Server 2025: Embeddings

From Simple Talk

One of the cornerstones of AI is a concept called ...

Reddit mods are fighting to keep AI slop off subreddits. They could use help.

From Ars Technica

 

Administration of SQL Server

The Pain of Permissions

From Curated SQL

Hugo Kornelis talks about pain: But I have been in contracts where I was the only employee able to spell SQL, and hence all other…

A Little About Choosing Index Key Column Order

From Erik Darling Data

A Little About Choosing Index Key Column Order Goi...

Simple Point in Time Database Restores

From Andy Broadsword

A few weeks ago I demonstrated the simplicity of ...

A Little About Catching Queries That Fire Triggers

From Erik Darling Data

A Little About Catching Queries That Fire Triggers...

Conferences, Classes, Events, and Webinars

Redgate Summit Returns to London – join us in March!

From Blog – Redgate Software

We’re thrilled to announce the return of Redgate...

Data Access / ORMs

jOOQ 3.20 released with ClickHouse, Databricks, and much more DuckDB support, new modules, Oracle type hierarchies, more spatial support, decfloat and synonym support, hidden columns, Scala 3, Kotlin 2, and much more

From Java, SQL and jOOQ.

New dialects: jOOQ 3.20 ships with 2 new experimen...

Data Mining / Data Analysis

When is the perfect moment to build a data strategy in a company?

From Joyful Craftsmen – The Business Intelligence Agency

Introduction The challenge enterprises face is ado...

DevOps and Continuous Delivery (CI/CD)

Automating Flyway Desktop Development using the Flyway CLI

From Product learning – Redgate Software

This article is for any developers who want to lea...

Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science)

Receiving Notification when a Microsoft Fabric Notebook Fails

From Curated SQL

Gilbert Quevauvilliers gets an e-mail: What I have found is that when I created a pipeline in Microsoft Fabric that uses a notebook, when there…

Migrating or Copying a Semantic Model across Microsoft Fabric Workspaces

From Curated SQL

Sandeep Pawar makes a move: Here is a quick script to copy a semantic model from one workspace to another in the same tenant, assuming you…

Microsoft Fabric: Revealing Cost-Saving Results from Automating Pause & Resume Fabric Capacity

From BI Insight

If you work in data and analytics, particularly wi...

Analysing Kusto Query Performance In Fabric

There’s little to no documentation around analyzing Kusto query performance in Microsoft Fabric. In this article, Dennes Torres offers his guidance.

PostgreSQL

A List of PostgreSQL Parameters

From Curated SQL

Semab Tariq has a list: Have you ever experienced your database slowing down as the amount of data increases? If so, one important factor to…

Migrating Azure PostgreSQL Single Server to Flex via pg_dump

From Curated SQL

Josephine Bush changes server type: This is more complicated than using the Azure Migration method, but because it’s maxed out on resources for the last week…

Stefanie Janine: pgsql_tweaks 0.11.0 Released

From Planet Postgres

pgsql_tweaks is a bundle of functions and views fo...

Making a PostgreSQL Backup in a Container

From SQLServerCentral Blogs

I needed to back up a PostgreSQL database as a par...

Bruce Momjian: Wish I Was Wrong About TDE

From Planet Postgres

I first blogged about Transparent Data Encryption ...

PowerPivot/PowerQuery/PowerBI

Reading Delta Metadata In Power Query

From Chris Webb's BI Blog

There’s a new M function rolling out now that al...

Security News and Issues

Microsoft warns that the powerful XCSSET macOS malware is back with new tricks

From Ars Technica

XCSSET has been targeting Mac users since 2020.

T-SQL and Query Languages

Financial KPIs in T-SQL

From Curated SQL

I continue a series: In this video, we will dive i...

Tech News

RedGate’s State of the Database 2025

From Curated SQL

Louis Davidson summarizes a report: Less than a week ago, Redgate released their annual State of the Database Landscape report. You can read about the…

Dozens of things you can do to clean up a fresh install of Windows 11 24H2 and Edge

From Ars Technica

If you start using Windows 11 this year, you'll wa...

The odds of a city-killer asteroid impact in 2032 keep rising. Should we be worried?

From Ars Technica

"Humanity has never tried to stop an asteroid impa...

Mere weeks after Starship’s breakup, the vehicle may soon fly again

From Ars Technica

The FAA has not concluded its investigation, but a...

Small study suggests dark mode doesn’t save much power for very human reasons

From Ars Technica

LCD screens, dominant in laptops and tablets, tend...

Tools for Dev (SSMS, ADS, VS, etc.)

Concerns with Azure Data Studio’s Deprecation

From Curated SQL

Thom Andrews raises a valid concern: Some of you may, or may not know, Microsoft announced the deprecation of the Azure Data Studio (ADS) on 06 February,…

Snippets in SQL Server Management Studio

From Curated SQL

Pablo Lozano creates a snippet: Read on to see how you can create these. Snippets were great as a DBA, but I think I liked…

Virtualization and Containers/Kubernetes

Kubernetes vs. Serverless: When to Choose Which?

In this article, I’ll share my perspective on Kubernetes and serverless computing. More importantly, I’ll highlight some of the pitfalls I’ve encountered while implementing these solutions—and how you can avoid them. I’ll also share insights from my journey as a DevOps engineer, including lessons learned the hard way, to help you decide when Kubernetes or Serverless is the right fit for your organization.

 
RSS FeedTwitter
This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -