Great tips and specs.
Guidelines for Optimizing Bulk Import
Source: technet.microsoft.com/en-us/library/ms177445(v=sql.105).aspx
SQL Lessons: PowerShell basics
Part of my series pointing to valuable instruction on the web.
This one demonstrates the following functions by Chad Miller.
- invoke-sqlcmd2
- Write-DataTable
- Out-DataTable
- Add-SqlTable
Use PowerShell to Collect Server Data and Write to SQL
Learn about Windows PowerShell
SQL Lessons: Bulk Copy Data into SQL Server with PowerShell
Part of my series pointing to valuable instruction on the web.
Bulk Copy Data into SQL Server with PowerShell
The fastest way to get data into SQL Server is to use bulk copy methods, whether you use the old bcp utility or use the same capability in other ways.
Source: m.sqlmag.com/powershell/bulk-copy-data-sql-server-powershell