Tag Archives: ETL

Data Manipulation with Word and Excel

Posted on November 7, 2022 by way0utwest

Recently I had to go through some training that asked me to evaluate some text. I needed to tally some data up, and decided Word and Excel were quick and dirty ways to do this. The Task The instructions were: … Continue reading →

Posted in Blog | Tagged , | Comments Off on Data Manipulation with Word and Excel

Import a CSV with a Header Row using BCP–#SQLNewBlogger

Posted on August 22, 2022 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Here are some hints to get started. I was demoing something recently and needed to show someone how to … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Import a CSV with a Header Row using BCP–#SQLNewBlogger

ETL v ELT

Posted on March 9, 2022 by way0utwest

This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can read various posts I’ve created as part of this learning experience. … Continue reading →

Posted in Blog | Tagged , , , , | 1 Comment

Quick CSV Import with dbaTools – #SQLNewBlogger

Posted on November 1, 2021 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Recently I was searching around for some sample data for a project. I stumbled on a CSV of data … Continue reading →

Posted in Blog | Tagged , , , | 8 Comments