I recently setup my Synology NAS to host a Pi-Hole container and I missed a step while setting it up. I forgot to reroute the […]
Resetting the UniFi Network Application password when you get locked out
On more than one occasion I have gotten locked out of my UniFi networking administration software. Usually, I could fix this by just installing the […]
Avoid using FileZilla for work
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 […]
SQL row versioning to capture deltas
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 […]
Offline installation of Microsoft Machine Learning server components SQL 2019 is stuck
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 […]
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 […]
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 […]
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 […]
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. […]