Skip to content

Obscure Problems and Gotchas

If you couldn't find your answer to your weird problem, you might find it here.

  • About
  • Application Errors Hall of Shame
  • DyslexicApps
Development, SQL Server, SSIS

SQL row versioning to capture deltas

by: admin2021-05-16

There is a very powerful feature in SQL Server that if you know how to take advantage of can cut down on the amount of […]

Development, SQL Server

Biases in naming database objects

by: admin2020-08-01

Introduction Over my whole software engineering career, I have watched and learned the right way and the wrong way to style and format code. Especially […]

Development, SQL Server

Offline installation of Microsoft Machine Learning server components SQL 2019 is stuck

by: admin2020-04-05

Problem You are installing SQL Server 2019 and you get stuck at the Machine Learning Server Components installation step. Your installer could not download the […]

Development, Gotcha, SQL Server

Padding a string in tSQL

by: admin2019-02-04

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 […]

Development, SQL Server

RedGate SQL Compare – Index was out of range error

by: admin2018-12-01

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 […]

Development, SQL Server

Incorrect syntax was encountered while parsing :SETVAR

by: admin2018-11-29

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 […]

SQL Server

Avoiding the Red Gate Sql compare “Non-Schema statement was ignored” warning

by: admin2018-10-18

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 […]

Gotcha, SQL Server

Sql Server REPLACE function makes expression string NULL when replacement string is NULL

by: admin2018-02-05

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 Server

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

by: admin2016-12-25

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

SQL Server rows appear to not be deleting

by: admin2016-11-23

The Stupid Problem You are working on a database that you are not very familiar with as a developer – meaning that you are not […]

Posts navigation

Older posts

Search posts

Happy find? Help me buy the coffee that fuels these articles!

Buy Me a Coffee

Categories

Recent Comments

  • admin on Using the WCF Test Client without Visual Studio
  • Andy on Using the WCF Test Client without Visual Studio
  • admin on Replacing the CyberPower EC850LCD battery
  • wil blake on Replacing the CyberPower EC850LCD battery
  • admin on Offline installation of Microsoft Machine Learning server components SQL 2019 is stuck

Archives

Search posts

Search posts

SSL Secure

Copyright © All rights reserved. Theme Creativ Mag by Creativ Themes
 

Loading Comments...