Iyo Linux vhezheni inopa mashandiro akafanana neiyo Window vhezheni
Microsoft yakazivisa svondo rino kuwanikwa kwemumiriri wekuburitswa kweSQL Server 2022 yeLinux masisitimu anoshanda vakasarudzwa. Iyo Linux vhezheni yeSQL Server 2022 haingosanganisire maficha akasanganisirwa muSQL Server 2022 RC yakaburitswa Nyamavhuvhu 23 yeWindows, asi zvakare inotsigira akasiyana makore ane chekuita neAzure.
Features Included sanganisira Query Store kutarisa mashandiro yehurongwa nekutora otomatiki nhoroondo yemubvunzo, zvirongwa, uye runtime statistics. Pamusoro pezvinyowani zvakawedzerwa muRC 0, iyi Linux kuburitswa inotsigirawo zvinhu zvakaita seAzure Synapse Link uye Azure Active Directory Authentication.
ari Zvinyowani muSQL Server 2022 zvinosanganisira:
- Optimization yeparameter-sensitive zvirongwa
- Query Store enhancements
- Batanidza kuAzure SQL Yakagadziriswa Instance
- Mapoka Akazvimiririra Anowanika
- Azure Synapse Binding yeSQL
- Multiple Kunyora Replication
- Azure Active Directory kuvimbiswa
- Azure Purview kubatanidzwa
- SQL Server Ledger
- AWS S3 kuchengetedza kubatanidzwa
Nezve RC 0 yeSQL Server 2022 yeLinux
Uyuwo RC ine mitauro yekuwedzera, kusanganisira percentile disk fungidziro iyo, maererano neMicrosoft, "inodzosa kukosha kweiyo seti yezvikoshi muboka rakapihwa percentile yakapihwa uye zvimiro zvakatemwa", uye Approx Percentile Cont, iyo 'inodzosa kukosha kwakaenzana kubva kuseti yezvikoshi d' boka rinobva pamutengo wepercentile uye nedanho rakatemwa'.
Kune chikamu che parameter inonzwisa hurongwa optimization, iyi itsva yemubvunzo kugadzirisa smart iyo yakagadzirwa kunatsiridza mashandiro yemabasa aripo asina shanduko kune kodhi yekushandisa. Pakutanga, SQL Server yakavharira chirongwa chimwe chete pane zvakachengetwa maitiro. Izvi zvaive zvichibva pane seti yemaparamita uye yainzi parameter tracking.
Kunatsiridza mu chitoro chemubvunzo, ibasa rekuita iyo inobatsira kuteedzera zvirinani nhoroondo yekuita uye kugadzirisa mashandiro uye nyaya dzehurongwa hwekubvunza. Mune shanduro dzakapfuura, waifanira kugonesa iyo Query Store nemaoko. NeSQL Server 2022, Query Store zvino yave kugoneswa nekusingaperi kune dhatabhesi nyowani, inopa zvirinani kubvunza njere uye nzwisiso.
QueryStore ikozvino ichatsigirawo kuwanikwa kweboka rekuverenga-chete replicas, iyo inopa kuongororwa kwekuita zvirinani kune yako yekuverenga-chete mitoro yebasa. Iwe unogona zvakare kushandisa Query Store hints kuumba hurongwa hwemibvunzo uye kugadzirisa bvunzo dzekuita pasina kuchinja kodhi yako yekushandisa.
Nezve Azure, Iyo Linux vhezheni yeSQL Server 2022 inotsigira zvinotevera maficha:
- Azure SynapseLink-Inobvumira vanogadzira kushandisa Azure Synapse Analytics kuwana nyore uye zvakananga kuAzure Cosmos DB analytics chitoro. Integration Runtime (IR) haigone kuisirwa munzvimbo yeLinux, saka unozofanirwa kumhanyisa IR pamushini weWindows uri panetiweki yakafanana nemuchina weLinux unomhanyisa SQL Server muenzaniso wauri kubatanidza nawo.
- Azure Active Directory Authentication (ADD)Cherechedza: SQL Server paLinux ikozvino inosanganisira tsigiro yeAAD. SQL Server midziyo haitsigire chimiro ichi parizvino
- Kumapoka anowanikwa akagoverwa, iyo REQUIRED SYNCHRONIZED SECONDARIES TO COMMIT shanduko inotsigirwa.
Microsoft inoenderera mberi nekuwedzera maficha uye kushanda kuSQL Server yeLinux uye inoita kuti ive chikamu chiri kukura cheAzure bhizinesi gore masevhisi, izvo zvine musoro munyika inokurumidza uye inowedzera mutengi-centric yenyika yekombuta.
Chekupedzisira, kana iwe uchifarira kugona kuziva zvakawanda nezvazvo, unogona kutarisa ruzivo Mune inotevera chinongedzo.
Dhawunirodha uye tora SQL Server 2022 RC 0
SQL Server 2022 RC 0 yave kuwanikwa yeRed Hat Enterprise Linux (RHEL) uye Ubuntu masisitimu anoshanda. Kudhawunirodha mifananidzo yazvino yeRC 0 yemidziyo, unofanira kushandisa '2022-yazvino' ma tag emifananidzo yemudziyo. SUSE Linux Enterprise Server haisati yatsigirwa kuti imhanye SQL Server 2022 Preview, asi zvichaitika ne "inotevera vhezheni".
Iwe unogona kutevera mirairo yekuisa mu inotevera chinongedzo.