• Blackmist@feddit.uk
      link
      fedilink
      English
      arrow-up
      20
      ·
      7 months ago

      I don’t understand environments that don’t wrap things in transactions by default.

      Especially since an update or delete without a where clause is considered valid.

      • finestnothing@lemmy.world
        link
        fedilink
        arrow-up
        9
        ·
        edit-2
        7 months ago

        I’m a data engineer that occasionally has to work in sql server, I use dbeaver and have our prod servers default to auto-wrap in transactions and I have to push a button and confirm I know it’s prod before it commits changes there, it’s great and has saved me when I accidentally had a script switch servers. For the sandbox server I don’t have that on because the changes there don’t matter except for testing, and we can always remake the thing from scratch in a few hours. I haven’t had an oppsie yet and I hope to keep that streak

      • Ultraviolet@lemmy.world
        link
        fedilink
        English
        arrow-up
        3
        ·
        7 months ago

        SQL Server technically does behind the scenes, but automatically commits, which kind of defeats the purpose.