SQL Server developer, data mining enthusiast, general solution-finder, supporter of innovation, and fan of making T-SQL do really fun stuff. he/him.

Joined September 2011
47 Photos and videos
I feel like this every year highlights the difference between “the data” and “the story” better than any other example I can think of.
4 Dec 2024
Spotify wrapped is people waiting all winter for like 2 sql queries that’s wild
1
33
Ryan McCauley retweeted
28 Jun 2024
For the past four years it’s been my job - nay, my PLEASURE - to be the tweeter behind the @OKWildlifeDept account. This is my final post. It’s been my absolute honor to roast and ratio some of you into the ground in the name of science. Let’s take a trip down memory lane: 🧵
Replying to @OKWildlifeDept
DO NOT FEED WILDLIFE. IF YOU’RE GOING TO SHARE A DONUT - AT LEAST ASK US IF WE WANT IT FIRST. BECAUSE WE DO. WE LOVE DONUTS. DO NOT GIVE IT TO WILDLIFE - IT IS BAD FOR THEM - AND IT ALSO MEANS LESS DONUTS FOR US. MAKE BETTER CHOICES.
1,521
8,680
153,286
17,584,034
Ryan McCauley retweeted
28 May 2024
it was such a weird thing as a kid that everyone kept calling me a “computer genius” bc i knew how to…read what it says on the screen. what was up with that.
323
5,126
101,511
5,471,306
20 May 2024
Maybe everybody already knows this but if you use Excel, you Control-Shift-V might be the greatest shortcut ever. It pastes just the values, no formatting, as plain text including flattens formulas into their result. It's saved me SOOOO much grief. That is all.
15
25 Mar 2024
Whenever I see an interface that looks like it’s been around a while, I wonder what the story is. Here’s one :) Now on to wondering how long it’s been since the Outlook rules editing screen has been touched…
I wrote this Format dialog back on a rainy Thursday morning at Microsoft in late 1994, I think it was. We were porting the bajillion lines of code from the Windows95 user interface over to NT, and Format was just one of those areas where WindowsNT was different enough from Windows95 that we had to come up with some custom UI. I got out a piece of paper and wrote down all the options and choices you could make with respect to formatting a disk, like filesystem, label, cluster size, compression, encryption, and so on. Then I busted out VC 2.0 and used the Resource Editor to lay out a simple vertical stack of all the choices you had to make, in the approximate order you had to make. It wasn't elegant, but it would do until the elegant UI arrived. That was some 30 years ago, and the dialog is still my temporary one from that Thursday morning, so be careful about checking in "temporary" solutions! I also had to decide how much "cluster slack" would be too much, and that wound up constraining the format size of a FAT volume to 32GB. That limit was also an arbitrary choice that morning, and one that has stuck with us as a permanent side effect. So remember... there are no "temporary" checkins :) Follow me for more random code musings!
28
Ryan McCauley retweeted
19 Mar 2024
TIL: Stripe deploys changes to it's core API services 400 times per day 🤯
40
243
2,589
444,139
Ryan McCauley retweeted
23 Jan 2024
That’s it, I’ve found it. My favourite tweet of all time.
she's literally president of the maths society dude what more can you possibly want
245
1,303
20,807
1,958,567
31 Dec 2023
Yes to this. Of all the punctuation rules I learned, this one made the absolute least sense and I don’t even know what’s second place. I’ll fight if you’ll fight.
I will die on the hill that punctuation that is part of the sentence containing the quote not the quote itself should go outside the quotation marks. I know this is against every style guide in the world, but I will be the change I want to see in the world god damnit
62
14 Dec 2023
I love the troubleshooting process here - digging and dividing and then no giving up on something that just feels wrong.
Today at work there was a 11hr outage bridge call over a small but important area of the Windows network having application errors. Not debilitating but would be eventually. Here is how I helped solve it after being asked to take a look, and how I approach problems like this. 🧵
2
27
16,315
Ryan McCauley retweeted
This is me. Many thanks to everyone who has sent lovely messages and comments in the past couple of weeks in response to this video. Very happy that my first ever viral video is a positive message about love and kindness, which is way more important to me than fitness ❤️
28 Nov 2023
Groom secretly learns Korean for a year to surprise his wife and her family on their wedding day 👏 🎥: @bdccarpenter x @SoheeFit
58
991
8,481
827,680
19 Oct 2023
Does anybody that sees this have a blue sky code that they can spare? Feeling about done here.
102
Ryan McCauley retweeted
5 Reasons Why You Should Participate in the Microsoft Excel World Championship! 🏆 Now you really don't have any excuses to not participate anymore! Get your ticket while it's not too late! Sign-up closes on October 6: fmworldcup.com/product/micro…
3
7
21
21,749
20 Jun 2023
I can’t recommend the @heavyweight podcast enough - I’ve loved @J_Goldstein since #Witetap days, and the show takes dry humor, awkward phone calls, ridiculous what-if rabbit holes, and mixes in incredible storytelling and deep emotion into an absolute masterpiece. Every episode.
1
35
Ryan McCauley retweeted
10 May 2023
read this. DO NOT look up anything about it. just read it. it's only like 1,200 words u can download it on instapaper and it'll read it to you in two minutes. do it right now i'm very extremely serious. slate.com/culture/2023/05/am…
7
56
543
146,355
11 May 2023
This is so timely - my daughter’s (15) book club decided each person would pick an “epistolary” story for the summer and when she told me I immediately said “I KNOW ONE I KNOW ONE”. I loved this book and had forgotten just how much - it’s modern poetry and also great sci-fi :)
77
23 Apr 2023
I was absolutely floored by this book - all the ways that male-default thinking impacts our design and our safety. Things that were totally transparent to me an an average-sized male since the world was built for me by default, but now so obvious everywhere. We need to do better!
138
The plight of the Kens in this thread is amazing - I cannot stop laughing at some of the stories, and I think my daughter gathered her Barbies around a trash can and they ritually sacrificed Ken on the regular. Also, the Barbie movie is going to be amazing.
5 Apr 2023
barbie discourse in 2023 is insane. acting like Ken was marketed towards little boys and men are losing representation. No baby. ken was designed to officiate a 7 year old girls barbie wedding or to pad out the forces of the invading army in her war reenactment
1
56
Ryan McCauley retweeted
NEW: I’m not sure people fully appreciate how dire the US life expectancy / mortality situation has got. My column: enterprise-sharing.ft.com/re… And some utterly damning charts. 1) at *every* point on the income distribution, Americans live shorter lives than the English.
1,112
12,356
37,929
14,165,132
11 Mar 2023
This is what clenched it for me when I chose my current employer - 20 weeks of paid leave for both parents and birth or adoption. We’re done having kids and it’s a benefit I’ll never personally use, but for me it showed that they get that your job isn’t your life.
Happy international women’s day! Here are the companies in the Aerospace Industry with the most supportive parental leave policies that help keep women in STEM. ❤️
1
339