James McGillivray
banner
jamesmcg.bsky.social
James McGillivray
@jamesmcg.bsky.social
Father. Microsoft Data Consultant and Director at Cobalt Analytics | Speaker - PowerBI World Tour / PASS Summit / SQLBits | MCSE Data Analytics & Management | Cricket | Arsenal | Musical Theatre 🚻 He/Him
Not cooking for thanksgiving, but tonight’s dinner has had onions caramelising for the last 90 mins. Almost ready
November 9, 2025 at 4:46 PM
nscandanavian(max)
November 9, 2025 at 10:31 AM
Just tell me when and I will help you plan the best trip 🤗
November 9, 2025 at 4:35 AM
Have some pictures of sunshine before 8am, after 4pm, wild animals, and other concepts foreign to Europe for November and December! 🤭
November 7, 2025 at 7:44 PM
Come visit South Africa! The next 2 months here are glorious! And we kinda still hibernate around Christmas, we just do it around the pool with watermelon and leftover cold meats!
November 7, 2025 at 7:00 PM
Yeah, I appreciate that many of the approaches to verifying age are scary from a privacy POV (photos/official docs/etc.), but I do appreciate the effort to prevent young people from being sucked into a dark place.
November 5, 2025 at 12:16 PM
Brave to play without a keeper, but when you haven’t faced a shot on target in 2 games I guess you can flex a bit
October 21, 2025 at 6:31 PM
Apparently it is a rule in the PL that a player can’t use a towel to dry the ball. No idea why, but I read about it before the game
September 28, 2025 at 4:04 PM
OMG me too!
September 18, 2025 at 12:30 PM
September 16, 2025 at 6:47 PM
I guess it might also be possible to just make it into a project variable? And then pass the SHA/PR value in your deploy task?
September 3, 2025 at 7:56 PM
Can record in either a table (for a complete history/lineage) or just to an extended property (for latest/current version).

We’ve done something vaguely similar for a different purpose, so I can help if I haven’t explained it well enough.
September 3, 2025 at 7:53 PM
It may be a little bit tricky, but if you have a script in your database project which then builds as part of your build pipeline, and you can modify that script to have the SHA/PR included in a subsequent step, then just have it executed in the post-deploy step of the dacpac
September 3, 2025 at 7:52 PM
How do you determine the version number of the deployment?

You could always create an extended property that stores the version number, and auto updates/increments as part of the post deployment script in the dacpac?
September 3, 2025 at 7:34 PM
In fact, I don’t think there’s any way to do it other than field parameters. You’d need 2 identical field parameters defined, and then a measure that uses the 2 selected
September 3, 2025 at 2:31 PM
Then you can just use field parameters. Shout if you want some help
September 3, 2025 at 2:14 PM
I think that it’s a lot harder than the average game show, and there is less chit chat. Lots of quite hard questions, quickly. That’s certainly the appeal for me.
September 2, 2025 at 4:53 PM
Except for your fantasy team!
August 31, 2025 at 6:42 PM
Even more so now
August 25, 2025 at 9:03 PM
That’s really interesting. I’ve wondered if a ring is worth it, but this starts to make me want one. Particularly useful for my wife, who works in a hospital.
August 25, 2025 at 5:43 AM
That should be perfect
August 24, 2025 at 12:41 PM