Tag Archives: SQL

Preventing SQL Injection in BizTalk

Posted by Matt Mitchell on July 22, 2013

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 →

Comments

Detecting Duplicate XML data in SQL Server

Posted by Matt Mitchell on July 20, 2012

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 →

Comments