Azure Data Studio is a great application for working with databases on Azure. Here are a few hints to improve quality of life on Azure…
Tag: SQL
Following on from my pandas to pyspark cheatsheet here is another cheatsheet to help convert SQL queries into PySpark dataframe commands. Like the last one…
Occasionally you may want to invoke a stored procedure from your python code in order to manipulate data as part of a larger task. Naively…
Sometimes may want to use Python to extract data from a SQL database to analyse using pandas. There are a couple of issues here. Firstly…