The Heap™ – Consultancy ©®

Q: Planned SEDE maintenance scheduled for Sept 22, 2021 at 01:00-04:00 UTC (Sept 21 9:00 pm-midnight EDT)

12:41 AM

@bbaird that's wonderful.

Good to see so much backyard cricket and Bird of the Year

1 hour later…

Evan Carroll

1:47 AM

this network: many many idiots.

Under what definition is the answer to a question "spam"

if you cite your answer, it's "spam" now...

Not sure what the level is, but certainly if you have 200k+ on the network you're not here to spam it.

1 hour later…

Vérace

3:01 AM

@billinkc So, KFC is the new LSD? Like it! :-)

2 hours later…

John K. N.

5:22 AM

Morning

1 hour later…

McNets

6:50 AM

Morning

2 hours later…

ypercubeᵀᴹ

9:06 AM

Just disguise yourself with a fake mustache and glasses and hope for the best. — Michael McFarlane 2 days ago

best comment I read this week ;)

Vérace

9:17 AM

A chairde - Morning all!

Vérace

9:36 AM

Last evening I was at a lecture where the guy (Oracle ACE Director) said that MySQL's licence meant that you (strictly speaking) had to pay for deploying MySQL in production! I told him that this didn't chime with my interpretation of MySQL's dual licencing.

You paid for redistributing closed source apps which embedded MySQL in some way, but that simple deployment (in any context) did not require payment. He said that he was talking to some of the development team and that is what they told him.

I'm not sure that I believe him (about the dev team), but anyway, the crux of my question here this morning is: Does simply deploying MySQL require a payment to Oracle/MySQL? He said that Facebook paid 100's of millions of dollars to Oracle every year - and I can well believe that FB does pay lots of money to Oracle, but maybe that's for the Oracle server for, say, their accounting and whatnot, but not for their MySQL servers? Apologies for the length, but I just want to be very clear!

He also said that MySQL/Oracle didn't bother suing people because it was too much trouble...

Again, I find this hard to believe...

ypercubeᵀᴹ

10:14 AM

@Vérace me too

2 hours later…

John K. N.

11:48 AM

@Vérace I would contradict that statement. Oracle does sue people/companies if the features/products you are using are not covered by a [current] license [level].

ypercubeᵀᴹ

I agree 100%. They sue even if the product is covered by licence.

They sue even if you don't use the product

theregister.com/2019/10/04/oracle_virtualbox_merula

2 hours later…

John K. N.

1:48 PM

Note: The originally planned second window on Sept 24 is cancelled as the upgrade was a success within the first window. Note: 2021-09-21 0225Z - Maintenance has ended. Please leave a comment if there are any problems. Due to a planned network upgrade, data.stackexchange.com (a.k.a. SEDE or the S...

1 hour later…

3:15 PM

@PaulWhite I wasn't sure Bird of the Year (with rank-choice voting) wasn't a bit, but it seemed so earnest I just went with it.

@bbaird ?

@PaulWhite From the concert where the performers were discussing their choice for bird of the year.

We have no such thing in the US

@bbaird Yes I couldn't parse your message. Did you miss a word out?

Maybe "bit" (joke) was unclear?

I wasn't sure if they were kidding or not about bird voting.

@bbaird Ah yes. That doesn't translate.

Oct 12 '17 at 18:52, by Paul White

I voted for NZ Bird of the Year

It's a real thing.

I never pick the winner.

3:20 PM

Hopefully things aren't rocked by scandal this year? npr.org/transcripts/934749679

Q: Pricing of databases in Azure

It is v prestigous. Some fraudulent votes are invaidated most years. V sad really.

Lamak

@bbaird lol

McNets

sh*t I must shrink one database.

Cade Roux

Good morning to everyone except parameter sniffing

Cade Roux

3:43 PM

Why would a proc just go and go (increasing IO and CPU in sp_whoisactive) when all the exact same statements run fine by themselves in SSMS in a few seconds, but the proc never completes?

EXECing the proc in SSMS WITH RECOMPILE. I thought it would be parameter sniffing, but WITH RECOMPILE should rule that out, right? There are other simple logging and auditing procs being called in the proc, but the statement that is apparently hanging is just the primary INSERT (717 rows, whole thing runs in about a second when all the steps are run outside the proc)

I thought it had to be parameter sniffing because the only parameter is a date and it normally runs in a loop, and when it got to the first date with rows, that's where it hung, so I figured it must be a plan issue. Are there times where WITH RECOMPILE doesn't really recompile?

McNets

I am a little bit confused about pricing for Data in Azure. I found on one MS Blog that 50GB has a price of $125. Missing part for me is, if I have needs only for a database in the cloud: Do I pay only the amount of $125? Or I have to pay separately for RAM, storage, processors and others parts ...

azure-sql-database

^^^^ Why this question has 4 up-votes?

billinkc

4:25 PM

Yeah, first client project had me busy. Discovered lots of great things like serverless/just-in-time computing is great, as long as you don't have processes that prevent the scale down/off process

By default, a new databricks cluster will poweroff after 2 hours of inactivity. Someone changed that to 0 hours and it had been running since May 30th. Oopsadoodle

And then, SSMS I reckon, had kept 5 serverless databases up for 2 months.

I think the takeaway for me is to look at their azure spend and make sure it makes sense before I actually do anything

First client I had worked with was using pandas and I got mediocre with it and the next one is also using dataframes but oh, they use pyspark and the syntax is entirely different between those two implementations. On the upside, I will eventually have enough fodder for conference/ug talks

Best bird of every year - Morepork/Ruru twitter.com/sharonwatkinson/status/1436057408971821067

1 hour later…

Cade Roux

5:34 PM

FWIW

Q: Stored procedure running indefinitely, same statements executed in batch completes in a second; WITH RECOMPILE has no effect

Why would a proc just run without terminating (increasing IO and CPU in sp_whoisactive, nothing blocking) when all the exact same statements run fine by themselves in SSMS in a few seconds, but the proc never completes? I am EXECing the proc in SSMS WITH RECOMPILE. The proc's logic has changed a...

sql-server parameter-sniffing

1 hour later…

6:50 PM

Getting spammed with more dolphinDB nonsense it seems

7:28 PM

It's interesting to see how that works on Stack Overflow: stackoverflow.com/questions/tagged/…

there are a handful of users, some of them were created "5 months ago", some "29 days ago". Mostly zero upvotes and zero answers, though some of them answer each other's questions. Looks suspicious af.

I wouldn't be surprised if they all come from the same IP (or range).

They don't upvote each other though, so what are they after?

Trying to hype up (or put down) the product?

Like, making it appear people actually use it so when someone is testing and they're like: "how do I do this dumb task" it looks like there is an actual user community.

I'd expect higher quality questions and answers in that case. What's there looks like junk

Maybe just SEO by amateurs?

7:45 PM

Another theory is these are actual dolphins evolving. They must have hacked into the Microsoft's underwater data centre and found a topic on the internet that has relevance.

theonion.com/dolphins-evolve-opposable-thumbs-1819565718

One doesn't need opposable thumbs to post crap on SE.

v true, i barely use them now

3 hours later…