Error: The SQL command requires a parameter named “”, which is not found in the parameter mapping.

Gotcha This is a problem I have encountered a few times already when using SSIS with an OLE DB Source and a stored procedure. All the mappings are correct, but it just seems like SSIS doesn’t li...

RedGate SQL Compare – Index was out of range error

Problem This was a weird one because it is clearly a bug in the software. I am running version 13.6.1.7928 Professional of RedGate SQL Compare and I kept getting this error after performing an upgrade...

How to find the current profile required to send an email in SQL Server

Problem You are trying to send an email using “msdb..sp_send_dbmail” but you keep getting one of the following errors: Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 107 [Bat...

TSQL: Passing objects to stored procedures via XML

Introduction This is a subject I have heard about repeatedly, but I never bothered looking into it until recently. I was told that writing hard coded insert and update statements is bad practice. To w...

SSRS Report Viewer Control Broken Image Below Lines – Missing URL parameter: IterationId

I know it is unreasonable for me to say this but AXD files (HTTP Handlers) and anything that has to do with them scares me. I say this because if something goes wrong with them usually you can’t...

New cannot be used on a type parameter that does not have a new constraint

This is not such an obscure problem as it is just not straight forward to solve. Simply put you cannot instantiate a new instance of a generic object without explicitly saying that the method/class yo...