bemuse | ⬤▗▚▚▚ Web-based online rhythm action game | State Container library

I am trying to convert the JSON at this URL: https://wtrl.racing/assets/js/miscttt170620.php?wtrlid=63, which I have saved in a file, to a CSV using this code:

I have been using the below code to populate a workbook with one sheet for each day of the month (1-31) automatically for years. This month the dates are showing up with a single trailing decimal (1.0, 2.0 etc).

I regularly use SSMS to query data and build datasets, my IT department handle the database administration.

Recently I found out about Azure Data Studio and I liked:

• intellisense
• source code control (e.g. with Git)
• extensions from the community
• SQL snippets, automating code writing and are even customisable
• Notebooks - the ability to run code alongside comments in markdown. Amazing for live documentation. It enables you execute code in different languages on the same page!

In addition to this I see Visual Studio Code (and Visual Studio). VS Code and ADS seem so similar especially once you add in extensions. The overlap between the products is confusing.

I don't have SQL Server 2019 and Big Data Clusters. I am looking for a program that has notebook functionality in SQL, R and Python. Although it seems like there are better products for developing R code e.g. R studio.

I'd like to be trying alternatives to SSMS to establish different future work flows. At the moment it feels hard to wholeheartedly recommend any options.

Does anyone have a good any idea about how this all fits together?

EDIT: If you've tried to find out Microsoft's strategy but are pretty bemused, responses are also welcome!

I've been using the CAM::PDF module to try editing pdf docs at work - essentially just trying to change the date on docs automatically to show they have been reviewed recently

unfortunately, despite my code telling me that I am making changes to the PDF objects ($pdf->{changes}) and giving the pdfs the doc is attempting to change maximum accessibility (anyone can access, read, write) the pdf's outputted never seem to materialise with these changes. I have also been grepping the object node tmp files I output on mass and found that all of these show no sign of the old date after running the code; yet when I view the pdf after running it, the old date is still on the pdf. Has anyone encountered this before or can suggest anything?

just doing this manually isn't an option; I want to script this so I can have a script I just run against multiple files at once (I have LOTS of these files to sort out at work) but other than changing dates written on the doc, the doc has to remain looking the sameish (by which I mean, it would be ok if they changed in size a little but not ok if they completely changed in appearance)

I strictly followed the example changepdfstring.pl (https://metacpan.org/pod/distribution/CAM-PDF/bin/changepdfstring.pl) from the author of the module CAM::PDF on how to do this for my code, then tried different variations of it to try and get things to work - so I'm bemused that nothing has worked in the end