Voice of the DBA

T-SQL Tuesday #106 – Trigger Headaches or Happiness

·

way0utwest Avatar
way0utwest

tsqltuesdaySince I took over the T-SQL Tuesday a few months ago, I decided I ought to host again. Especially since I’ve done it twice, but Wayne Sheffield got his third spot last month. Gotta keep up with Mr. Sheffield.

Triggers, for fun and frustration

I’ve been working with SQL Server and T-SQL a long time, and across many jobs, I think I’ve ended up using triggers in 0.01% of my tables or less. They can be a useful and helpful construct, but they can also be problematic and difficult, especially in the age of changing business models and rules.

Since I’ve found triggers to be both helpful and hurtful, I decided to ask you to write about an experience you’ve had with triggers. Either good or bad, but let me know this month what stands out in your mind.

The Rules

As always, the rules for this month are simple.

  • Write and publish a post on September 11, 2018, UTC time.
  • Include the T-SQL Tuesday logo (you can grab this above) and link your post back to this invitation.
  • Leave a comment/pingback on this post for me to use to include you in the roundup
  • Have fun.
VS Live San Diego

Currently Reading

Reshuffle
My current business book recommended by our CEO

administration AI Azure Backup/Recovery career career2 car update Cloud Computing coping database design databases Database Weekly DevOps disaster recovery encryption Friday Poll goals hardware Humor life Microsoft misc PASS powershell Redgate republish sabbatical security software development software development speaking SQL in the City SQLNewBlogger SQL Prompt SQL Saturday sql server syndicated T-SQL T-SQL Tuesday Tesla travel vacation windows words work

Comments

