Sungani Mitengo ndi Zolemba za SQL Server
Onani zolemba pa SQL Server 2014 ndi SQL Server 2016 kumapeto kwa nkhaniyi.
Kusulidwa kwa Microsoft kwa 2012 SQL Server 2012 yosungirako ntchito yosungirako zamasamba kuwonetseratu kusintha kwakukulu kwa mankhwalawa. Kutulutsidwa kwatsopano kumeneku kunaphatikizapo kulimbikitsa kwakukulu kwa SQL Server za bizinesi zamalonda, kuyang'anira ndi kuyambiranso kwa masoka, pakati pa zina zowonjezera.
SQL Server 2012 Zolemba
Pogwiritsa ntchito SQL Server 2012, Microsoft inatenga njira zochepetsera zosankha zapulatifomu pochotsa Datacenter Edition, Edition Yogwira Ntchito ndi Small Business Edition yomwe inalipo kale pa SQL Server 2008 ndi 2008 R2 .
- SQL Server 2012 Express Edition imalowa m'malo mwa Microsoft Data Engine monga ndondomeko yaulere ya SQL Server kwa chitukuko cha ntchito ndi ntchito yochepa. Amakhalabe omasuka ndipo amakhalabe ndi zolephera za MSDE polemekeza makasitomala ogwirizana ndi ntchito. Ndi chida chachikulu chokhazikitsa ndi kuyesa mapulogalamu ndi zochepa zochitapo kanthu, koma ndizo pafupi momwe mungathamangire nazo.
- Mndandanda wa SQL Server 2012 Wowonjezera Sindinayambe ndiwowonjezereka wa malonda omwe akugwiritsidwa ntchito kwambiri. Ikhoza kuthana ndi makina 16 okhala ndi RAM yopanda malire. Kusintha kwakukulu pa chilolezo kuchokera ku SQL Server 2008 kupita ku SQL Server 2012 ndikuti njira yoyamba ikupezeka tsopano ku Standard Edition. Izi zikutanthauza kuti muli ndi zisankho ziwiri: kugula malayisensi oyambirira kapena kugula laisensi limodzi ndi malayisensi opindula.
- SQL Server 2012 Business Intelligence Edition (BI) yatsopano yothandizira ntchito zogwirira ntchito zamalonda. Ikupezeka kokha pansi pa seva / CAL yobwezera chilolezo ndi seva ndi makasitomala opindula. (Microsoft sangawononge kapena kugulitsa buku ili.)
- SQL Server 2012 Enterprise Edition inakonzedwa kuti iwonetsetse ntchito zoyendetsera deta ndi zolemba zazikulu. Magaziniyi ikusandulika kuchitsanzo chokhacho chokha. Palibe ma seva atsopano / CAL ya makope awa omwe adzagulitsidwe pambuyo pa mwezi wa June 2012. Njira yokhayo yopezera malayisensi yomwe ilipo ndiyo yaikulu pamakutu 20. (Microsoft sangawononge kapena kugulitsa buku ili.)
- Okulitsa omwe akufunikira zonse za SQL Server 2012 Enterprise Edition kuti agwiritsidwe ntchito mu malo osapanga angathe kupeza SQL Server 2012 Developer Developer Chombo choyenera pa ntchitoyo. Chogulitsa ichi chiri ndi ndondomeko yofanana ndi Enterprise Edition ndipo imasiyana kokha ndi layisensi (ndipo ndi yotsika mtengo). Microsoft imaperekanso njira yowonjezera yosinthira ma seva osinthika kuti apange chilolezo chopanga.
- Webusaiti ya SQL Server 2012 ndiyake yapadera ya SQL Server kuti igwiritsidwe ntchito pa webusaiti yoyang'anira zochitika. Magaziniyi imapezeka kokha kwa makasitomala a mgwirizano wopezera malonda. Lembani malonda anu a Microsoft malonda kuti mudziwe zambiri ngati mukuganiza kuti mukuyenerera.
- SQL Server 2012 Yokonzeka ndi SQL Server yaulere yogwiritsidwa ntchito muzinthu zojambulidwa, monga zipangizo zamagetsi ndi machitidwe ena a Windows.
Malayisensi a SQL Server: Per Core kapena Per Server
Ngati mukukonzekera kugwiritsa ntchito makina ovomerezeka a Microsoft SQL Server 2012 pamalo anu, muli ndi kusankha kwakukulu koti mupange: Kodi mungasankhe malayisensi pa seva kapena malayisensi oyambirira? Mwanjira iliyonse, izi zikhoza kuwonjezera kuwonjezeka kwa ndalama zanu. Pano pali phokoso.
- Njira yoyamba yothandizira mavoti imasintha kuchokera ku chitsanzo choyambirira cha kutsatsa pulosesa iliyonse. Mabungwe ambiri adapindula ndi izi pogula mapulogalamu a multicore ndi chilolezo chimodzi. Mtengo wa chilolezo unali wokonzedweratu kuti ukhale mtengo wofanana womwe umagwiritsidwa ntchito purosesa yachinayi pansi pa SQL Server 2008 R2. Ngati mutayendetsa makola anayi kapena ochepa, simukuwona kuwonjezeka komweku pansi pa chitsanzo ichi. Komabe, ngati muthamanga makilogalamu opitirira anayi pa purosesa, mukuwona kuwonjezeka kwa mtengo.
- Chotsatira cha seva / CAL chokhala ndi chilolezo chimafuna malipiro a chilolezo pa SQL Server. Komabe, mufunikanso kugula zilolezo zothandizira makasitomala (CALs) kwa aliyense kasitomala omwe akupezeka pa deta. Apa ndi pamene masokiti a Microsoft ali ndi kuwonjezeka kwakukulu. Malipirowo anawonjezeka 27 peresenti pa CAL.
Zotsatira Zotsatira: SQL Server 2014 ndi SQL Server 2016
SQL Server 2014 ndi SQL 2016 zimapereka chuma chamtengo wapatali kuposa 2012. Onse awiri apamwamba ntchito, akuphatikizapo kubwezeretsamo makina othandizira, ndipo awonjezera njira yowonongeka.
Pokhala ndi 2016, Microsoft inachotsa bukhu la Business Intelligence ndikuyika zigawo zake mu Enterprise edition, kotero kuti matembenuzidwe ake oyambirira tsopano ndi a Standard ndi Makampani. SQL Developer ili tsopano kumasulidwa kwaulere monga gawo la Microsoft Visual Studio Developer Essentials.
SQL Server 2014 ikuphatikizidwa kusintha kwakukulu mu chilolezo chake chovomerezeka mwa njira ziwiri:
- Lamulo loyimira ufulu lachiwongolero cha zoopsa tsopano likufuna kusinthako kuti kukhale ndi Inshuwalansi ya Mapulogalamu, zomwe sizinali zoona kwa SQL Server 2012.
- Malamulo ambiri amamasulidwa chifukwa cha kusindikizidwa kwa BI-multiplexing ndizozoloƔera kugwirizanitsa mauthenga kapena kubweretsanso chidziwitso kuti athe kuchepetsa chiwerengero cha zipangizo kapena ogwiritsa ntchito omwe alowetsa mankhwalawa.
SQL Server 2016 ikufanana ndi 2014 ndi kusintha pang'ono:
- Ndikusuntha kwa bukhu la BI ku Makampani, makasitomala akufunika kuti apite patsogolo ku Makampani pogwiritsa ntchito kusakanizidwa kwa CAL kapena Core licensing.
- Kuloledwa kwazitsulo kwa makoswe kwakhala kosavuta kotero kuti mazira enieni ndi omveka tsopano akugwirizana ndi mitengo.
Monga momwe mungathere, muthe kukhala pansi ndi pepala ndikuyendetsa manambala musanapange zisankho zanu za SQL Server. Zosankha zomwe mungasankhe zingakhudzidwe kwambiri ndi ndalama zanu zonse zothandizira zokhudzana ndi deta ndikuyenera kuziganizira mosamala.