« first day (4860 days earlier)   

5:08 AM
@SeanGallardy Well then.... mooooving right along
 
 
2 hours later…
6:40 AM
0
Q: Why is COMPATIBILITY_LEVEL: 160 using Clustered Index Scan?

DumpenDisclaimer: I'm a developer dwelling in databases, so my knowledge is limited We recently upgraded our MSSQL Server from 2012 to 2022 and in that regard also updated the COMPATIBILITY_LEVEL from 110/2012 to 160/2022 (all indexes have been rebuilt). But I'm seeing some difference in execution plan...

Logical reads strike again
 
 
5 hours later…
11:20 AM
I thought logical reading is what Sherlock Holmes does.
 
or Spock
 
11:34 AM
user image
4
 
@PaulWhite The best
 
12:13 PM
@SeanGallardy pfft .. that's not a crocodile, this is a etc. etc.
 
1:12 PM
@PaulWhite what a pal you are
 
1:26 PM
@MichaelGreen I figured you of all people would appreciate it
 
 
2 hours later…
2:56 PM
Wordle 1,041 5/6*

⬛⬛⬛⬛⬛
⬛🟨🟨🟩⬛
⬛🟨⬛🟩🟨
⬛🟨🟩🟩🟩
🟩🟩🟩🟩🟩
 
Wordle 1,041 3/6*

⬜🟨🟨🟨⬜
⬜🟨🟨🟨🟨
🟩🟩🟩🟩🟩
I am so back
 
Awesome!
My 4th attempt was a long shot and I knew it, I just couldn't think of anything else. But then I got the word wrong et voila, a new word sprung to mind.
 
Yeah, bit of an odd one yesterday
 
 
1 hour later…
4:03 PM
For those interested in C# around here: Refactor your C# code with primary constructors
I thought the feature was kind of neat. But the comments are BRUTAL.
 
Wow yeah
It’s like an SSMS release
 
4:24 PM
Two pages of comments to read
How delightful
C# has a bewildering array of language features these days
 
4:45 PM
@PaulWhite 😘
@PaulWhite It really does. And I have a hard time deciding what to invest mental energy into.
It feels like there's a lot of stuff that's just not relevant to what I do.
But I also don't want to turn into one of those people that never learns the new stuff, and I'm missing out. I have worked with devs who refuse to use all kinds of things that I have picked up and found to be extremely helpful in terms of "developer productivity" or ease of code writing.
(people who won't use ternaries, or LINQ, or var, null-coalescing operators, null-propagating operator, etc.)
 
5:26 PM
Is upgrading to newer C# versions as slow and tedious as new SQL versions?
 
@ErikDarling No not really. You get new versions of C# through updates to Visual Studio.
Sometimes you have to target a newer version of .NET, if the language feature needs new runtime support.
A lot of times, language features are built on top of the existing runtime components, so you don't need to update .NET.
 
 
1 hour later…
6:47 PM
That does seem a lot more convenient
 
 
2 hours later…
8:39 PM
Morning.
Sometimes, ancient texts mention Books Online. That used to be documentation, basically equivalent of today's learn.microsoft.com? Or was there more to it?
 
8:50 PM
Kendra Little gave me a cool nickname in her latest blog post.
 
@SeanGallardy > I find it quite odd to use a security product that itself uses the same techniques as the items it's guarding you against in order to keep things secure.
Quite. I guess you also don't use NextGen firewalls that do MITM on your SSL connections?
I fully agree with you, but I know a lot of IT peoples who are very strong for the Dark Side on this.
It's a complete nonsense to put all your faith in one puny device that can be hacked and to trust that beyond anything else on the network, when it itself is exposed to the Internet Wild West.
zero-trust except that you must trust us. What?
 
@JoshDarnell The comments are exactly what I needed today
@Charlieface NGINX does this, PFSense does it with captiva portals, etc., yeah I'm not a fan... like don't MITM me and tell me I'm secure!
@Charlieface Right, they won't give you keys but will gladly install them on an unencrypted system that admins can login to and read everyone's stuff... how is that security?
 
9:06 PM
@SeanGallardy NGINX addmittedly would normally be used as a reverse proxy on a single machine, and PFSense is a hobbyist product. I was thinking more the big guys like SonicWall, Fortigate, Sophos, PaloAlto, Checkpoint. They MITM everything and you need to install their cert on everyone's machine otherwise it all breaks.
 

« first day (4860 days earlier)