Craig Wilkinson's Avatar

Craig Wilkinson

@sqlcadavre

๐Ÿด๓ ง๓ ข๓ ฅ๓ ฎ๓ ง๓ ฟ๐Ÿ‡ฌ๐Ÿ‡ง๐Ÿ‡ช๐Ÿ‡บ SQL specialist polyglot engineer, general tinkerer, slow runner, FPL enthusiast and lover of Scotch. Opinions are my own. He / Him http://www.craigwilkinson.dev

21
Followers
28
Following
8
Posts
18.10.2023
Joined
Posts Following

Latest posts by Craig Wilkinson @sqlcadavre

SQLBits 2025: Tempdb, Fabric, and Life After eGain I didnโ€™t expect my time at eGain to end with a โ€œthanks for all your hard work, but due to structural changes weโ€™re canning the entire UK engineering team,โ€ but here we are. I missed SQLBits last year....

Published my recap from @SQLBits 2025. One free Saturday, seven sessions, and more insight than I was honestly expecting.

If you missed @SQLBits, or just want a second opinion on what @Microsoft has been doing, give it a read:
www.cadavre.co.uk/posts/2025-0...

23.06.2025 17:02 ๐Ÿ‘ 1 ๐Ÿ” 1 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0
When Legacy Code Meets Modern Load: A Deadlock Story Recently, we encountered a persistent deadlock issue during a high-concurrency load test involving 100 simultaneous database operations. Although the database had sufficient capacity, a large portion ...

We ran into deadlocks during load testing, thanks to some old SQL that disables triggers on the fly.

Rewriting it properly? Thatโ€™s the dream.

But for now, a quick SESSION_CONTEXT hack got us through.

Hereโ€™s what happened:
www.craigwilkinson.dev/posts/2025-0...

24.04.2025 08:04 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0
Rebuilding StravaDataAnalysis: From First Python Script to Proper Architecture I started StravaDataAnalysis in 2021 as a way to learn Python. And by learn, I mean literally my first Python scripts. I had never written a line before. At my day job, we were looking to transition o...

Iโ€™ve just rewritten my Strava Data Analysis project - same idea, cleaner code & smarter charts.

Still powered by Python, but way less embarrassing now ๐Ÿ˜…
www.craigwilkinson.dev/posts/rewrit...

23.04.2025 07:06 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

Please don't be true, not sure my faith in humanity can afford to take another hit

08.11.2023 10:32 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

Assumed that I'd have moved to California by the start of SQLBits. That's looking less likely now, so do I risk getting tickets with the possibility I won't be around for it?

25.10.2023 21:10 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

Today marks 7 years of marriage and 18 years together with my incredible wife. Still wondering how she's managed to put up with my antics all these years

23.10.2023 07:21 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0
Post image

Wildcard draft for GW10 #FPL #FPLCommunity

22.10.2023 15:53 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

Why have Spotify added Audiobooks to only the plan manager for the premium family plan? Why can't we share the hours between each account?

20.10.2023 13:05 ๐Ÿ‘ 3 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0