Tag Archives: SQL

Preventing SQL Injection in BizTalk

I was reviewing a solution recently using the BizTalk WCF-OracleDB Adapter and detected an interesting security vulnerability. Before you dismiss this as “I’m using SQL Server, I’ll be right mate”, this issue probably also affects the BizTalk WCF-SQL Adapter and … Continue reading


Detecting Duplicate XML data in SQL Server

Had the interesting problem today of trying to detect duplicate XML values in a SQL Server table (stored in a column of field type XML). I’m not the first to cover this issue: Matt Woodward has covered the simplest case … Continue reading