Tag Archives: ETL

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

Chopping Off Data

Do you know the difference between XLS and XLSX? They’re both Excel formats, and many of us might just use one or the other. After all, the latest versions of Excel work with both, and if you’ve been using a … Continue reading

Posted in Editorial | Tagged , | Comments Off on Chopping Off Data

What Happened to Hadoop?

Six or Seven years back, Hadoop was the big thing. It was going to solve our big data analytic needs, it would provide cheap storage and query power with commodity servers. More and more companies were going to be using … Continue reading

Posted in Editorial | Tagged , , | Comments Off on What Happened to Hadoop?

Data Orchestration

We continue to deal with larger and larger data sets all the time. In fact, it seems that most people find themselves outgrowing the capabilities of some of their OLTP databases, often RDBMS stores, and need to upgrade hardware or … Continue reading

Posted in Editorial | Tagged | Comments Off on Data Orchestration