What's New for the Microsoft Data Platform

Question

What's New for the Microsoft Data Platform

Steve Jones - SSC Editor

SSC Guru

Points: 736172
More actions
November 6, 2024 at 12:00 am

#4472450

Comments posted to this topic are about the item What's New for the Microsoft Data Platform

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ken McKelvey SSCoach Points: 18842 More actions · Answer 1

I suspect a lot of AI for analytics especially for security and BI on Azure.

I do not expect much of it to reach on-premises SQL Server anytime soon as it would not surprise me if Microsoft announced it was moving to five year releases. ie The next version will be SQL2027.

Jeff Moden SSC Guru Points: 1004321 More actions · Answer 2

TBH... I'm deathly afraid of any changes or "improvements" that MS makes any more. The huge slowdown that started with the new cardinality estimator in 2016 was the first big sign of trouble. Fortunately, shifting back to the legacy CE fixed all our stuff.

Then, 2019 came out with a huge number of performance issues and, apparently, changing back to the Legacy CE and even flipping the Compatability Level back to 2016/2017 didn't help folks.

2022 was released with those same problems and other things to help slow the system down even a bit more.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 3

Ken McKelvey wrote:

I suspect a lot of AI for analytics especially for security and BI on Azure.
I do not expect much of it to reach on-premises SQL Server anytime soon as it would not surprise me if Microsoft announced it was moving to five year releases. ie The next version will be SQL2027.

Some AI, embeddings in Azure SQL DB, but nothing about on-premises.