Tag Archives: SQL

Relational vs. NoSQL Databases

Posted on October 11, 2021 by ericgharrison

This article provides a nice, brief, overview of the differences between relational and NoSQL databases. So far in all the systems I’ve developed, we’ve stuck with relational databases for the primary data stores, and then used others, such as ElasticSearch, and key-value based caches, for areas where traditional SQL couldn’t keep up (or didn’t need […]

<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> Uncategorized | <span class="entry-utility-prep entry-utility-prep-tag-links">Tagged</span> | Leave a comment

Using variables across blocks in Azure Data Studio for SQL

Posted on November 24, 2020 by ericgharrison

I do a lot of troubleshooting using SQL data and while I find the Jupyter notebooks in Azure Data Studio (ADS) useful, one thing that is frustrating is the inability to pass variables across code blocks. I will frequently need to limit queries to a date range, or a customer, and since variables can’t be […]

<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> SQL | <span class="entry-utility-prep entry-utility-prep-tag-links">Tagged</span> , , | 1 Comment