37 responses to “T-SQL Tuesday #106 – Trigger Headaches or Happiness”

  1. T-SQL Tuesday #106 – Trigger Headaches or Happiness – T-SQL Tuesday

    […] Invitation from Steve Jones […]

    Like

  2. Why I Love DML Triggers in SQL Server – by Kendra Little

    […] TSQL Tuesday today! If you’re not familiar, TSQL Tuesday is a monthly blogging event where a Microsoft Data […]

    Like

  3. Kendra Little Avatar
    Kendra Little

    My post is here: https://littlekendra.com/2018/09/11/why-i-love-dml-triggers-in-sql-server/

    Thanks for the topic!

    Like

  4. Rob Farley Avatar
    Rob Farley

    Thanks for hosting, Steve. http://blogs.lobsterpot.com.au/2018/09/11/triggers-good-or-bad/

    Like

  5. Triggers – good or bad? – LobsterPot Blogs

    […] about triggers. I’m not sure whether Steve Jones (@way0utwest) knew this when he decided on this month’s T-SQL Tuesday topic, but either way, it’s been a long time and triggers are worth talking […]

    Like

  6. T-SQL Tuesday #106 Trigger headaches or happiness? – Jon Shaulis DBA

    […] Triggers are both a useful tool with a specific niche… and the devil. Thank you Steve Jones for hosting this week’s topic on triggers! […]

    Like

  7. jonshaulis Avatar
    jonshaulis

    Fun topic to think about this month, thank you Steve!

    T-SQL Tuesday #106 Trigger headaches or happiness?

    Like

  8. Faking Temporal Tables with Triggers – SQL with Bert

    […] post is a response to this month’s T-SQL Tuesday #106 prompt by Steve Jones.  T-SQL Tuesday is a way for the SQL Server community to share ideas about […]

    Like

  9. Bert Wagner Avatar
    Bert Wagner

    Thanks for hosting Steve, here is my post: https://bertwagner.com/2018/09/11/faking-temporal-tables-with-triggers/

    Like

  10. Dave Mason Avatar
    Dave Mason

    Thanks for hosting, Steve. My post is here: https://itsalljustelectrons.blogspot.com/2018/09/TSQL-Tuesday-106-Triggers.html

    Like

  11. TSQL Tuesday 106 – Trigger Headaches or Happiness: Capturing Database Creations. – No Column Name

    […] TSQL Tuesday is around again! This monthly blog party started by Adam Machanic ( blog | twitter ) is still going strong. This month we have Steve Jones ( blog | twitter ) and the topic is all to do with Triggers! […]

    Like

  12. Aaron Bertrand Avatar
    Aaron Bertrand

    Thanks Steve!
    https://sqlperformance.com/2018/09/sql-performance/t-sql-tuesday-106-instead-of-triggers

    Like

  13. A Tale of a Trigger | Bob Pusateri – SQL Server and Kindred Subjects

    […] This month’s T-SQL Tuesday is being hosted by Steve Jones, who has asked for blog posts today on experiences we have had with triggers, good or bad. […]

    Like

  14. captbob007 Avatar
    captbob007

    Great Topic, Steve! Here’s mine: https://www.bobpusateri.com/archive/2018/09/a-tale-of-a-trigger/

    Like

  15. TSQL Tuesday #106: Triggers and the Spiral To Oblivion – SQL Undercover Avatar
    TSQL Tuesday #106: Triggers and the Spiral To Oblivion – SQL Undercover

    […] month’s invitation comes from Steve Jones and he’s asking us to write about triggers and our experiences of […]

    Like

  16. David Fowler Avatar
    David Fowler

    loving reading these

    TSQL Tuesday #106: Triggers and the Spiral To Oblivion

    Like

  17. What happens in a trigger stays in the transaction: T-SQL Tuesday #106 | SQL Studies Avatar
    What happens in a trigger stays in the transaction: T-SQL Tuesday #106 | SQL Studies

    […] for T-SQL Tuesday, is Steve Jones (b/t). His topic is Trigger Headaches or Happiness. His invite seemed to invite a story, so here’s mine. […]

    Like

  18. Cláudio Silva Avatar
    Cláudio Silva

    Thanks for hosting this round Steve.
    My contribution: https://claudioessilva.eu/2018/09/11/triggers-the-hidden-logic-that-will-strike-back-tsql-tuesday-106/

    Like

  19. The Helpful Triggers | Voice of the DBA Avatar
    The Helpful Triggers | Voice of the DBA

    […] is the day for T-SQL Tuesday #106 entries. I’m the host this time, which means that I’ll have a busy week trying to […]

    Like

  20. Allen White Avatar
    Allen White

    Thanks, Steve! Here’s my contribution: http://dataperfpro.com/t-sql-tuesday-106-trigger-happy/

    Like

  21. James Avatar
    James

    Great topic Steve! https://jameslivingston.io/2018/09/11/logon-trigger-woes/

    Like

  22. paschott Avatar
    paschott

    Fun topic that’s near and dear to all of us. I decided to write about “disabling” triggers.
    https://schottsql.wordpress.com/2018/09/11/disabling-triggers-without-alters/

    Like

  23. T-SQL Tuesday #106 | downshiftdata

    […] is a response to T-SQL Tuesday #106, Trigger Headaches or Happiness, by Steve […]

    Like

  24. Marek Masko Avatar
    Marek Masko

    Thanks for this topic!

    Here is my contribution: http://blog.sqlterritory.com/2018/09/11/t-sql-tuesday-106-triggers-headaches-or-happiness/

    Like

  25. T-SQL Tuesday #106: How to use triggers and not be sad – SQL Server Fast

    […] T-SQL Tuesday subject for September, chosen by Steve Jones (b|t), is to write about an experience I had with triggers. I decided to apply a very loose interpretation of his assignment and write more about triggers in […]

    Like

  26. Hugo Kornelis Avatar
    Hugo Kornelis

    Done!
    https://sqlserverfast.com/blog/hugo/2018/09/t-sql-tuesday-106-how-to-use-triggers-and-not-be-sad/

    Thanks for hosting, Steve!

    Like

  27. reiddewolfe Avatar
    reiddewolfe

    Thanks for hosting!
    http://www.reiddewolfe.com/2018/09/t-sql-tuesday-106-asynchronous-triggers.html

    Like

  28. Eduardo Pivaral Avatar
    Eduardo Pivaral

    Hi Steve, this is my post:

    http://www.sqlguatemala.com/2018/09/pride-and-prejudice-and-triggers.html

    thanks.

    Like

  29. Brian Dudley Avatar
    Brian Dudley

    Interesting topic with some thoughtful ideas.
    https://cognimea-blog.blogspot.com/2018/09/when-it-comes-to-triggers-i-have.html

    Like

  30. TSQL Tuesday: Who is on my server? | SQLGene – Learning SQL Slowly

    […] Here is my entry for this month’s T-SQL Tuesday. […]

    Like

  31. eugman Avatar
    eugman

    Here is my entry: http://www.sqlgene.com/2018/09/12/tsql-tuesday-who-is-on-my-server/

    Like

  32. T-SQL Tuesday 106: 5 Things Not to Do With Triggers – nate_the_dba Avatar
    T-SQL Tuesday 106: 5 Things Not to Do With Triggers – nate_the_dba

    […] This month’s invite comes once again from our benevolent overlord* community pillar Steve Jones, head of SQLServerCentral.com! If you haven’t been there, stop reading immediately and go check out the helpful forums and ‘Stairways’ articles. Some truly excellent content to be had. […]

    Like

  33. natethedba Avatar
    natethedba

    I love it when a postback works the first time. =D

    Like

    1. natethedba Avatar
      natethedba

      Or pingback.. whatever. It’s bedtime. Thanks Steve!

      Like

  34. T-SQL Tuesday #106 – The Trouble with Triggers | Matthew McGiffen DBA

    […] https://voiceofthedba.com/2018/09/03/t-sql-tuesday-106-trigger-headaches-or-happiness/ […]

    Like

  35. Matthew McGiffen Avatar
    Matthew McGiffen

    Hopefully I’m in just under the wire – I believe it’s still Tuesday somewhere!

    T-SQL Tuesday #106 – The Trouble with Triggers

    Like

  36. The Trigger Roundup–T-SQL Tuesday #106 | Voice of the DBA Avatar
    The Trigger Roundup–T-SQL Tuesday #106 | Voice of the DBA

    […] month was my turn to host T-SQL Tuesday. I chose Trigger Headaches or Happiness as the topic, and I am glad that there have been quite a few […]

    Like