Adventures in SQL

Blogs

Techno Security East: Quantum Computing Slides

By

I always try and ensure that I post my slides to my talks here...

A Basic Update Trigger: #SQLNewBlogger

By

I had someone ask me about using triggers to detect changes in their tables....

Apply for a 2025 PASS Summit Scholarship

By

Redgate is offering 13 PASS Summit scholarships which not only includes the 3-day ticket...

Read the latest Blogs

Forums

SSIS raw file conversion

By bokswager

Hi, Does anyone know how to handle a raw data file where some rows...

Force Strict Encryption - SQL Agent fails

By gustaw1234

Hi, On my SQL 2022 (16.0.4195.2) test environment, I tried to enable Force Strict...

Error converting data type varchar to float

By water490

Hi everyone I have a bunch of CSV files that I need to import...

Visit the forum

Question of the Day

How Many Nested Triggers?

I have DDL trigger code that I'm working on in SQL Server 2022, but I am concerned that we might end up with multiple triggers firing and the response to the user is delayed. If I want to check how many triggers have fired, or are nested, how can I do this in my code?

See possible answers