« first day (4322 days earlier)      last day (844 days later) » 
00:00 - 17:0017:00 - 23:00

00:00
You'd think there'd be Top Men working on it
The quality of the Top Men has been declining lately.
Like few thousand years or so
The quantity though
I'm sure that sort of talk wouldn't be allowed under the standard political structure
Social Quietitude Language, or SQL for short
Sounds buggy
You can guess where "No SQL" leads us
00:39
@mustaccio Not Only Social Quietitude Language? 🙃
01:34
@mustaccio life was a lot better in dactylic hexameter
01:45
Life were a whole lot better if not for the standards committees of course
How's that for hexametre
somewhat dactylic
metric system catching on
Dactylic hexameter (also known as heroic hexameter and the meter of epic) is a form of meter or rhythmic scheme frequently used in Ancient Greek and Latin poetry. The scheme of the hexameter is usually as follows (writing – for a long syllable, u for a short, and u u for a position that may be a long or two shorts): | – u u | – u u | – u u | – u u | – u u | – –Here, "|" (pipe symbol) marks the beginning of a foot in the line. Thus there are six feet, each of which is either a dactyl (– u u) or a spondee (– –). The first four feet can either be dactyls, spondees, or a mix. The fifth foot can also...
2 epic 4 u
somebody czech my grammer
02:14
Caes the day
 
5 hours later…
06:59
@SeanGallardy contrary to popular belief, it is spelled lakh and not lahk
Morning
Morning
Similar discussion: I recently had to remove a sentence from my PowerPoint presentation regarding Flex Work, as the opposing party said: "Your common-sense is not my common-sense." (re: politics)
I wanted to start arguing that there must be a common basis for common-sense, and suddenly realised that I would lose that battle, as I would be stepping into a fight with somebody that had a different view of what common-sense meant to them.
Oct 6 at 13:18, by Zikato
Never play chess with a pigeon.
The pigeon just knocks all the pieces over.
Then shits all over the board.
Then struts around like it won
@HannahVernon I always use multiple tabs. But why would that break things? Or in your code?
Good morning @ypercubeᵀᴹ
08:03
morning
 
3 hours later…
10:51
@JohnK.N. I find your lakh of faith disturbing
@ErikDarling While I'm no fan of NYC, the skyline and the sheer number of buildings coupled with the setting or rising sun (and generally fog) is quite a wonderous sight.
When I was flying up and back every week doing work for someone just across the street from the Brooklyn bridge, some may call it the finest avenue, I was constantly in love with the sunrise and sunset from the top floors of the hotel.
user image
2
11:29
@SeanGallardy just about anyone can find something to like about it. I suppose that’s part of the draw.
11:43
@JohnK.N. yah tabs instead of spaces
@JohnK.N. yah I get that at work too. It's because its a brand new domain. There is no advertising or anything aside from a 6 line <script> in there.
84
Q: Tabs versus spaces—what is the proper indentation character for everything, in every situation, ever?

apadernoThe coding standards for the code hosted in drupal.org suggest to use two spaces to indent the code; other sites suggest to use tabs to indent the code. What is the proper indentation character for everything, and in every situation? Please explain the answer you give.

