Andy M Mallon - AM²

Databases & Diversity — Checking Integrity

  • Home
  • About Me
    • About Me
    • Contact Andy
  • GitHub Stuff
    • Profile
    • DBA Database
    • Data Blogger Resource Kit
    • Presentation Content
  • Legal Stuff

Month: March 2022

How do I prevent a trigger from firing for one process?

March 8, 2022 Andy 7

I recently saw a question on DBA Stack Exchange (it has since been deleted by the author), who had a “special process” that ran regularly, and as part of that process, they disabled the trigger, did some stuff, and re-enabled it. During that process, the … [Read More]

github logo Github Profile
DBA Database
Data Blogger Resource Kit
Mastodon:
[email protected]

Subscribe via Email

Join 3,536 other subscribers

SSMS Shortcuts

Awards & Programs



Recent Posts

  • Publishing a Code of Conduct isn’t enough
  • How do I prevent a trigger from firing for one process?
  • Querying SERVERPROPERTY() and DATABASEPROPERTYEX() from a view (without knowing magic)
  • What the heck is the SSISDB? Where does it come from?
  • T-SQL Tuesday #143: My favorite short scripts

Archives

Categories

RSS RSS

  • Publishing a Code of Conduct isn’t enough July 13, 2022
  • How do I prevent a trigger from firing for one process? March 8, 2022
  • Querying SERVERPROPERTY() and DATABASEPROPERTYEX() from a view (without knowing magic) December 17, 2021
  • What the heck is the SSISDB? Where does it come from? October 18, 2021
  • T-SQL Tuesday #143: My favorite short scripts October 12, 2021
  • What time is it in Oz? October 5, 2021
  • Stop using sp_hexadecimal & sp_help_revlogin July 6, 2021
  • FAQs about the dissolution of PASS December 28, 2020
  • Closing Time December 8, 2020
  • Multi-subnet availability group, with mixed MultiSubnetFailover support (Part 2) October 6, 2020

Copyright © 2023 | Andy Mallon | am2.co