The Heap™ – Consultancy ©®

« first day (4947 days earlier) ← previous day next day → last day (139 days later) »

Paul White

00:48

Hannah Vernon

01:39

@Criggie thanks! It's bluetooth so I tested it using my Cambridge Audio headphones. Once I get a good spot to put it, I'll hook it up to my Denon.

@PaulWhite that's awesome

4 hours later…

Vérace

05:55

A chairde - Morning all!

Wordle 1,128 3/6*

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

I was blessed!

@HannahVernon I've held onto a couple of albums - classics - another one is Talking Heads - Stop Making Sense - another for the top 10 list!

I'm thinking of framing them and hanging them on the wall as a reminder of my "Rebel Without a ~~Cause~~ Clue" days! :-)

Paul White

Wordle 1,128 4/6*

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

1 hour later…

Criggie

07:21

I always thought wireless was a bit rubbish, for mice, keyboards, etc.
But its kinda nice for audio and freedom of movement.
Audio lag is a killer, and a bunch of people always have problems in big meetings (like, 75 people on Friday's Crowdstrike call...) but for plain music playback it is quite good.
I've picked up an old Plantronics Bluetooth2 headset, whihc is garbage for speaking but playback is fine.

5 hours later…

Hannah Vernon

11:53

Wordle 1,128 3/6*

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

@Vérace David Byrne is amazing.

@Vérace chat markdown strikes again, I see

Zikato

@Vérace Another idea for a poster meme: Rebel without where clause

John K. N.

12:10

Wordle 1,128 4/6*

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

@Vérace I have never tried Trouble in Trinidad (900'000 Scoville). I had the Voodoo Reaper (1,2 Mio Scoville) once , but that was a bit too much and I'm currently using Naga Knockdown (600'000 Scoville) which is pleasant. I'll grab a bottle of Trouble in Trinidad and let you know.

Hannah Vernon

13:11

@Zikato do.it.

also, from the Availability Groups Are Hard front, ALTER AUTHORIZATION ON DATABASE::[xyz]; doesn't work for databases on a distributed secondary.

and of course, changing the owner on the primary doesn't propagate to the secondaries.

1 hour later…

Paul White

14:40

How is that different from the previous answer from six years ago? — mustaccio yesterday

Reading comprehension strikes again

Paul White

14:56

CREATE TABLE dbo.[🐬]([🐬] integer NULL);

Hannah Vernon

15:15

you missed an opportunity to show the max possible length of a unicode sysname there

Paul White

It's not very thrilling, it's just nvarchar(516) as stated. Doesn't matter what fancy fish you use.

But ok

SELECT DATALENGTH(QUOTENAME(REPLICATE(N']', 128), N'['));

Hannah Vernon

personally, I like this one:

CREATE SCHEMA [];
GO
CREATE TABLE [].[]
(
    [🐬] int NOT NULL

there are a lot more characters there than there appears to be

Paul White

chat rendering strikes

Hannah Vernon

unicode is fun

PRINT N'''[' + REPLICATE(NCHAR(0x0099),112) + N'🐬' + REPLICATE(NCHAR(0x200B),15) + N']''';

LOL chat markdown you suck

I really hope I get to use start of guarded area in a table name one time

hmmm that might be fun in an answer one day

Paul White

SELECT DATALENGTH(QUOTENAME(REPLICATE(NCHAR(0x0099),112) + N'🐬' + REPLICATE(NCHAR(0x200B),14)));

Only returns 260

Interesting as it is otherwise

Hannah Vernon

15:52

d'oh back to the drawing board

Paul White

16:15

I wouldn't worry about it. Even the documentation is wrong about this stuff

> Both regular and delimited identifiers must contain from 1 through 128 characters.

(from docs.microsoft.com/en-us/sql/relational-databases/databases/…)

It's max(128 chars, 256 bytes) in reality, so 64 four-byte characters at one extreme

Hannah Vernon

16:45

Why does PRINT CONVERT(binary(4), UNICODE(N'🐬'), 0); return 0x0000D83D but PRINT NCHAR(0xD83D); not display the dolphin emoji?

calc.exe shows the same 0xD83D value when converting the decimal value returned by UNICODE() (55357) so I know it's not anything dumb in the CONVERT(...) doing it

even when I specify a collation like Latin1_General_100_BIN2_UTF8 it doesn't work.

PRINT NCHAR((UNICODE(N'🐬' COLLATE Latin1_General_100_BIN2_UTF8)));

returns:

�

Paul White

17:16

@HannahVernon You're not in a SC collation context

PRINT CONVERT(binary(4), UNICODE(N'🐬' COLLATE Latin1_General_100_CI_AS_SC), 0);

Try that

Or Latin1_General_100_CI_AS_SC_UTF8 if you prefer

Hannah Vernon

I did try a bunch of supplementary character collations as well, but this still doesn't return a dolphin, it returns NULL:

 SELECT NCHAR(UNICODE(N'🐬' COLLATE Latin1_General_100_CI_AS_SC));

Jun 5 at 22:22, by Paul White

Jun 22, 2022 at 14:33, by Paul White

fundamentally though, strings were a mistake

presumably that covers it

Paul White

@HannahVernon Try that in a database with SC collation

Hannah Vernon

I was kind of wondering if that was the problem

Paul White

> When the collation of the database does not contain the Supplementary Character (SC) flag, this is a positive integer from 0 through 65535 (0 through 0xFFFF). If a value outside this range is specified, NULL is returned. For more information about supplementary characters, see Collation and Unicode Support.

Hannah Vernon

I'm doing it in tempdb with the normal North American collation

Paul White

17:26

docs.microsoft.com/en-us/sql/t-sql/functions/…

Hannah Vernon

Jul 10 at 10:43, by Zikato

Apr 9, 2023 at 18:21, by Paul White

Reading comprehension being what it is these days

we should change the room description to "everything old is new again"

Paul White

If you need further assistance with the documentation, please consult @JoshDarnell