Check this tip to read/write binary files from a disk or read a file from remote server (URL - using http/ftp). This tip contains sample code to create a table with a binary column, get a binary ...

So I'm faced with a task that involves compressing data stored in an SQL Server 2005 database.The data is mainly pdf documents, but tons of other documents are stored there as well. Most of them ...

Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server. To do this, we’ll use an SQL Server Agent Job.