i use standard four space indents so i tend to type tabs to save time and then replace them with spaces later
i hate that guy.
Which one?
@ErikDarling you know most editors can do that for you, right?
12:43
@Charlieface the cartoonist
@ypercubeᵀᴹ i work solely in ssms
does anyone in here use redgate schema compare?
if so, is there an easy way to compare a table definition in one database to the same table in many databases?
probably PowerShell
i'm choosing to ignore obvious trolling
it has CLI you specify connections, options and output file then loop for each database
@ErikDarling What's he done wrong?
12:58
@Charlieface wrote a bunch of terrible cartoons
13:13
33 mins ago, by Erik Darling
i use standard four space indents so i tend to type tabs to save time and then replace them with spaces later
Wait. What? You use SSMS, type tabs and then replace them with spaces later?!
300%+ efficiency
@PaulWhite yeah i use regex find/replace for \t
@J.D. your answer on the cdc thing leaves out that they'll lose all prior CDC data using that process
My brain is currently draining out of my ears
@SeanGallardy 😂
@PaulWhite what seems to be the problem my dear friend paul
13:18
What possible advantage is there to typing tabs in SSMS then replacing them with regex find replace later? Why not let SSMS convert the tabs to spaces as you type them?
@ErikDarling I used to.
i have that checked, but it seems inconsistent
like when i add a new line, or indent a block
i always check scripts for \t anyway to replace so when i need to type four spaces i hit the tab key
Oh well that makes more sense then. I thought you meant you type tabs deliberately then replace them all. Perhaps SQLPrompt inserts some tabs that SSMS doesn't 'see' to replace immediately? Maybe some tabs in snippets?
not sure about sql prompt there. i don't think i've ever used snippets.
13:22
@ErikDarling closed as can't repro
How could anyone live without "ssf" expanding to SELECT * FROM
Or "scf" expanding to SELECT COUNT_BIG(*) FROM
might as well be hunting and gathering
@PeterVandivier you should watch me type in ssms while screaming at it about random tabs being inserted
13:25
Might be an Apple thing
do you have View Whitespace toggled on? i'm morbidly curious to know what's happening
it's especially pronounced when i'm trying to delete spaces to align something, get within one space of correctness, and then have the text jump back a full tab stop
computer might be haunted
@ErikDarling mm fair, though I suppose the OP is already aware of that given it's really their solution lol. But will update my answer when I get a chance.
13:27
Btw the blog article re: the StackExchange yesterday: brentozar.com/archive/2022/11/…
@PeterVandivier In SSMS?
yea
24
Q: Is there a way to view whitespace in SQL Server Management Studio 2016?

DNKROZIt doesn't look to me like there's any menu option which enables whitespace to be viewed in the text editor. There's a similar question here, however this is referring to SSMS Express 2005 . An answer to this question shows how whitespace viewing can be enabled by editing registry values. Howeve...

