There are plenty of articles out there on the basics of using API's with PowerShell's great New-WebServiceProxy cmdlet that will get you started with some basic API's, but far less posts that actually explore how to get past the simplest of queries. Once I'd gotten past the basi…
Probably something you'll want to do is summarise the pivot tables I noted earlier. That's not too hard - but you'll need to add an additional column to do you summing on (I reused IP since my table had no ID's to count):
Every time I have to build a SQL pivot I can't remember how to do it and end up searching online and struggle to work out what the heck people are talking about in their examples and spend ages looking at "sales" data examples, etc. that are overly complicated for my simple pivo…
I've been watching the Handmaid's Tale with rapt attention - and the Guardian drops some hints of what it would like to see next season and what made this season work so well and it's spot on with many of it's observations but doesn't give anywhere near enough credit to the cast…
I found reading this piece on a gun crime victim's family depressing but enlightening - and reminded me how fortunate I am to live in a country where guns are exceedingly rare. Contrast this with the struggles of a " Boy who loves too much " makes you realise it's a complex worl…