All About SQL

Blog Post

Snowflake + Azure blob

Let’s go back to data platforms today and I want to talk about a very common integration I see nowadays, Azure Blob Storage linked to Snowflake via a storage...

2024-10-18 (first published: )

153 reads

Blog Post

Blockchain + RWAs

Blockchain technology is still at the hype stage for an emerging technology cycle, it gets a bad image from all the dodgy web3 “crypto” fake projects out there (based...

2024-09-05

11 reads

Blog Post

WHAT IS A SPV?

Why am I focussing on RWA (real world assets) as the next big thing? The WEF predicted that by 2027, 10% of the world’s GDP could be stored on...

2024-08-09

16 reads

Blog Post

Tech in 2030

What will the technology world look like in 2030? Cloud computing will naturally be the backbone of the world but I think with variants in “decentralising” concepts. By this...

2024-08-09 (first published: )

116 reads

Blog Post

Azure SQL MI License free?

A common setup when leveraging the cloud is to use the cloud for Disaster recovery (DR) purposes, some say it becomes a logical extension of your on-prem / data...

2024-03-11 (first published: )

428 reads

Blog Post

Azure chaos STUDIO

Chaos engineering is fun but especially important when building solutions in the cloud. It is great leveraging the cloud to build something, whether that’s a globally distributed website with...

2023-06-28 (first published: )

264 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

Error converting data type varchar to float

By water490

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

Best/easiest way to import an SSIS package...

By jellybean

Folks, Looking for advice on the best way to import a package. I hope...

Measure duplicating its value when non-conformed dimension attribute is included

By stiej1977

Hi,   I have two fact tables (say FactA, and FactB), that are joined/shared...

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