@nadnerB said in Miscellaneous Tech News:

Dell h4xed?
https://www.itnews.com.au/news/dell-resets-all-customer-passwords-after-cyber-attack-516224

It may be true in Australia, but is it true in America? Huh? Ever think of that?

Pfft, idiot.

@DustinB3403 said in What did you have for lunch or dinner today?:

Leftovers from dinner, pizza.

Me too

@JaredBusch said in What Are You Doing Right Now:

@scottalanmiller said in What Are You Doing Right Now:

Trying a forced 1809 install as the existing system can't patch.

I can't even force it with the upgrade assistant

Is it wrong I read that "thank you" in a passive aggressive and sarcastic tone? Seems fitting.

It'd be helpful to know what EHR it is, there may already be queries out there to do things like get the right associated data. It's not that complex. With the right information it could be fairly quick, but without any information it may require doing things like logging the queries and looking up patients to see how the information is joined and/or what different tables are queried. Even doing this near-black-box you can gain a lot of information, you don't need to necessarily just reverse engineer the entire schema if you can see how it's being used. I've done this plenty of times with MS SQL Server and EHRs and ERMs who have no APIs or documentation.

Youtube Video

@scottalanmiller said in Integrating OnlyOffice with NextCloud:

@Obsolesce said in Integrating OnlyOffice with NextCloud:

@scottalanmiller said in Integrating OnlyOffice with NextCloud:

If you go look at their product listings, nearly every page points to a comparison of why you would pay when it is available for free...

https://www.onlyoffice.com/compare-server-editions.aspx

And when mentioning the free version, they give you a "get it now" button to make it simpler to get the free version.

For me, there is no default download page. It just gives options for the different paid versions, or the free desktop app. Everything else leads to paying or trying out after inputting your info and making an account.

It is not obvious getting to those pages you linked. I actually can't find a way to end up there from their main page, following the obvious paths.

I got there right away from going to the comparisons of enterprise vs free.

Indeed:

https://www.onlyoffice.com/download.aspx

@Dashrender said in Integrating OnlyOffice with NextCloud:

$1100. Holy cow!!

Youtube Video

@siringo said in What Are You Doing Right Now:

been sitting on my backside for 8 hours with no one asking me to do squat. comes 4pm and all hell breaks loose....

Indeed, the fall out from the capture of Lemberg by Polish Legions will surely impact our armistice agreement with the new government in the Russian Empire. Unfortunately with the abdication of the Kaiser and the nobles on the 9th and the Emperor King of Austria on the 10th, and a proclaimed republic in Weimar, I can no longer be in denial that the war is over. Get the diamonds from my safe, soon I'll be needing a more portable form of wealth, unless things work out then I shall create a baller ass necklace that says "Sexy".

Keep on truckin'
Tony Showoff,
November 23, 1918

@JaredBusch said in Random Thread - Anything Goes:

@tonyshowoff said in Random Thread - Anything Goes:

@JaredBusch said in Random Thread - Anything Goes:

@JaredBusch said in Random Thread - Anything Goes:

@JaredBusch said in Random Thread - Anything Goes:

@JaredBusch said in Random Thread - Anything Goes:

Microsoft can kiss my fucking ass.

SQL, Excel, Access, all of it.

This keeps getting up votes.. so for reference...

So the workaround... I manually created a table with all the columns in the spreadsheet using datatype NVARCHAR(255) for every column.

I opened the spreadhseet in LibreOffice Calc.

Saved the sheet as a csv, chosing the | for my delimiter because it does not exist in the file.

Then some find/replace magic in VSCode.

