Good old FTP and flat file import will do the trick reliably and never take a day off. Here are the basic steps to automate an FTP download in Windows followed by a CSV insert into MS SQL Server.

We have an ancient AS/400 730 system that still houses some old budget/financial data. We'd like to decommission this box, and migrate the data to a SQL server.

How to import or export diagrams with SQL Server? Information about the diagrams is stored in the dtproperties table. Basically to import or export a diagram, you simply need to import or export the ...

Global software house Microsoft is making big data the focus of SQL Server 2019, set for release later this year. A key part is data virtualisation, eliminating complex ETL processes.

While Larry Ellison was in the counting house counting all his money (or trophy homes), Microsoft engineers were hard at work spending thousands of hours building SQL Server 2014.