The Heap™ – Consultancy ©®

12:23 AM

@PaulWhite I honestly don't know haha. Some odd copy paste mistake I guess. I left her a comment 😁

4 hours later…

4:33 AM

@SeanGallardy Microsoft and their naming schemes, amirite? Anyway, thanks for insight.

5:10 AM

Wordle 1,042 4/6*

⬛⬛⬛⬛⬛
⬛⬛🟨⬛⬛
🟨⬛🟩⬛⬛
🟩🟩🟩🟩🟩

If the question has duplicates on other substacks, does it still count as duplicate, or do we want an answer here, too?

Typically we want to ensure the most appropriate site has the canonical Q&A. But that's not a hard and fast rule.

So... the SQL question should belong here and we should the mark others as duplicates? :-D

Nice.

Nvm, just curious.

The only way to cope with having a Language within a Language, is to SHOUT the commands at the SQL interpreter ... — Ben DeMott Aug 15, 2011 at 21:57

@Yano_of_Queenscastle that particular question I don't think belongs here really at all since it's opinion based mostly

I mean one could profer some good opinions, but it would be mostly just opinion.

Like for instance one opinion would be that with T-SQL, the documentation is all uppercase, hence "this is the way."

@Yano_of_Queenscastle honestly I think our opinion is worth way more than the ones on the softwareengineering.se site.

5:25 AM

@HannahVernon I agree the question is rather opinion-based, but since it stayed here for almost whole day, i assumed it's okay-ish.

I like your answer, but its definitely opinion based

For the record, UPPERCASE KEYWORDS is the way to go, though.

Also, all T-SQL should be written on a case sensitive collation server

@HannahVernon Obviously, duh.

@HannahVernon Is it? I though my answer boils down to "Outside of niche cases, it is matter of preference". Which... seems to be quite objective, no?

@Yano_of_Queenscastle No, sorry I meant the question is opinion based not your answer

I just finished migrating a db2 database where all of the columns and table names and schemas and everything are all uppercase so literally everything is uppercase. Super annoying. But ain't nobody got time to change the entire code base just for preference.

it's 12:35 AM, so I'm going to sleep. Good morning Heapers

Good morning

6:14 AM

@JoshDarnell I hope you corrected it to Darneli

6:44 AM

littlekendra.com/2024/04/23/…

She got it right the second time around.

1 hour later…

J.D.

7:53 AM

@HannahVernon Chaotic Evil: Change the collation to case sensitive so any improperly-cased references to those objects break. Though it'll probably result in the code being changed to match the all uppercased objects, opposite of what you'd want. 🙃

@ErikDarling I have received the bobble and he is sitting nicely between my Alonso and DeGrom bobblies. Thanks bud! 🙂

2 hours later…

10:21 AM

Open Sourcing DOS 4

GitHub link: github.com/microsoft/MS-DOS/tree/main/v4.0/src

@J.D. woohoo!

Sean Gallardy

@JoshDarnell It's kind of both odd and nice to have an "OS" that basic sometimes

10:56 AM

@SeanGallardy Heh, I don't have a ton of personal experience with OSs like that 😁 The first computer I remember using a lot was Windows 3.1, although I think it booted to DOS and you had to type "WIN" to launch Windows.

After that, my closest experience would probably be using CLI tools for programming stuff, and mucking around in Linux on my Raspberry Pi units.

Sean Gallardy

I want to say the first computer I ever used was an Apple IIe. Then an 8088 (meanwhile Windows 95 was already out) and that's when I "learned" BASIC. It was honestly kind of nice to have the simplicity back then.

Gosh, I have no clue what hardware that Windows 3.1 computer was. I wonder if my mom remembers.

@JoshDarnell Me too, distinct memories as a kid of installing both Win3.1 and 95 from floppies. My first own one was a 486dx2 at the grand speed of 100mhz

And writing my own machine code mouse handler for some BASIC program I wrote

