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...
Sql Server REPLACE function makes expression string NULL when replacement string is NULL
Obscure problem This has happened to me before, but naturally I forgot because it has been a while. The scenario is that you have dynamic SQL and you are trying to replace tags in your SQL string with...
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...
SQL Server rows appear to not be deleting
The Stupid Problem You are working on a database that you are not very familiar with as a developer – meaning that you are not going to think of every little thing that a DBA would think of righ...
Sql Server tSql: DELETE statement executes but won’t delete
Problem I ran into the most puzzling issue recently where I was executing a DELETE statement inside of a transaction among other statements inside of a stored procedure. Then the weirde...
WCF Asynchronous Service Methods and Timeouts Gotcha
Asynchronous Methods in WCF I have tested WCF asynchronous service methods on several occasions and I have come to a few conclusions. These of course are just my opinions and I am open to conversation...
WCF Security: Requiring Authorization to lock down your Exposed Services
Introduction WCF Security is definitely not something that can be picked up easily. It isn’t plug and play or something that can simply be turned on or off; and it most definitely is not easy to...
How to get all files modified for a work item in TFS
Introduction Just like everything that requires coding with (or against?) TFS API – this was not a small task. This took a while for me to understand and figure out, especially since how you wor...