El Reg talks to Azure Data veep as Microsoft flicks the switch on Azure Arc for SQL Managed Instances

Microsoft’s Corporate Vice President for Azure Data, Rohan Kumar, told The Reg the org had no “thought process” around changing current long-term support terms for SQL Server. We were talking to the corporate veep as Microsoft slapped the Azure Arc sticker onto its veteran SQL product, with Kumar discussing both the update and …

[AMBxx]

Postgres

Maybe MS could contribute. Starter for 10 - how about allowing changes to a table without having to drop every view that queries the table.

[Doctor Syntax]

"there is no thought process that we have around changing…"

Not so much weasel words as a whole nest of pine martens.

[Cloud, what..... Sorry... Um... - you just made that up.]

And Windows 10 is the last version we will release.

[Anonymous Coward]

"there is no thought process that we have around changing…

Just means, it will happen, we do not even have to think about it.

[Ken G]

We just roll the dice and see what comes up...

[Anonymous Coward]

"That was a key learning for us"

I'm quite a mild sort of person but I suddenly want to continuously punch someone in the face quite hard. English is a pretty flexible language and I personally encourage verbal widdling around the boundaries to see what pops out.

The sort of wanker who unthinkingly deploys a phrase like: "a very key learning" deserves to be hung by the smaller of their testicles until they say soz or perhaps scream for mercy. IDK. lol. etc.

[katrinab]

This Azure Cosmos thing. Does anyone actually use it?

It claims compatibility with MongoDB, which I use a lot.

But it also apparently doesn't support date fields?

Literally every single document I have on my Mongo server has a date field in it somewhere. The only exceptions are a few that have more than one date field.

Is there a use-case anywhere that doesn't require dates somewhere?

Yes you could store the dates as a string, but then you wouldn't be able to query documents with a particular date range. Or use an integer I suppose?

Or spin up a FreeBSD instance and do "pkg install monogodb50"

[Anonymous Coward]

It has partial MongoDB compatibility, but it's weird. It calls itself "multi-modal", in that you can talk MongoDB or SQL(ish) or DocumentDB or...another one, I forget. But you have to pick that interface up front and then you can't change it. Something weird about it.

I think its primary feature is "lockin".

[orly_andico]

CosmosDB with MongoDB API supports BSON data types which includes dates.

See "Data Types" - https://docs.microsoft.com/en-us/azure/cosmos-db/mongodb/feature-support-36

[IamAProton]

Wasn't 2019 supposed to be the last version on-prem?

I am pretty sure I've read it sometime around 3 years ago. Thinking about it since a couple of weeks since we are evaluating db options for a new project and I'm suggesting Postgre.

Does anybody else remember?

A virtual pint ---> to whoever is able to dig it up.