morning

fun times. I must have crashed it a hundred times getting that working.

11:04 AM

@Charlieface Haha that sounds fun.

I was very young when I had that computer, elementary school. I had no interest in or thought of programming. I remember my mom writing down the steps to "cd" to the right directory so I could run "keen.exe". It was on a little piece of paper next to the keyboard.

I started with a VIC-20, then CBM-64. I didn't get onto the IBM PC until I started work

I remember looking at a ZX-80 in a store and wondering how I'd ever be able to afford one

University had old green screen IBMs of some description, with a Winchester disk. Some more modern 286/386s running WordPerfect

My first was an 80486 DX 2 with 40 MB HDD and 2 MB RAM

I had a friend with a 286, used to play a shooting nazis game of some kind

3D maze thing

Wolfenstein 3D (DOS) - A Nazi Killing Gunstravaganza! - Saturday Afternoon Gaming

Wolfenstein?

►

> The ZX80 was Sinclair’s first computer sold in the United States. Launched in June 1980, the ZX80 was notable for its size, weight and price. At 7″ x 9″, weighing less than a pound and priced at $199.50, it was the smallest, lightest and least expensive home computer available at the time.

Nifty

11:12 AM

@JohnK.N. Yep, thanks

timexsinclair.com/computers/sinclair-zx80

> The ZX80 display was equally unconventional. Instead of a full-screen of code where any line could be edited at will, the ZX80 display was divided in to an upper area of 32 characters across by 22 lines down. A lower section, of two lines, was the “input area” where users enter program lines or responded to input prompts from the computer.

@JoshDarnell Black & white, screen went blank when running a program to free up CPU power, if memory serves

That's wild.

1KB RAM 😀

Upper case only, so that solves the T-SQL keyword issue

Nerds

No wonder you’re all so smart now

11:45 AM

@JoshDarnell Nice, commander Keen?

commander keen, that was fun. I think I still got a copy somewhere. Dangerous dave also.

Still blows my mind that Wolfenstein was the very first 1st-person shooter, and they cut their teeth on the graphics like that. People seem to think Doom was the first but it wasn't

Larry Laffer

I only remember a stupid blue mushroom enemy that would jump

@Zikato Yes!

I got it on Steam a while back. Still very fun tbh. Maybe that's the nostalgia effect though.

@Charlieface The graphics are pretty good, aren't they?

How Prince of Persia Defeated Apple II's Memory Limitations | War Stories | Ars Technica

12:04 PM

The constraints bred creativity

►

12:30 PM

@JohnK.N. I think you mean Leisure Suit Larry

Wolfenstein 3D (id Software) (1992) Episode 1 - Escape From Castle Wolfenstein (Complete) [HD]

►

remember this came out in 1992 it's insane

FWIW If you used GPT partitions instead of MBR ones you would not have a 2 Tb limit. — Stephen Morris - Mo64 3 hours ago

lol

That dude's replies are all over the place.

Sean Gallardy

12:58 PM

@JoshDarnell Yeah I had leave a comment

@SeanGallardy could you ever see a situation necessitating such a large ldf?

Rebuilding a 2TB index 🥳

1:14 PM

@ErikDarling I was referring to the character.

Larry Laffer

Lawrence Laffer is a player character and the protagonist in the Leisure Suit Larry series of adventure video games, created by Al Lowe and Mark Crowe for Leisure Suit Larry in the Land of the Lounge Lizards in 1987 and later voiced by Jan Rabson. A man approaching middle-age, Larry is a balding nerd who, following a lifelong virginity, has suddenly become obsessed with sex and now lives a new life, awkwardly trying and usually badly failing to seduce attractive women. Due to the popularity of the series in the later 1980s and early 1990s, Larry was one of the well known video game characters during...

@Charlieface ----^ 1987

1:31 PM

Well yes

LL AKA LSL

@JohnK.N. where do you get that date from?