software.safish.com
  • Blog
    Home All Articles Sticky
  • Software
    PhotoTool SQL Server Report Runner Stateless WorkflowEngine IIS Log Reader SftpScheduler
  • Online Tools
    Mortgage Calculator Compound Interest Calculator Future Value Calculator Future Value Annuity Calculator
  • Links
  • About
  • Search
Navigation bar avatar
✕

    Getting the Host Key Fingerprint for SFTP Connections

    Posted on August 8, 2022

    When scripting SFTP jobs, it’s a good idea to include the host key fingerprint to prevent man in the middle attacks. The easiest way I have found to get this information (if not provided) is to use WinSCP. [Read More]
    Tags: sftp winscp

    Create a zip file from powershell using 7zip

    Posted on July 29, 2022

    This is for future me….as present me always forgets how to do this. [Read More]
    Tags: powershell 7zip

    Dynamically load text files into SQL Server with BULK INSERT

    Posted on May 13, 2022

    Loading raw text data into SQL Server can be done using Flat File import or Data Imports, but I find this is always problematic as it does row scans to predict data types, but invariably fails on large data sets due to bad data types further down the file, or... [Read More]
    Tags: sqlserver

    Book Summary - Clean Code

    Posted on October 20, 2021

    This article is my personal summary (for future reference) of Robert Martin’s book Clean Code (most of it, anyway). [Read More]
    Tags: booksummary

    mRemoteNG prompting for password after crash

    Posted on October 7, 2021

    I use mRemoteNG on a daily basis, but every now and again it crashes, prompting you for a password to load your connections. This is as a result of a corrupt connections files. [Read More]
    Tags: chrome
    • ← Newer Posts
    • Older Posts →
    • RSS
    • GitHub
    • LinkedIn

    Matt Salmon  •  2025  •  software.safish.com

    Powered by Beautiful Jekyll