Gotcha There isn’t a Pad Left or Pad Right function in tSQL. Solution There is a lengthy discussion about this topic already on Stack Overflow […]
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 […]
Incorrect syntax was encountered while parsing :SETVAR
Gotcha When working with SQL CMD mode every now and then I will get this vague error and I can’t figure out what the problem […]
Avoiding the Red Gate Sql compare “Non-Schema statement was ignored” warning
Gotcha I recently had to create some non-schema related objects for a database project I am working on. It caused an annoying problem with Red […]
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 […]
Where are the SSRS, SSAS and SSIS templates for Visual Studio 2017?
SSDT Templates I am not sure why Microsoft did this and you can join the angry mob here if you want to join in on […]
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, […]
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 […]