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…
Tag: SQL
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…