Tag Archives: ETL

Brush Up on Your ETL Skills

Posted on February 21, 2018 by way0utwest

Many of us that work with data will find requests and demands to import or export data at some point. Plenty of us have regular processes that perform these actions, and we may regularly troubleshoot or enhance these activities. In … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Brush Up on Your ETL Skills

Bulk Inserting Build Data–#SQLNewBlogger

Posted on August 31, 2017 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the common tasks that many DBAs need to do is insert data into a database. Often this … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

Loading All CSV Files with PowerShell

Posted on June 23, 2017 by way0utwest

I ran across Denis Gobo’s post about working with names from Social Security cards and wanted to play with the dataset. However, rather than use xp_cmdshell, which I might have, I decided to use PowerShell. I need to repeat this … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

DevOps – Downloading a File from the Internet with PoSh

Posted on June 19, 2017 by way0utwest

One of the things we need to do as data professionals is move data files around. Often we’ll get a local path, but in looking for public data sets, I wanted to get a file from the Internet. In this … Continue reading →

Posted in Blog | Tagged , , | 2 Comments