File modification date and time in FTP

Updated 16th Jul 2013: added description for IIS 8.0. FTP protocol provides several ways to obtain a file's last modified date/time. The returned values may vary in time zone or time precision. This article discusses the technological background, describes a behavior of several common FTP servers and discusses…

Beware pressing Cancel on Windows Firewall Security Alert

One would think that pressing “Cancel” has no effect and it just closes a window. Unfortunately, there is a side effect in Windows Firewall Security Alert window. Assume having some application that requires allowing an access through Windows Firewall. NOTE: For this blog post, we use a small application “ActiveFtpSample”…

How to upload data to FTP or SFTP server from a SQL-CLR procedure

Since Microsoft SQL Server 2005, stored procedures (and some other database objects) can be written externally in some .NET language, imported to the SQL database and called as stored procedures. The following sample demonstrates how to call Rebex FTP component from the T-SQL code. With some modifications, you can use…