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.

SQL Server keeps a buffer of all of the changes to data for performance reasons. It writes items to the transaction log immediately, but does not write changes to the data file immediately.

In addition, don't miss DH2i's session, "Architecting SQL Server Environments with Containers for Superior HA and Cost Savings" (Track: Enterprise Database Administration & Deployment, 10/26 at 1 ...