Which data should migrate from SQL into Elasticsearch?

Mar. 17, 2018 by

There are some good posts about using logstash’s JDBC input plugin to migrate your existing data into Elasticsearch. In order to make the technical examples simple, those posts demonstrate loading

How to group more than once in Azure Stream Analytics

Dec. 15, 2017 by

If you’ve used Azure Stream Analytics, you’ve probably encountered the message “Exactly one temporal window is expected.” While obviously only one temporal window is possible, this error occurs any time

Automating SQL joins that follow foreign keys

Oct. 18, 2017 by

I’ve written a SQL code generator which automates the mindless, repetitive task of joining a table to the tables to which it has foreign keys. Generating this code isn’t exactly

Common Table Expressions in SQL are a code smell

Oct. 4, 2017 by

I’ve recently come to the conclusion that Common Table Expressions (CTE) in SQL are almost always undesirable.  CTE’s are a powerful feature.  But unless they’re recursive, CTE’s are just replacements

How to test a view in a SQL database

Sep. 27, 2017 by

I had a realisation that I’m looking forward to blogging about soon.  However, when I outlined my post I couldn’t find references for several things that I know to be