@HannahVernon My all time favourite seen in Access. Was a pain to convert to a SQL Server database, because the developer didn't have any time to rewrite everything: tblSupplierInformation (This table is used to insert everything we know about our suppliers. Don't insert anything customer related)

Wow cool table name lol. So easy to type!

Yes, indeed. That's when you start appreciating Red-Gate's SQL Prompt or Softtreetech's SQL Assistant.

Morning

btw

Morning

@HannahVernon smells like a powershell problem

could be any number of things i reckon but, just as a POC...

cloudblogs.microsoft.com/sqlserver/2021/09/08/…

Open sourcing the .NET 5 C# Language Extension for SQL Server

🎉

@HannahVernon db<>fiddle betrays you :p

@PeterVandivier and not to get too "who's on first" about it, but just for posterity:

@PeterVandivier it seems pointless... ;)

@McNets poetryfoundation.org/poems/46565/ozymandias

> “King of Kings Ozymandias am I. If any want to know how great I am and where I lie, let him outdo me in my work.”

was more shooting for the "vast and trunkless legs of stone" vibe, but yea :p

> think you can quote with a response but need a newline? 🤔

yup

I pressed Ctrl+K and I messed it up

Yep, I requires a new line

well then you deserve the shame of having done so on the permanent record of the transcript

😜

Set in stone!

Vast and Trunkless.

@McNets chisels stone

> 😂

@PaulWhite 👍 Paul, The Sculptor.

does anyone know what the syntax is called when - in postgres - you prefix a string with b or x to cast it to bit e.g.

was trying to formulate a question where i want to use that syntax against text data from an expression rather than a string literal and i couldn't get it to work on db<>fiddle :(

now without knowing the name of what i'm trying (cast to bit/binary/etc all have much higher hit-rate questions/blog posts/etc), i'm sort of not sure how to proceed

;p

^^^ that's what the output looks like in SSMS

morning, btw

yea, i figured. just meant that dbfiddle removes the fun of the prank

it sure does

and a fine morning to you too fellow unordered tuple

LOL who you calling unordered

disordered?

I prefer chaotic

plasmoid

SELECT HannahVernon WITH (NOLOCK)

@PeterVandivier now you're leaning towards calling me gaseous

:p

did you see the trailer for The Matrix Resurrections?

ooooooh eeeemmmmm geeeee

yaaaaaassss

it sure looks sweet

i may have been slightly tipsy when i watched it

and it comes out on my birthday which is like my own special present

gonna go see if it holds up under the weight of sobreity

brb

@PeterVandivier "may"

my BAC is eventually consistent, so there's really no way to be sure

"After all these years, to be going back to the Matrix!"

it's actually better

actual chills

It's amazing how full of allegory that series of movies really is.

i have absolutely no business being so hyped for this move

@PeterVandivier yah, I was blown away when I watched it.

I only hope it lives up to the hype

a dangerous hope

yah, what's that they say about high expectations?

i'm sure at very worst it'll be acceptable

as long as i like it better that 2 or 3 i'll be happy

for sure

103 days to go lol

@PeterVandivier I don't think there is a specific name for that.

It's a prefix to distinguish between strings and bit-strings.

From postgresql.org/docs/8.3/sql-syntax-lexical.html

> There are three kinds of implicitly-typed constants in PostgreSQL: strings, bit strings, and numbers. ...

that's actually super helpful. bit-string is useful as a keyword for search on the problem

lol, yea. just knowing that keyphrase gave me the solution i needed on the first hit of the next search :p

ty!

fwiw - i just needed to cast with ::bit(n) rather than the leading-"b" notation

what were you trying to do?

i'm creating a bitmap of column-level differences between table_from_backups and table_in_production. it's wide and not very human readable but there's not a lot of diversity in difference patterns, so i'm converting it to integer so people can more easily ID difference types 411, 145, and 161 when they see them repeated where they might glaze over reading 110011011, 010010001, and 010100001

it's actually something i've done before when running benchmarks with a lot of variables. you create a self-describing bitmap for every test profile then when you're down to just a few test profiles left to compare, you've got friendly numbers to refer to that tie back to when you're reading docs from the start of testing

nice

from my wife just now 🤣

@PeterVandivier You missed to anonymize one name at top of the second screen

nope, that's my wife ;p

it's her W, no need to hide

@PeterVandivier fine (I guessed it...) 👍

@PeterVandivier reading comprehension is hard

@PeterVandivier trolling the trollers? ;)

Lol is that even trolling?

maybe I read it wrong. Is that two conversations or one?

oh, looks like one, after the 3rd reading (I blame Friday ;)

Regarding matrix resurrections --- at what point will people realize they're just making the same movies over and over again

I mean I sort of put up with it with star wars, but come on now

Idk, ask the Architect 😜

heh

that would make more sense if we didn't remember the earlier iterations

perhaps there will be a courtesy memory-wipe at the cinema entrance

bbc.com/news/…

I wonder if StackExchange will respect my right, as a Texan, not to get banned because I wish my name to be Israel is an Apartheid State.

dunno --- is SE a social media site governed by the laws of TX?

@PaulWhite I'm watching all three again, in UHD just to be sure.

@HannahVernon I did that a few years ago. They stand up really well I think.

I don't know if they'll benefit from 4K or not.

Sometimes the extra detail exposes flaws one would rather not know about.

I kinda hoped they'd do something a bit more ambitious (and risky) for IV

SET risky != profitable;