James McGillivray's Avatar

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

387 Followers  |  263 Following  |  151 Posts  |  Joined: 05.08.2023  |  1.9493

Latest posts by jamesmcg.bsky.social on Bluesky

Not cooking for thanksgiving, but tonight’s dinner has had onions caramelising for the last 90 mins. Almost ready

09.11.2025 16:46 β€” πŸ‘ 3    πŸ” 1    πŸ’¬ 0    πŸ“Œ 0

nscandanavian(max)

09.11.2025 10:31 β€” πŸ‘ 4    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Just tell me when and I will help you plan the best trip πŸ€—

09.11.2025 04:35 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
A selfie of me, late afternoon, with a family of 3 rhino (2 adults and a baby) eating in the background, no more that 30m from me.

A selfie of me, late afternoon, with a family of 3 rhino (2 adults and a baby) eating in the background, no more that 30m from me.

Sun setting over a dam, with 2 rhino and 2 giraffe on the far side of the dam

Sun setting over a dam, with 2 rhino and 2 giraffe on the far side of the dam

2 cheetah lying in the shadow of a car, early morning. One has his mouth wide open with teeth clearly visible. The other is facing away from the photographer

2 cheetah lying in the shadow of a car, early morning. One has his mouth wide open with teeth clearly visible. The other is facing away from the photographer

A small herd of Zebra set in front of the majestic Waterberg mountains in Limpopo, South Africa.

A small herd of Zebra set in front of the majestic Waterberg mountains in Limpopo, South Africa.

Have some pictures of sunshine before 8am, after 4pm, wild animals, and other concepts foreign to Europe for November and December! 🀭

07.11.2025 19:43 β€” πŸ‘ 6    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

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!

07.11.2025 19:00 β€” πŸ‘ 4    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

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.

05.11.2025 12:16 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

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

21.10.2025 18:31 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
Preview
a woman in a fur coat is standing in front of a brick building and saying `` my eyes ! my eyes ! '' ALT: a woman in a fur coat is standing in front of a brick building and saying `` my eyes ! my eyes ! ''
17.10.2025 10:05 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

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

28.09.2025 16:04 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

OMG me too!

18.09.2025 12:30 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Me too! #FirstTime #MVPBuzz

16.09.2025 18:47 β€” πŸ‘ 3    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Hope everyone at @fabconeurope.bsky.social has an amazing time! Wish I could be there!
#FabConEurope #FabConEurope25

16.09.2025 06:38 β€” πŸ‘ 4    πŸ” 1    πŸ’¬ 0    πŸ“Œ 0

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?

03.09.2025 19:56 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

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.

03.09.2025 19:53 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

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

03.09.2025 19:52 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

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?

03.09.2025 19:34 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

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

03.09.2025 14:31 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Then you can just use field parameters. Shout if you want some help

03.09.2025 14:14 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

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.

02.09.2025 16:53 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 2    πŸ“Œ 0

Except for your fantasy team!

31.08.2025 18:42 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
Preview
a close up of dory 's eyes from the movie finding dory Alt: a close up of dory 's eyes from the movie finding dory
28.08.2025 13:46 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Banner from the Excel World Championships event where I am currently lying 13th, with 1470 points.

Banner from the Excel World Championships event where I am currently lying 13th, with 1470 points.

A birthday gift from my wife, a mug which reads, β€œFreak in the Sheets”, and has a Microsoft Excel logo.

A birthday gift from my wife, a mug which reads, β€œFreak in the Sheets”, and has a Microsoft Excel logo.

Looking forward to the Microsoft Excel World Championships South Africa Final this weekend!

My wife always believed in me (see my birthday gift from her 3 years ago), but it’s nice to have some proof 😁

Looking forward to the challenge!

28.08.2025 05:54 β€” πŸ‘ 3    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Even more so now

25.08.2025 21:03 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

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.

25.08.2025 05:43 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

That should be perfect

24.08.2025 12:41 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Should be fine. Just let me know what time, have a toddler to feed, bath etc.

24.08.2025 12:19 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

I also have a unique team. In fact, there are 0 managers who have the 8 or more players in common with me 🫣 genuinely surprised, but I guess most people have one of Salah or Haaland, and with either of those it’s hard to match many of my players. Tried a semi-premiums strategy this year.

23.08.2025 11:41 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

Where did you check this? Very cool to know

23.08.2025 10:10 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

I’d be keen to join you at some point!

23.08.2025 10:07 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0

Do it right first time!

22.08.2025 19:12 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0

@jamesmcg is following 20 prominent accounts