SQLKitty

Blog Post

Creativity in Technology

I was planning to write a blog post on how you can find ways to be creative in any technical pursuit. Then, I found out from a friend that...

2023-03-24 (first published: )

170 reads

Blog Post

Documentation vs Automation

Originally, I was going to write a post on troubleshooting SQL Server. This is because I’m writing up and reviewing a lot of documentation at my current job. I’ll...

2023-03-08 (first published: )

426 reads

Blog Post

Long time, no posts

I was working on two publisher contracts at the same time. I highly recommend never doing that. One is done, though, and it’s officially published as of September 2022....

2022-10-27

13 reads

Blog Post

Standards Matter

published on SQL Server Central https://www.sqlservercentral.com/articles/standards-matter At first, this was going to be a technical article about an index maintenance horror story. I received an off-hours page. The index...

2022-04-21

3 reads

Blog Post

What I’ve Been Up To

Just a short update. I haven’t blogged since May, and that’s because I’ve been presenting. Now, I have a publishing contract, so that’s keeping me busy. I want to...

2021-12-21

1 reads

Blogs

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...

SQL Server TempDB: The Most Overlooked Bottleneck

By

Configuration, Performance, and Unnecessary Usage TempDB is the SQL Server equivalent of a junk...

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