Category Archives: Microsoft

Log shipping across domains with FTP

If you have decided to use SQL Server Log Shipping as a Disaster Recovery (DR) solution, but for whatever reason your offsite data centre or external host isn’t on the same domain as you is Log Shipping still viable? Yes, … Continue reading

Posted in Backups, Microsoft, Networking, SQL Server | Leave a comment

Remove multiple CR LF characters from the end of text strings in SQL

Data entry, it’s where users love to copy and paste. Especially when their text is nicely arranged with multiple spaces, cartridge returns and line feeds amongst other special character formatting. In a perfect world this would be captured during input … Continue reading

Posted in Excel, Microsoft, SQL Server | Leave a comment