Tag Archives: ETL

Data Manipulation with Word and Excel

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 , | Leave a comment

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

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

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

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