Edit > Advanced > View White Space
@PeterVandivier Oh! Very good! I had completely forgotten about that option.
@ErikDarling SQL Prompt styles formatting. It might format as you type
13:32
maybe
fascistic admins today :D
every day
@PaulWhite IIRC that's one of the settings you can't import with a .vssettings file, but maybe i just don't know the special registry key to do it
Shame it's far too annoying to leave on permanently
13:50
i've been doing some work in managed instance lately and even basic interactions with ssms are painful
intellisense and RedGate background queries or actual work-work too?
work-work
intellisense/sql prompt give up and throw an error immediately
14:08
Have you tried Azure Data Studio
LOL
14:19
i hope you kept your receipt for those empathy lessons
heh heh heh
@PaulWhite 4u
@PeterVandivier Yes, it would probably be better with your colour scheme
maybe i've just been desensitized by all this yaml
@ErikDarling i concur - i'm forever replacing \t with four spaces. I also do a search for (\t| )+\r\n and replace it with \r\n to remove errant tabs and spaces at the end of each line.
14:36
I wonder what you both have set differently. I checked my 14 open SSMS tabs and found no stray tab characters.
@PeterVandivier OMG I never knew that existed. Awesome!
@PaulWhite you're a silo
@HannahVernon A ... silo?
@Zikato 's theory of a rouge RedGate setting conflict makes sense to me
a rogue one, even
RougeGate
14:38
every piece of code I look at was written by a monkey in front of a typewriter
Oh I see.
That's not an expression I'm familiar with, but it makes sense now.
I could have said "you're in a silo" I suppose
Still would've passed me by, I'm afraid. Just not a common phrase in my world.
I see. I'm sorry.
Also, view white space works in VS and I'm now eternally grateful.
2
@HannahVernon Nothing to be sorry about. There's no way for you to know what I'm familiar with.
14:42
@msg should be 2048 if you're using it w/raiserror
mind reader
thanks for the tip
it was easier for me to write a loop with sys.dm_exec_describe_first_result_set to get schema differences across all the databases on a server than it was to use schema compare
wild nights
what, no cursor
14:56
Yes, gibberish is my main language
@ErikDarling No one should have to use MI
Are you saying it should be Mission Impossible
malaise inducing
Well then again, possibly not.
The infinite monkey theorem states that a monkey hitting keys at random on a typewriter keyboard for an infinite amount of time will almost surely type any given text, such as the complete works of William Shakespeare. In fact, the monkey would almost surely type every possible finite text an infinite number of times. However, the probability that monkeys filling the entire observable universe would type a single complete work, such as Shakespeare's Hamlet, is so tiny that the chance of it occurring during a period of time hundreds of thousands of orders of magnitude longer than the age of the...
15:14
user image
5
@HannahVernon Just replace \s+$ with nothing
@Zikato too late to change now, it's muscle memory
also regex is not meant to be easy
regex sure does come up a lot for a database chat
There is a regex tag after all. No KQL though
might start deleting regex chat messages
and no, I do not need help locating them tyvm
15:24
If you did need help, someone might come to your rescue.
top query has a loop join hint, bottom query has none
@JoshDarnell borderline, v borderline
@PaulWhite 😘
@ErikDarling That's...dramatic.
@JoshDarnell i thought for sure adding the loop join hint would pop up a missing index request or add an index spool
turns out it just worked
seems like an incomplete plan
15:35
@PaulWhite lol dammit
cute there's a warning on the fast one
@ErikDarling How do you know there isn't regex obscured behind the search function?
regex inception
@JoshDarnell They need that hero at my former FinTech job, the regex for email parsing was insane.
finger poised over delete button
you're all so v funny (except Sean)
@ErikDarling will that be appearing in a blog post or something?
Not like you to leave the chat hanging like that
15:41
@bbaird the last time i saw the search feature it was just a like %% search
@PaulWhite no, it's a client query
Paul called me funny!
@SeanGallardy But maybe like @Vérace funny and not funny funny?
🔥🔥🔥
Ooof, well I already put a gold star on my calendar for today so I hope not.
notice the difference between calling someone funny and laughing at something they said
15:43
also worth checking to see if starred messages were subsequently edited
@PaulWhite :GASP:
Lots of lovely mods today, must be a full moon
@bbaird brutal ping
Jokers are out today
Nov 1 at 13:51, by bbaird
My personality has run out of politeness ops
fair enough
15:47
@SeanGallardy looks arent everything
@ErikDarling well I hope you realise hints are only for experienced DBAs
@swasheck That's what ugly people say... :P
maybe someday i'll meet one
you do live in a very big city
chances higher than most
15:51
still not v likely
I guess it's technically the weekend for Paul, he might already be drinking.
what's that got to do with the weekend
🤔😂🤣
any day you drink is a weekend
15:55
I was gifted something called "white port"
Crazy sweet
Did it come from Portugal at all
Yes, the person recently returned from portugal
I've never had it, so it's sweet?
I like type-II diabetes sweetness
REALLY SWEET
Like, take the sweetest thing you can think of, and double it
dang
Ice wine is probably the sweetest I've had
Then you're not even halfway to appreciating how sweet it will be
15:57
hahahahahahah
Makes dessert wine seem like a sour chew
this sounds terrible
but at least it has alcohol in it
I could not drink it
"Most producers mature their wines in neutral vessels of stainless steel or concrete." Mmmm... can really taste the quicklime.
@PaulWhite wow. I'm a bit afraid now.
15:59
Well of course you are. You work for MSFT
@bbaird It's very aggregate forward on the palate
2
"The sweetest style of white Port is known as Lagrima, meaning “tears.” These wines are highly viscous, so when swirled in the glass they readily show “tears” or “legs.” Lagrima-style white Port is rarely exported, intended primarily for the domestic market."
@SeanGallardy I liked pallet better
More industrial, thought it was part of the gag
Yeah I wanted that as part of it and then I thought maybe people wouldn't get it and call me out on wrong spelling
16:01
V palletable
@SeanGallardy You underestimate the sophistication of your audience here
Working in support has ruined you
It really has
now I work on cloud, so possibly even worse?
> Space is big.
Really big. You just won't believe how vastly, hugely, mind-boggling big it is. I mean, you may think it's a long way down the road to the chemist, but that's just peanuts to space. Listen; when you're thinking big, think bigger than the biggest thing ever and then some. Much bigger than that in fact, really amazingly immense, a totally stunning size, real 'wow, that's big', time. It's just so big that by comparison, bigness itself looks really titchy. Gigantic multiplied by colossal multiplied by staggeringly huge is the sort of concept we're trying to get across here.
Same vibe for white port vs sweetness
Image upload isn't working
I took a picture of it
What's the name?
Thaumatin
Oporto Blanco del Generalísimo Azúcar?
It's not Erik level
burmester white porto
@Josh uses that in his tea
Says it will be an "unforgettable" experience either way
16:08
> Thaumatin is an intensely sweet-tasting protein (on a molar basis about 100,000 times as sweet as sucrose) found in the fruit of the West African plant Thaumatococcus daniellii:
I guess I could open it and try it now
@SeanGallardy DO ITTTTTTTTTTTTT
That's definitely over 9000
oh boy, ok, :deep breath:
My mind is blown by the fact the sweetest thing in the world is Thaumatococcus daniellii
and that's the last message Sean ever posted
RIP Top Man
Very alcoholy
not that sweet, actually
not as sweet as that ice wine at all
16:11
ruined it
but tastes like 40% alcohol
I could probably clean scalpels with it
@PaulWhite I can't help but see Darneli there at the end.
Fascinating
@JoshDarnell Right!
WHY DO YOU HAVE SCALPELS
I do a lot of self surgery
16:13
of course
It's going to cost like 3k to go to the ER
perfectly normal
and all they are going to do is cut me open
I can do that at home
makes sense
exactly
cost and time savings
$7
I also have super glue and a staple gun to close the cuts
16:16
naturally
Again, that's what the hospital does
what's the difference if I do it
none at all
open, debride, clean, close
do you also cut your hair with a woodchipper
I wish I had a woodchipper
expensive
16:18
what wood a would chipper chip
but sometimes you get slivers from the gym, or step on a nail, etc., and just need to make some small cuts and cleanings.
happens all the time
maybe I'm prone to getting hurt
must be all the scalpels around the place
I did go to the hospital when I had sepsis
when I broke my leg in a rugby match
16:20
😶
That was 2020 I think
Spent a week in the hospital :D
or when you broke your arm trying to lift that pink dumbbell
snapped like spaghetti
dark times that was
yeah, both hurt and made me hungry
I'm surprised you didn't amputate
Like a reasonable person would
I waited 3 weeks
16:23
yep gotta make it worth the trip
exactly!
no point turning up with non-life-threatening sepsis
waste of everyone's time, frankly
In all seriousness, I was pretty ready to buy a home sutures kit during the middle of the pandemic after my wife cut her toe almost to the bone somehow.
do Amazon not do a home sepsis cure kit
SEE
I'm not the only person
16:24
45 minutes of pressure fixed it, but it was dicey there for a bit
@SeanGallardy being supported by bbaird is not the huge win you might've been expecting
HAHAHAHAA
He seems v. reasonable
I rest my case
@SeanGallardy Can you forward this to my wife?
16:25
Absolutely
Seems is the key word there
Maybe it's because I grew up on the middle of nowhere
and that's just what we did
Maybe it's because you're clinically insane
Who would know
My mother had me tested
only test I ever failed
@PaulWhite You can get a kit from Amazon to check for that.
16:27
snigger
I'd be willing to bet Sean is one of the most tested people on the planet iykwim
I'll make meatballs wrapped in bacon in your honor tonight
I hope that doesn't involve any self-surgery
I as well!
Imagine you cook all meals with a flamethrower for speed & efficiency
Bacon meatballs a la napalm
Air Fryer FTW
love my air fryer
16:29
Same thing really
Doubles as a hair dryer no doubt
luckily I have short hair, so it doesn't get tangled
The air fryer is amazing.
Almost as versatile as a hot plate
with less of the meth smell
I knew there'd be meth involved
All starting to make sense now
when you feel the ants crawling on your skin, you have to cut them out
duh
meth 101
16:32
super glue & staples
That's my nickname
just like the professionals
I sure hope no one thinks to change your display name to that
You can't buy the human-safe skin glue on Amazon, but the stuff for horses is basically the same and you can get that
I hear repurposing horse medicine is all the rage
3
Not that I would ever zinc so low
I had a boss that would take fish penecillin instead of actually being responsible
16:35
Was he a fish?
@bbaird I just use regular
Freedom was a mistake
Maybe he drank like one?
Yes and no
I have this image of Sean trimming his nails with an angle grinder
16:39
Is there another way?
Yes, if there's a better way I'm all ears
Sep 20 at 12:14, by Erik Darling
chat is CLOSED
@PaulWhite he can't possibly be. he never goes to the clinic.
00:00 - 17:0017:00 - 23:00

« first day (4322 days earlier)      last day (844 days later) »