Category Archives: SQL

Interesting Postgres extensions

Posted on October 21, 2024 by ericgharrison

Just plopping this in here to keep track of – when I have some time I need to go through and poke around in each one… especially the pg_stat_statements one! https://www.craigkerstiens.com/2024/10/18/the-future-of-postgres/

<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> | 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> , , | Leave a comment