Hlola Amanani Nezinguqulo ze-SQL Server
Bona amanothi ku-SQL Server 2014 naku-SQL Server 2016 ekupheleni kwalesi sihloko.
Ukukhishwa kwe-Microsoft ka-2012 kwesikhulumi se- SQL Server 2012 yokuphathwa kwedatha yamabhizinisi kubonakaliswe ukuguquka okukhulu kulo mkhiqizo othandwayo. Lokhu kukhululwa okusha kuhlanganisa ukuthuthukiswa kwesici esikhulu kubhizinisi lwe-SQL Server, ukuhlolwa kwamabhuku nokubuyiselwa kwezinhlekelele, phakathi kokunye ukuthuthukiswa.
I-SQL Server 2012 Editions
Ngokukhululwa kwe-SQL Server 2012, i-Microsoft ithathe izinyathelo zokwenza izinketho zokulayisense zesikhulumi ngokulula ngokususa i-Datacenter Edition, Edition Edition kunye ne-Small Business Edition eyatholakale ikhona ku- SQL Server 2008 no-2008 R2 .
- I-SQL Server 2012 Express Edition ithatha isikhundla seMicrosoft Data Engine njengenguqulo yamahhala ye-SQL Server yokuthuthukiswa kwesicelo nokusetshenziswa okulula. Ihlala ikhululekile futhi igcina ukulinganiselwa kwe-MSDE ngokuphathelene nokuxhumana kwamakhasimende nokusebenza. Kuyithuluzi elihle lokuthuthukisa nokuhlola izinhlelo zokusebenza nokusetshenziswa okuncane, kodwa kungakapheli ukuthi ungakwazi ukugijima nayo.
- I- SQL Server 2012 Standard Edition ihlala iyisisekelo somkhakha womkhiqizo wesicelo se-database esiyinkimbinkimbi. Ingakwazi ukusingatha amakhoreji angu-16 anenani elingenamkhawulo le-RAM. Izinguquko ezinkulu ekulayiseneni kusuka ku-SQL Server 2008 kuya ku-SQL Server 2012 yukuthi ukhetho oluyinhloko luyatholakala manje kwi-Standard Edition. Lokhu kusho ukuthi unezinketho ezimbili: ukuthenga amalayisensi oyinhloko ngamunye noma ukuthenga ilayisensi yeseva kanye namalayisensi okufinyelela kwamakhasimende.
- Uhlelo olusha lwe- SQL Server 2012 Business Intelligence Edition (BI) lwaklanyelwe ngqo ukusekela izicelo ze-intelligence zebhizinisi. Itholakala kuphela ngaphansi kwesimiso selayisense se-server / CAL ngelayisense yokufinyelela kwamakhasimende kanye namakhasimende. (I-Microsoft ayisekho noma ithengisa le nguqulo.)
- I-SQL Server 2012 Enterprise Edition iklanyelwe ukusebenza kwe-data-critical data center kanye nezindawo ezinkulu zokugcina idatha. Le nguqulo ishintshela kumodeli kuphela okuyisibonelo sokulayisense. Awekho amalayisensi amasha / ama-CAL walolu hlobo azodayiswa emva kuka-Juni 2012. Okukhethwa kukho kuphela kwelayisensi kuyatholakala kumgomo ngamunye ngezingqikithi ezingu-20. (I-Microsoft ayisekho noma ithengisa le nguqulo.)
- Abathuthukisi abadinga izici ezigcwele ze-SQL Server 2012 Enterprise Edition ukuze basebenzise kwimvelo engekho yokukhiqiza bangathola i- SQL Server 2012 Developer Edition ithuluzi elifanele lomsebenzi. Lo mkhiqizo unomsebenzi ofanayo njengo-Enterprise Edition futhi uhlukile kuphela kwelayisensi (futhi ishibhile kakhulu). I-Microsoft iphinde inikeze indlela yokuqondisa ngqo yokuguqula amasiphakeli kanjiniyela ekulayiseneni ukukhiqiza.
- I-SQL Server 2012 Web inguqulo ekhethekile ye-SQL Server ukuze isetshenziswe ezindaweni zokusingatha iwebhu. Lolu hlobo luyatholakala kuphela kumakhasimende wesivumelwano soMhlinzeki Welayisensi Yabahlinzeki. Xhumana ne-Microsoft yakho yokuthengisa yokuthola ulwazi oluthe xaxa uma ucabanga ukuthi ufanelekile.
- I-SQL Server 2012 Compact yinguqulo yamahhala ye-SQL Server ukuze isebenze ezindaweni ezihlanganisiwe, njengamadivayisi eselula nezinye izinhlelo ze-Windows.
Ilayisenisi yeSQL Server: Per Core noma Per Server
Uma uhlela ukusebenzisa uhlelo olujwayelekile lwe-Microsoft SQL Server 2012 endaweni yakho, unenkululeko enkulu yokwenza: Ingabe kufanele ukhethe ilayisense yensiva ngayinye noma ilayisense eyinhloko ngayinye? Noma ngabe yikuphi, lokhu kungenzeka kubangele ukwanda okukhulu kwezimali zakho zokulayisense. Nansi i-rundown.
- Ukushintsha okukhethwa kukho kokulayisenisa okuyisisekelo kusuka kumodeli wangaphambili wokushaja iprosesa ngayinye. Izinhlangano eziningi zisebenzise lokhu ngokuthenga amaprosesa ase-multicore kanye nelayisense eyodwa. Intengo yelayisensi yenzelwe ukuba ibe yizindleko ezifanayo zenzelwe iphrosesa encane engaphansi kwe-SQL Server 2008 R2. Uma uqhuba ama-cores amane noma ambalwa, awuboni ukwanda ngaphansi kwalesi simodeli. Ngakolunye uhlangothi, uma ugijima ezingaphezu kwezingqimba ezine ngeprosesa ngayinye, ubona ukwanda kwamanani.
- Inketho yelayisense ye-server / ye-CAL idinga imali yokulayisense ngeSQL Server. Kodwa-ke, udinga ukuthenga amalayisensi okufinyelela amaklayenti (ama-CAL) wekhasimende ngalinye elifinyelela ku-database. Yilapho ama-sock e-Microsoft enyuke khona kakhulu. Imali yanda ngamaphesenti angu-27 nge-CAL ngayinye.
Izinguquko zamuva: SQL Server 2014 ne-SQL Server 2016
Isici esihlakaniphile, i-SQL Server 2014 ne-SQL 2016 inikeza isethi esicacile sici kunonyaka ka-2012. Bobabili ukusebenza okuphakeme kakhulu, kufaka ukusekelwa kokubethela kokusekelayo, futhi bangeze ukhetho lokutakula inhlekelele.
Ngonyaka we-2016, i-Microsoft isuse uhlelo lwebhizinisi le-Business Intelligence futhi lathinta izici zalo kumagazini we-Enterprise, ukuze izinhlelo zayo eziyinhloko manje zikhawulelwe ku-Standard kanye ne-Enterprise kuphela. I-SQL Developer manje isingeniswa mahhala njengengxenye ye-Microsoft Visual Studio Developer Essentials.
I-SQL Server 2014 ifakwe izinguquko ezincane kumodeli wayo wokulayisense ngezindlela ezimbili:
- Ilayisensi yokulondoloza yamahhala yokuthola inhlekelele manje idinga ukuthuthukiswa ukufaka i-Software Assurance, okwakungelona iqiniso ngeSQL Server 2012.
- Imithetho ye-multipleplexing ikhululiwe ngoba uhlelo lwe-BI-multiplexing luchaza umkhuba wokuhlanganisa ukuxhumanisa noma ukuvuselela ulwazi ukuze unciphise inani lamadivayisi noma abasebenzisi abathola umkhiqizo.
I-SQL Server 2016 ifana no-2014 enezinguquko ezimbalwa:
- Ngokuhamba komshicileli we-BI ku-Enterprise, amakhasimende adinga ukuthuthukisa ku-Enterprise ngokuxuba ilayisense ye-CAL noma ye-Core.
- Ukulayiseniswa kwamalayisensi kuye kwaba lula kangangokuthi amakhekhe angokwenyama nangokwemvelo manje ahambelana nemanani entengo.
Njengoba ungase utshele, uzodinga ukuhlala phansi nespredishithi bese uqhuba izinombolo ezithile ngaphambi kokwenza izinqumo zakho zelayisense ze-SQL Server. Izinketho ozikhethayo zingaba negalelo elibalulekile ezindleko zakho zelayisensi jikelele zelayisensi yedatha futhi kufanele zibhekwe ngokucophelela.