Microsoft's SQL Server 2022 is All About Azure (techcrunch.com) 32
Microsoft has released SQL Server 2022, the latest version of its database software, which originally launched more than 33 years ago. From a report: Microsoft describes this release as the "most Azure-enabled release of SQL Server yet" and with connections to Azure Synapse Link for enabling real-time analytics over the database, Azure Purview for data governance and disaster recovery with the help of Azure SQL Managed Instance, this release is, in many ways, the culmination of the cloud-connection groundwork the team started quite a few years ago. "From the very beginning, the vision [for SQL Server] really was about -- databases were very complex -- how do you make that extremely simple? And in many ways, I think that has been a key reason why it lasted for so long and how we've evolved it as well," Rohan Kumar, Microsoft's corporate VP for Azure Data, told me. "One of the big things that I think about with SQL Server 2022 is that we've made it completely cloud-connected to Azure."
He noted that while the migration of on-prem workloads is happening, Microsoft's customers are all moving at very different speeds and some, for a multitude of reasons, may never move to the cloud at all. That, he argues, is why the company always bet on a hybrid approach, but it is also why a lot of customers started asking about how they could get the value of being in the cloud without actually having to move all of their data to it. "That was really the key thesis of why we invested in making this into a cloud release," Kumar said. A good example here is the new disaster recovery function that allows users to replicate their data in SQL Managed Instance on Azure and use that as a backup for their main on-premises SQL Server, which should make it easy to fail over to that when the main server goes down.
He noted that while the migration of on-prem workloads is happening, Microsoft's customers are all moving at very different speeds and some, for a multitude of reasons, may never move to the cloud at all. That, he argues, is why the company always bet on a hybrid approach, but it is also why a lot of customers started asking about how they could get the value of being in the cloud without actually having to move all of their data to it. "That was really the key thesis of why we invested in making this into a cloud release," Kumar said. A good example here is the new disaster recovery function that allows users to replicate their data in SQL Managed Instance on Azure and use that as a backup for their main on-premises SQL Server, which should make it easy to fail over to that when the main server goes down.
are SQL Managed Instance full ones? like in an VM? (Score:3)
are SQL Managed Instance full ones? like in an VM?
Do you have full control over the tables?
In the past some apps did not work with CLOUD DB that need more or less there own service account user that needs full control over it's OWN DB.
Re: (Score:3)
Re: (Score:1)
We work for PHB's, so yes.
Re: (Score:1)
Re: (Score:2)
It's about a million times more useful than Oracle. Bleh.
Re: (Score:1)
Re: (Score:2)
Re: (Score:2)
Postgres is damn good. My second choice. I still enjoy working with SQL Server better, just because I know it very well. (Over 20 years) But no issues other than lack of experience with Postgres, it's really gotten good!
Oracle, bleh, what a shitty thing. Nothing but hair-pulling when having to code against it, it sucks bad and it's error messages are meaningless.
MS is shoving The Cloud up our ass (Score:1)
Everywhere you look at MS, they are trying to force you into cloud and subscriptions. For example, in MS office the "Save" menu options no longer goes directly to File Explorer. There's an intermediate panel you have to go through first, and it's full of stars, I mean cloud options. I tried disabling it without success so far.
I already have my favorites ("Quick Access") set up in File Explorer for my common tasks; I don't need another such menu in between. If I want a link to the cloud, I'd put in Quick Acc
Re: (Score:2)
making their cloud act fully like a regular network drive>
They are not. I don't need a stupid app to access a network drive at work. You need one to get OneDrive into File Explorer to make it act like a dumb drive.
Which is why I continue to not use it and just go in on the web based version and delete all the files Teams added, because you cannot send a file in Teams. You upload to OneDrive first then it gets shared
Re: (Score:1)
It's already mapped to a drive, but that doesn't get rid of the intermediate Office "save" window/portal.
Re: (Score:2)
Re: (Score:1)
It's mapped to a network drive but not a letter drive. I and others couldn't figure how to map it to a letter drive, but I wish to return to that question one of these days. Maybe OS updates have made it easier now.
Re: (Score:1)
I'm not entirely sure this is mostly Microsoft's fault. Had they escrowed the source code as part of the original deal as insurance against dev Ch. 11, and sought a VS developer instead of Iron Speed, the app perhaps would have still been relatively easily maintain-able by a typical MS dev. And the performance bottlenecks were also perhaps bad coding, not MS tools specifically. Messes can be made with OSS also.
Re: (Score:1)
At least MS devs are plentiful. Plus, it (usually) works better with Office etc. OSS platform is no guarantee either. A Ruby-on-Rails app was built, but couldn't find a dev after it fell out of favor.
Again, I'm not saying MS is great, but your problem points don't seem to be MS-specific still.
Re: (Score:1)
Absolutely 100% agree with you.
There are real serious issues with the way Microsoft is going on this ;
- They would prefer you to not have any IT dept, and instead call 1-976-Microsoft so that a salemen (instead of a sysadmin), create a ticket, and tell you that an engineer will get back to you (while never contacting you back, ever). I am sorry if I prefer to be working with a local sysadmin I can get in touch, meet (not only through Team), and can call at 4am if the shit hit the fans and get immediate acti
when the main server goes down... (Score:1)
I know its a Microsoft product - but are they expecting the server will go down?
impressed with upgrade process SQL Server (PaaS) (Score:3)
Re:impressed with upgrade process SQL Server (PaaS (Score:4, Insightful)
With PostgreSQL:
1) For binary compatible versions (which comprise the vast majority of upgrades), let the package manager install the software and restart the service. Done.
For binary-incompatible versions, it depends on the setup. It can require anywhere from significant downtime to no downtime at all. I find that the freedom from outside control outweighs even the worst downtime we've ever had upgrading between binary-incompatible versions. In our case, that downtime is fairly small (maybe fifteen minutes once every few years).
PostgreSQL has pg_upgrade, which is supposed to eliminate even that small amount of downtime, but I've never had the time or inclination to test drive it.
For me, SQL Server offers nothing compelling that justifies the cost and the lock-in.
Re: (Score:2)
They did pretty impressive things in their SQL Server (PaaS) where they disconnected compute from storage.
Easily implemented by any qualified electrician using proper wire, workbox, and a wall switch.
Upgrading database is basically done by setting compatibility level - execute one query and you are done.
So it only takes 1 query to blow up MS SQLServer 2022? Learn something new everyday when reading /.
Dare to compare it with Oracle/MySQL/Postgress/or any AWS RDS where upgrade means early morning hours on the weekend.
I would not be caught dead running anything MS SQLServer...and I used to use it in webapps and stuff like that because the PHB wanted it that way.
Re: (Score:3)
Re: (Score:2)
Yet T-SQL continues to fall behind... (Score:2)
Microsoft's flavor of SQL, T-SQL, continues to fall far behind other databases. They don't even attempt to stay up to date with ANSI SQL standards, for which they are at least a decade, if not more, behind their competitors. The SQL Server product is almost exclusively focused on pushing Azure up-selling instead.