@jcolebrand I still was the only vtc and wanted a second opinion

My personal opinion. Just delete it

Now that it's closed I can and have vtd

Indeed.

Good morning

M'

Murning

Review queues are big-ish if anyone's not on strike :)

Fair few close votes

Morning

Morning all. I think I'm missing something. All the links & searches I do for SQL Server 2019 take me to evaluation downloads. The installer is SQL2019-SSEI-Eval.exe. I was expecting a GA or RTM one. I've tried different browsers and private tabs and whatnot & I really don't think I'm stuck in a little pocket of cached links. Where have I gone wrong? (Specifically on this download issue; let's leave my broader life choices 'til another time.)

This page seems to offer various options (found using sql server 2019 download in DDG)

@MichaelGreen You're starting from microsoft.com/en-us/sql-server/sql-server-downloads?

simultaneous

clicking Developer Edition there gives me SQL2019-SSEI-Dev.exe

@PaulWhite Weird, considering one of us was doing it in the future

I wonder what makes Michael think Eval isn't RTM

Do you just plonk a key in and they become "real" ?

Non-evaluation? Yes.

They're implementing a workflow system here.

Unfortunately Dilbert doesn't seem to do one-boxing.

Wooo! Thanks guys. My searches were landing on that page but the big "download free trial" box at the top captured my attention. Never thought to scroll through the rest of the page. Derp.

@PaulWhite Because it's called "eval" and has the same download experience, look-and-feel and naming as the CTP editions I pulled months back, before it was announced as GA. And there's no indication (that I could see) that following the eval path would install the post Nov-5 functionality.

No worries

@Philᵀᴹ Done my bit and them some.

dba.stackexchange.com/review/suggested-edits/143679

> Comment: Content not write properly.

@George.Palacios Good to see irony's alive and well.

Yuck that should have been rejected and edited

Never going to learn to edit better otherwise

Love that I can just ping the product manager for SQL Developer on Twitter & he'll hop on here and answer :)

Looks like there won't be any hats this year

@PaulWhite this is an outrage

#hatgate2019

hats are overrated anyway.

Typo of the day: incestigate

Love thy brother?

@Forrest Started one of your pinots last night. Super popular.

Good to know!

It's like really really really nice

:D

thegoodwine.co.nz/product/the-doctors-pinot-noir

> Made by John & Brigid Forrest

coincidence?!

I had to come up with some criteria for picking wines

@PaulWhite it sounds there is also a 'how much' question along the way

just one glass

too good to glug

Opening a bottle of wine is dangerous. Don't want it to spoil.... Just 1 more topup ....

This one takes some willpower though for sure.

Wait what? No more hats?

@PaulWhite That's in our local!

I will pick up a bottle at the weekend

I hope it travels well

The network seems to be offline

@George.Palacios Local wine store?

It's back

Gives me time to learn XML

Yuck

Evan? I don't know their personal pronoun

startrekwines.com <--- love the Zinfandel bottle

Such a nice shape

nvm

answered my own question

@PaulWhite Local upmarket grocery store

noice

@George.Palacios I had a similar experience once. My parents have a lifestyle block next to a winery called Langdales (no longer a winery as the vines were destroyed in the 2006 grass fire). One day I saw some wine from Langdales in a grog shop in Reigate.

@Johnakahot2use my third person singular pronoun is "supreme leader" and the possessive form is "zog". any violation of this goes beyond my gender identity (i am a gender fluid god) but also insults my authority and my religion. This is another reason why I'm glad the CoC has sent a firm blow to Christandom, and helped established the real theocracy that we all deserve.

In the world I will build, we will all live in a post-binary communist utopia. I will establish PostgreSQL as the supreme database of the land, and banish SQL Server to the dustbin of history.

Rather random error.

(It had the job_id of a previously deleted job, in case you were wondering)

@CadeRoux Was the deleted job one that originated from an MSX server?

Lol, no

It was the same job that was being recreated

DECLARE @jobId uniqueidentifier = NULL
SELECT @jobId = job_id FROM msdb.dbo.sysjobs WHERE (name = N'JobName')
IF (@jobId IS NOT NULL)
BEGIN
	EXEC msdb.dbo.sp_delete_job @job_id = @jobId, @delete_unused_schedule = 1;
	SET @jobId = NULL
END
EXEC @ReturnCode =  [msdb].dbo.sp_add_job @job_name=N'JobName',
		@enabled=1,
		@notify_level_eventlog=0,
		@notify_level_email=0,
		@notify_level_netsend=0,
		@notify_level_page=0,
		@delete_level=0,
		@description=N'No description available.',
		@category_name=N'[Uncategorized (Local)]',

If you leave off that SET @JobId = NULL, it will fail the second time through.

Or the first time through if the job previously existed, obviously

Curious oddity

And useful to know too, so thanks for sharing @Cade!

Yes, moving variables around is not always harmless. I had pulled the variable up because this was becoming a single batch in a transaction instead of two batches separated by a GO

Lol, is that akin to a Mandela-effect. It was Berenstein!

@mustaccio You have an answer inside your comment, so you'll need to escape it by posting it as an answer.

I VTC that question, so, no. Appreciate the pun though.

I voted too, the immediate problem is a typo (a space between the : and the =)