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, Gotcha, philosophy, ramblings, Security

Avoid using FileZilla for work

by: admin2022-11-25

Goodbye FileZilla I have been using FileZilla since it came out (I think?) back in 2001. It was heralded as being an excellent FTP client […]

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

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

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

Uncategorized

Sql Server tSql: DELETE statement executes but won’t delete

by: admin2016-07-17

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

Uncategorized

WCF Asynchronous Service Methods and Timeouts Gotcha

by: admin2015-02-01

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

Uncategorized

WCF Security: Requiring Authorization to lock down your Exposed Services

by: admin2014-05-25

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

Posts navigation

Older posts

Search posts

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

Like what you are reading?

It takes time to write these quality blog posts and sometimes software. Maybe something I have written has benefited you? Blog posts can take anywhere from a few minutes, to a couple of hours, to several days to construct. Software is a constant work in progress. Want to help me buy my next bag of coffee?

Anything is appreciated

Categories

Recent Comments

  • 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
  • IG on Offline installation of Microsoft Machine Learning server components SQL 2019 is stuck
  • Unable to connect to database with .NET Core 3.1 File System Publish to IIS on DotNet Core EF migration not working

Archives

Search posts

Search posts

SSL Secure

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

Loading Comments...