Disclaimer: 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...
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.
@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.)
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?
@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.
@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?
@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.
@Charlieface I know some large places that use PFSense and NGINX, it's crazy man
some of them were on-the-fly creating signed certs from known good cert owners and you wouldn't have to install it, it was already trusted, super sketch