I’m fucking lost.

So, situation. I have a SQL table with about 3M rows (not a lot).

I have indexes. Indexes are used. BUT when I add where clause (On indexed column), it’s super slow. Around 10 seconds.

If I do select * (ALL 3M rows) and THEN I filter then on webserver side, it takes 0.5 seconds.

HOW my manual filtering is faster than DB filtering with indexes? I even tried bubble sort. Bubble sort is faster than SQL ‘where’. HOW ?!

I do not understand….

And if I add group by….. WELL, 25 seconds SQL time. 2 Seconds if I do select all and group by in code manually.

Does not make ANY sense to me.
What am I missing ?

Hmmmm,

Someone forgot to renew SSL

Normal people : Save thier work regulary.
Me :

Oh no matter, notepadd++ saves opens files somewhere, i'm good with that.

There are important lohins, passwords, some temp stuf and work in progress for something, there are backups and information needed.

!DEV

My mice stopped moving "efortlessly".

So I added a bit of scotch. Mice is working again very well and you don;t feel the drag !!

Yeah I should update my keyboard / mice, as they are in horrible state.

Linux is great
Linux can be customized

Welp, not so much. Simple things are not possible to do.

After 1H research I can't have timestamp near each line over SSH.

I'm not talking "history", i'm talking live.

basiclly I want to see timestamp on every single output line.

Basiclly this :

https://unix.stackexchange.com/ques...

But running automaticly for each command ever.

To be fair, same problem exists in PowerShell on windows
https://stackoverflow.com/questions...

And no, I don;'t want to switch to some random halfbaked teminal.

Trying to do something "particular"on linux. Prepare yourself to have 30+ tabs of browsing opened.

BUT ! it's strating to work ! (I'm doint some bizzare SQL stuf to speed up my DataBase deployment in local and be able to get a fresh copy of production in under 30 seconds)

https://imgur.com/a/HJzHYQ8

C# :
Welcome to C#, as it is a very powerfull and typed language you will never have issues with Equals and "==".

Also C# : (image)

Edit : It's actually wrking as expected, but I would';ve guessed that "==" would wotk for basic types

Well well well.
Story time.

Since we are working from home for the past 4 months, I finally decided to install a Microsoft SQL server on my home server. (Mostly was using Azure)

My server is running Windows Server 2012 R2.
Tried installing SQL 2019 : fail, 2016 : Fail, 2012 : Fail. Some obscure message about some DLLs not being at right version. (And a warning that it is no recommended to install SQL server on domain controller, but I know, it is my home setup, not roduction)

“Ok fine, I’ll install it on my PC instead”. Windows 10 PC. NOPE. “Cannot install on a compressed drive”. Welp, wtf ? (Of course you cannot select destination install folder, I could’ve put it on another drive).

So here I am. Working 100% on Windows, installed Ubuntu server 20 LTS in Hyper-V, Installed Microsoft SQL server on it (BTW, install is very easy compared to windows). And that shit is working. And new “Terminal” app does support SSH out of box, no need to add Putty !

So as a Windows user, I needed Linux to make Microsoft SQL techno work.

Nothing will ever surprise me anymore. (BTW it’s fucking fast. I like SQL server on Linux)

Best android APP :

DNS666

/change my mind

FrontEnd developper :

Hello here is the STATIC page you asked. Only takes 300 MB of frameworks to make it work.

Are these people on crack or something ?

Recruiting front end right now… I’m tiered of this BS.
95% of applicants: “hey I don’t understand what you want, but look at my cool, ToDo app in <INSERT ANY framework>”
“Ok, now add a quick search in your todo project”
“Oh wow, it’s like 5 days work lol and should be managed at back end. I Shouldn’t care”.
How HOW these idiots even have a job ?
I’m out of words. I want to scream, pull my own hair and (Weirdly enough) watch a DareDevil movie

Hmmmm,

not sure how to feel there :)

https://twitter.com/shadraza1/...

I find it technically very cool, moraly still not sure. I have terminator PTSD

Not a rant. Just how far technologie came.

on the right:
1 Episode of a new show, 4k hdr etc : 9GB

On the left:
Whole season (26 episodes) of startrek Voyager (DVD quality).

I find this pretty much fun.

Hello.
So we have a query inside our company :
We are developers. We are (At least supposed to) logic.
Do you think We developers can influence environment of the planet?
For my self : Not sure, but I would like to believe that more my code is optimized, less resources it will use.

To all developers working on publicly visible APIs or writing public documentation.
DON’T BE A DICK !
Do not just put a screen capture of your curl request which takes 10 minutes to write by hand.
Do not show me list of arguments as an image.
Have AT LEAST one executable demo project (Any language)
And, it’s 2020, add a fucking proxy generator.
How hard can it be?

Why do I even go back to https://www.theverge.com/ ? Why ?

So, I quote :
"Sandra L., who also requested that I withhold her surname, used Examity for a midterm in her astronomy class at Ocean County College in New Jersey"

How many Sandras in astronomy classes do you think they have at Ocean County College in New Jersey?

"We protect identity of sources"

Me :

I will use .Trim() before ToLower(), so ToLower has potentially less characters to iterate over.

Also me :

What ? Only 5.000 rows ? Let’s load them all ! It’s faster then use “where” and “group by”. No problems !

A usefull function, everyone should have near by. May requires some optimisations.

/// <summary>
/// DoEs tHiS To tHe pRoViDeD StRiNg. StArTs aLwAyS WiTh a cApItAl
/// </summary>
/// <param name="s"></param>
/// <returns></returns>
public static string DoThIsToThEtExT(string s)
{
var array = s.ToCharArray();
Parallel.For(0, s.Length, (index) =>
{
if (index % 2 == 0)
{
array[index] = array[index].ToString().ToUpper()[0];
}
else
{
array[index] = array[index].ToString().ToLower()[0];
}
});
return new string(array);
}

Can someone rollback the 2020 patch already ? It's buggy

https://worldometers.info/coronavir...

I hope they are using int64 and not int32

WTF is this bullshit ?

https://securityheaders.com/

Basiclly you get an "F" if you don't provide these headers.But there is NO obligation for any browser to follow these headers. And if it is an attacker with custom software there is no point at all.

I love Azure. But WHY do I need to add vCores SQL for more logs/io ?

Why is it even limited ?

So no, I won't add 350$/month for 1 more vCore just for some more Mbits of log io bandwich

Which syntax is "correct" TypeScript syntax ?. I prefer the first one. But what's about guidelines ?

Note for UpperCase variables: yes I know. We use that syntax to differentiate public and private variables. (Yes I know that doesn’t exist in JavaScript)

Use linux they said. It is stable they said.

I use a linux VM for managing DNS with BIND and configuration via WebMIN.

A minor webmin update : Sure, let’s click.

“Update failed. WebMIN requires UnZIP” Poof whole interface is down. Here we go for 30+ minutes of manual rolling back, installing unzip, retrying update. That shit only happens on linux.

Windows 10 is safe they said. Signature/https can be trusted they said.

When even NSA disclose "hacks" you know it's too big

https://wired.com/story/...

Still talking resolutions ? This is mine

Don't know if it was already posted. Best way to add 2 numbers so far

2017. Because 1st January is Sunday and it fucked up all my code for business days calculations.

We are in 2020 (almost) and I'm STILL fixing some of data problems caused by that.

strangely enough my SQL function works perfectly, only my C# equivalent has problems. I would’ve suspected opposite from myself

Am I crazy to ask that ?

So looking for a front-end developper. This is a mini project I ask candidates to do.

Is it too much ?

Perfect errors count!