Monthly Archives: June 2017

Using OPENROWSET in SQL Server on Linux

Posted on June 21, 2017 by way0utwest

I wanted to import the million song dataset in SQL Server on Linux. There’s a github repo that has the SQL to allow you to use this with the graph database features. However, it’s built for Windows. Linux is a … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

Speaking at the Data Platform Summit 2017

Posted on June 20, 2017 by way0utwest

I am honored to be speaking at the Data Platform Summit 2017. The event takes place August 17-19, 2017 in Bangalore, India. This will be my first trip to India, and I’m excited to be traveling halfway around the world … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Speaking at the Data Platform Summit 2017

Migrating Schema Between Platforms

Posted on June 20, 2017 by way0utwest

PostgreSQL is a popular relational database, one that was designed to be an object relational system, based on standards, and allowing for extensibility. I’ve always thought this was a great system, exceeding SQL Server in some ways, though falling short … Continue reading →

Posted in Editorial | Comments Off on Migrating Schema Between Platforms

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