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!

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...