' -> ''
" -> ""
\n -> ');\n
| -> ','
^ -> INSERT INTO NETL_Import (columns listed) value ('

Saved as NETL_Import.sql and ran it in Azure Data Studio.

12328 rows imported later, I now have to clean all that shit up into real data types.

Figured out a bunch of easy cleanup....

Now working my way column by column to make shit correct..

But it will be correct, and it will be a repeatable script. Because there is no way in hell that we've been told everything correctly.

So, done. I have the data in my local test system.. OMG what a pain in the ass.

Oh and now, I cannot just dump the data and import it to their host, because SQL Server isn't designed for that........

Whenever I have to deal with insane escaping or anything like that in generated SQL, I just convert the value to binary, so:

O'm"
lol

0x4f276d220a6c6f6c

I didnn't design the database structure. I'm just working with it.

The structure doesn't matter, if you're pulling out the data from a CSV, you just create a hex string (make sure you start with 0x) of it so you don't have to worry about escaping new lines, quotes, and the few other characters needed.

@JaredBusch said in Random Thread - Anything Goes:

@JaredBusch said in Random Thread - Anything Goes:

@JaredBusch said in Random Thread - Anything Goes:

@JaredBusch said in Random Thread - Anything Goes:

Microsoft can kiss my fucking ass.

SQL, Excel, Access, all of it.

This keeps getting up votes.. so for reference...

So the workaround... I manually created a table with all the columns in the spreadsheet using datatype NVARCHAR(255) for every column.

I opened the spreadhseet in LibreOffice Calc.

Saved the sheet as a csv, chosing the | for my delimiter because it does not exist in the file.

Then some find/replace magic in VSCode.

' -> ''
" -> ""
\n -> ');\n
| -> ','
^ -> INSERT INTO NETL_Import (columns listed) value ('

Saved as NETL_Import.sql and ran it in Azure Data Studio.

12328 rows imported later, I now have to clean all that shit up into real data types.

Figured out a bunch of easy cleanup....

Now working my way column by column to make shit correct..

But it will be correct, and it will be a repeatable script. Because there is no way in hell that we've been told everything correctly.

So, done. I have the data in my local test system.. OMG what a pain in the ass.

Oh and now, I cannot just dump the data and import it to their host, because SQL Server isn't designed for that........

Whenever I have to deal with insane escaping or anything like that in generated SQL, I just convert the value to binary, so:

O'm"
lol

0x4f276d220a6c6f6c

@scottalanmiller said in What Are You Doing Right Now:

It's the holiday, so like everyone is going somewhere tomorrow.

It is tomorrow and I'll be working all day

@Donahue said in Windows Server 2016 License question...:

@scottalanmiller said in Windows Server 2016 License question...:

No cheap upgrades. Owning 2012 R2 doesn't get you any discounts on your 2016.

But it does entitle you to CentOS, Fedora, Suse, or Ubuntu for absolutely free!

so does not owning 2012 R2

Twice the benefits then!

This whole thing is reminding me of Harold Macmillan: "You've never had it so good."

@StorageNinja said in Nine Out of Every 10 Silicon Valley Jobs Pays Less Than In 1997, Report Finds:

@tonyshowoff said in Nine Out of Every 10 Silicon Valley Jobs Pays Less Than In 1997, Report Finds:

Except, again, I'm talking pre-inflation since then. Let me know when they're paying engineers $190K+ because that's what it would be now. It sounds like a lot now because they've kept wages down against inflation.

and again, I'm not talking base wages. The plans are so stock and bonus heavy now that TC is the number that should be compared not wages. Also, I don't know if H1B wages are a good indicator of a "good" median career engineer (Just looking for public data). Now I'd argue the bigger thing is inflation adjustment's kind of a mess because the real estate market there and tax climate has gotten so ridiculous that's the bigger reason TC has to be as high as it is. It's not about wages being held down, it's about local real COL going to the moon.

And there isn't the entire country, even though it likes to think it is. If wages are down nationally against inflation especially, I don't give a damn about extras in the Bay Area, especially if I have to live deep into the East Bay to get by. Prices of living and benefits in Silicon Valley and the Bay are not the end-all-be-all on national wages. If I point out wages are down in Dallas, you can't say "Well, here in San Francisco it's about blah blah blah" and ignore the point I'm not talking about an area so out of control that using at as anything more than a case study is a ridiculous idea.

@StorageNinja said in Nine Out of Every 10 Silicon Valley Jobs Pays Less Than In 1997, Report Finds:

@tonyshowoff said in Nine Out of Every 10 Silicon Valley Jobs Pays Less Than In 1997, Report Finds:

A Good "Engineer" can still make 125K.

We pay H1B's 130K base is what I'm seeing for federal stats. A good engineer working for FAANG, or one of the other big players can break 300K TC. You want to see some crazy high offer letters go look on Blind in the spring when offers start going out to graduates.

Except, again, I'm talking pre-inflation since then. Let me know when they're paying engineers $190K+ because that's what it would be now. It sounds like a lot now because they've kept wages down against inflation.

@StorageNinja said in Nine Out of Every 10 Silicon Valley Jobs Pays Less Than In 1997, Report Finds:

A Good "Engineer" can still make 125K.

That wasn't an inflation adjusted amount, so technically they're still making less value even if they are making the same amount. Plus if I'm in Silicon Valley or New York or whatever, it's just good enough, but my point was that it was nationally that good, now it's not. I lived in the Bay Area back in the mid-90s and it was out of control back then. You can make a bit more so long as you're living in a place that costs a lot more. So it's meaningless to me how well the jobs there are paying when my point was the loss has been pretty large since then. And @Dashrender already pointed out above there's a general drop of wages, and I even posted about it in News [rhetorical point since you're here].

So what I can get paid the same, possibly a bit more than I did 20 years ago, but because of inflation it's actually still less no matter what and because of the places where I can get it now I'll have to spend almost all of it just trying to live in the area? That sounds like a bad deal to me and all the promises of stock options, profit sharing, etc are just ways to try to make up for the fact they're making more while you're making less.

It's the fuzz! Ditch the topic!

And nothing of value was lost.

@DustinB3403 said in Nine Out of Every 10 Silicon Valley Jobs Pays Less Than In 1997, Report Finds:

Anyone who believes in ITT Tech needs to be ignored immediately.

There's a thread, actually a couple, on SW where I criticise ITT Tech and people say things like:

So what because I went to ITT Tech I am inferior to you in some way? I have personally studied IT at 4 different Universities, not to mention what I learn while I was in the military and I can tell you personally, besides the military, ITT Tech was the only place that provided hands on training and cut out all the crap people did not need to work in this field.

I wholeheartedly agree with you that ITT Tech is super expensive, scam is a bit harsh I think but expensive, yes absolutely. Just because I spent double what others may have spent does not mean my education was not a good one.

And a whole lot of just whining that someone dare question ITT Tech's value and that because they got something out of it at two or three times the price of a community college or trade school that I must be crazy or hate my job or my life to dare question it. The level of narcissistic rage, ironic anti-intellectualism, and inferiority complexes is pretty amazing. In one of the threads someone threatened to kick my ass for questioning their "education." Claiming I'm a user and I hate IT/IT people and can't help others so I'm angry inside, yet not getting I have a high spice level because I help people.

Not to mention the Tumblr-level of "boohoo you're making generalisations about IT people!" primarily because I point out that a lot of IT people have huge, undeserved egos, so naturally the response was to say that I'm wrong, it's a generalisation and they're actually pretty awesome at IT and kick ass 24/7.

Then ITT Tech went bankrupt and a lot of people had to come to the realisation it was just a scam. You'd think the fact they spent a ton of money to get an entry level position (even ITT Tech says that latter part in their commercials) would show the education had essentially no value at all.

I said straight up ITT Tech looked bad and most people didn't take it seriously, I was straight forward, honest, and up front as someone who has hired a lot of people and purposely ignored résumés with ITT Tech... that made me "rude." Sorry I wasn't going to sugarcoat a scam. And people started projecting and bitching saying "Oh you're calling me ignorant/stupid/underskilled/etc" even though I literally never say that. I think they say it because that's how they feel, not because of what I said, no matter the fact that in all those threads I repeatedly say I didn't make judgements on them, just the "school." People know it's garbage, they just don't want to hear it, and when they do it must be because it's a personal attack, even when I'm not even speaking to them.

Going to ITT Tech doesn't make anyone ignorant or unskilled or stupid, because sometimes people make mistakes, they go other places, they learn on the job, etc. but when they put their whole skill level into just ITT Tech and then if someone question it they see it as a personal attack, that's just being delusional and realising that maybe you are underskilled and that's why you think it's personal.

I feel like someone who went to ITT Tech then got a real job, and learned things, probably wouldn't tell anyone (publicly) they ever went to ITT Tech once they realised their entry level job they spent tens of thousands of dollars on taught them more in a week than they learned with their "hands on" ITT Tech "education". If they don't do that, then I just await the whining, complaining, delusions, and projections of their internal issues onto me for daring question their dumb ass school.