Kwesi sikhokelo sobugcisa, siya kubonisa amanyathelo ayimfuneko ukwenza ukufakwa kweSQL Server 2014 Windows 10. Iseva yeSQL yinkqubo ethembekileyo, esebenza kakhulu yolawulo lwedatha ekuvumela ukuba ugcine kwaye ulawule umthamo omkhulu wedatha. Ngokukhula kokuthandwa kwe IiWindows 10 kunye nesidingo sokuphumeza i-SQL Server kweli qonga, kubalulekile ukuba ube nesikhokelo esicacileyo esenza kube lula ukufakela kunye noqwalaselo. Funda ukuze ufumane izinto ezifunekayo, amanyathelo alandelayo, kunye nezenzo ezingcono zofakelo oluyimpumelelo lwe-SQL Server 2014 kwi. inkqubo yakho yokusebenza IiWindows 10.
Iimfuno zehardware yokuhlohla iSQL Server 2014 kwi Windows 10
Ukuze ukwazi ukufaka nokusebenzisa i-SQL Server 2014 kwiWindows 10, kubalulekile ukuba neemfuneko zehardware ezifanelekileyo. Apha ngezantsi ngamacandelo ayimfuneko ukuqinisekisa ukusebenza ngokupheleleyo:
- Iprosesa: Iprosesa ubuncinane ye-1,4 GHz okanye ngaphezulu iyacetyiswa.
- Imemori ye-RAM: Kucetyiswa ukuba ubuncinane be-2 GB yememori ye-RAM. Nangona kunjalo, ukuze usebenze ngokugqibeleleyo kuyacetyiswa ukuba ube ne-4 GB okanye ngaphezulu.
- Indawo yedisk: Kuyimfuneko ukuba ubuncinane ube ne-6 GB yendawo yedisk yasimahla yofakelo lwesoftware. Ukongeza, kuyacetyiswa ukuba ube nendawo eyongezelelweyo yokugcina idatabase.
- Ikhadi lemizobo: Ikhadi elithile lemizobo alifuneki kwi-SQL Server ka-2014.
- Amazibuko: Qinisekisa ukuba izibuko ezifunekayo kunxibelelwano nge-SQL Server zivuliwe kwiWindows firewall.
Kubalulekile ukuqaphela ukuba ezi zezona mfuno zisezantsi kwaye kuxhomekeke kumthwalo womsebenzi kunye nobukhulu bogcino-lwazi lwakho, unokufuna izixhobo ezingaphezulu zokusebenza kakuhle. Yandisa inani le-RAM kunye nendawo yedisk ngokuyimfuneko.
Iimfuno zesoftware yokuhlohla iSQL Server 2014 Windows 10
Oku kubalulekile ukuqinisekisa ukufakwa okuyimpumelelo kunye nokusebenza kakuhle kweseva yedatha. Ngezantsi zezona mfuno zisezantsi nezicetyiswayo zokufakela iSQL Server 2014 Windows 10:
1. Inkqubo yokwenza Iyahambelana: Windows 10. Qinisekisa inkqubo yakho yokusebenza Ziqhelanise nezamva nje Windows 10 uhlaziyo ngaphambi kokufaka iSQL Server 2014.
2. Indawo yeDiskhi: Ubuncinci be-6 GB ye-disk space iyadingeka ukuze kufakwe i-SQL Server 2014. Nangona kunjalo, kucetyiswa ukuba ubuncinane be-10 GB ukuvumela ukuphuculwa kwexesha elizayo kunye nokukhula kwedatha.
3. I-RAM: Kucetyiswa ukuba ube ubuncinane be-4 GB ye-RAM ukuqinisekisa ukusebenza kakuhle kweseva yedatha. Nangona kunjalo, okukhona une-RAM efumanekayo, kokukhona kuya kuba ngcono ukusebenza kwe-SQL Server.
Kwakhona kubalulekile ukuqwalasela ezinye iimfuno, ezifana . Ukuhlangabezana nezi mfuno kuya kuqinisekisa ukufakela okuyimpumelelo kunye nokusebenza kakuhle kweSQL Server 2014 Windows 2014.
Kuthotywa umthwalo wofakelo we-SQL Server 2014
Iphakheji yofakelo ye-SQL Server 2014 ibalulekile kwabo bafuna ukubeka nokulawula ugcino lweenkcukacha zabo Windows 10. Apha siza kukubonisa indlela yokukhuphela nokulungiselela le phakheji yokuhlohla inyathelo nenyathelo.
1. Ngena kwiwebhusayithi esemthethweni ye-Microsoft kwaye ukhangele kwi-SQL Server 2014 icandelo lokukhuphela.
2. Cofa ikhonkco lokukhuphela elihambelana nohlelo lwakho kunye nolwimi olukhethayo.
3. Nje ukuba ukhuphelo lugqityiwe, khangela ifayile kwikhompyuter yakho kwaye ucofe kabini ukuyiqhuba.
Ngethuba lokufakela, qiniseka ukuba ulandele ngokucophelela imiyalelo enikiweyo. Qinisekisa ukuba isixokelelwano sakho sihlangabezana neemfuneko zehardware kunye nesoftware ukuqinisekisa ukufakwa okugudileyo.
1. I-SQL Server 2014 yokuhlohla ifestile iya kuvula ukhetho "Ufakelo olutsha lwe-SQL Server oluzimeleyo okanye ukongeza iimpawu kufakelo olukhoyo".
2. Emva koko uya kucelwa ukuba wamkele imimiselo yelayisenisi kwaye wenze uhlolo lwemithetho yokufakela ukuqinisekisa ukuba inkqubo yakho ilungile.
3. Khetha iimpawu ofuna ukuzifaka njengenxalenye yomzekelo wakho weSQL Server 2014 kwaye uqwalasele indawo yokufakela ngokusekelwe kwiimfuno zakho.
Emva kokugqiba ukuseta, ukufakwa kuya kuqalisa kwaye uya kukwazi ukulandelela inkqubela phambili ngexesha langempela. Wakuba ugqibile, uya kuba ukulungele ukuqalisa ukusebenzisa iSQL Server 2014 kweyakho Windows 10 isixhobo Yonwabela zonke iimpawu kunye nesakhono esi sixhobo sinamandla esinikezelayo sokugcina kunye nokusetyenzwa kwedatha yakho.
Ukulungiselela Windows 10 inkqubo yokusebenza yokuhlohla iSQL Server 2014
Phambi kokufaka iSQL Server 2014 kweyakho Windows 10 ikhompuyutha, kubalulekile ukulungiselela inkqubo yokusebenza ukuze uqinisekise ukufakela okuyimpumelelo kunye nokusebenza kakuhle Okulandelayo, siya kukubonisa amanyathelo omawuwalandele ukulungisa inkqubo yakho yokusebenza ngokuchanekileyo.
1. Jonga iimfuno zesistim: Phambi kokuba uqalise, qiniseka ukuba ikhompuyutha yakho ihlangabezana nezona mfuno zisezantsi zehardware kunye nesoftware yokuhlohla iSQL Server 2014 Windows 10. Jonga uluhlu lweemfuno kwiphepha elisemthethweni elivela kuMicrosoft ukuqinisekisa ukuhambelana okufanelekileyo.
2. Hlaziya inkqubo yakho yokusebenza: Kubalulekile ukugcina inkqubo yakho yokusebenza ihlaziywa ngohlaziyo lwamva nje kunye neziqwenga zokhuseleko. Ngaphambi kokufaka i-SQL Server 2014, qiniseka ukuba ufake zonke iintlaziyo ezifumanekayo ze-Windows 10. Ungajonga kwaye ukhuphele uhlaziyo kwiPhaneli yoLawulo yesixokelelwano sakho.
3. Izicwangciso zoKhuseleko: Ukuqinisekisa ukufakela okukhuselekileyo, kuyacetyiswa ukuba ukhubaze okwethutyana nayiphi na inkqubo ye-antivirus okanye i-firewall ngexesha lenkqubo yokufakela. Ezi nkqubo zinokuphazamisana nofakelo okanye zivale iifayile eziyimfuneko. Qinisekisa ukuba uzibuyisela emva emva kokuba ugqibile ukuhlohla iSQL Server 2014.
Ukufakela i-SQL Server 2014 Windows 10 inyathelo ngenyathelo
Kweli nqaku, ndiya kukukhokela Inyathelo nenyathelo ngenkqubo yofakelo lwe SQL Server 2014 Windows 10. Qiniseka ukuba ulandele la manyathelo ngononophelo ukuqinisekisa ufakelo oluyimpumelelo lwesoftware.
1. Qwalasela iimfuno zesixokelelwano: Ngaphambi kokuba uqalise, qiniseka ukuba ikhompuyutha yakho ihlangabezana nezona mfuno zisezantsi zenkqubo yokufakela i-SQL Server 2014 Windows 10. Oku kuquka ukuba nesithuba esaneleyo sedisk, i-RAM, kunye noguqulelo oluxhaswayo. yenkqubo yokusebenza. Ungaqinisekisa ezi mfuno kuxwebhu olusemthethweni lweMicrosoft.
2. Khuphela iphakheji yokuhlohla: Yiya kwiwebhusayithi esemthethweni yeMicrosoft uze ukhuphele iphakheji yokufakela ehambelanayo yeSQL Server 2014. ngeWindows 10. Qinisekisa ukuba ufumana inguqulelo echanekileyo, nokuba yi- Express, Standard okanye Enterprise edition, ngokuxhomekeke kwiimfuno zakho kunye nelayisenisi.
3. Qalisa iwizadi yokufakela: Nje ukuba ukhuphele iphakheji yokuhlohla, cofa kabini kwifayile ephunyeziweyo ukuqalisa ukufaka iwizadi. Ifestile iya kuvula apho ungakhetha khona amalungu ofuna ukuwafaka. Unokubandakanya iimpawu ezongezelelweyo ezifana nezixhobo zolawulo okanye iinkonzo zokudibanisa, njengoko kufuneka. Unokukhetha phakathi kofakelo olutsha okanye uphuculo ukuba sele unoguqulelo oludala of Iseva yeSQL efakiweyo. Landela imiyalelo ekwisikrini kwaye unike iinkcukacha eziyimfuneko zoqwalaselo, njengomzekelo kunye noqinisekiso, ukugqibezela ufakelo.
Khumbula ukuba le nkqubo inokwahluka kancinane ngokuxhomekeke kuguqulelo oluthile lwe-SQL Server 2014 oyifakayo. Nangona kunjalo, ngokulandela la manyathelo aqhelekileyo, uya kuba nakho ukufaka i-SQL Server 2014 Windows 10 kwaye uthathe inzuzo yazo zonke iimpawu kunye nobuchule bayo.
Ukuseta okokuqala emva kokufaka iSQL Server 2014 Windows 10
Emva kokugqiba ukufakwa kwe-SQL Server 2014 kwi-Windows 10, kubalulekile ukuqwalasela ngokufanelekileyo okusingqongileyo ukuqinisekisa ukusebenza kakuhle. Apha ngezantsi kukho isikhokelo esineenkcukacha ukwenza ukwenza uqwalaselo lokuqala kwaye ufumane okuninzi kwesi sixhobo solawulo sedatabase sinamandla.
1. Qinisekisa useto lwenethiwekhi: Qinisekisa ukuba i-SQL Server izakhelo zenethiwekhi zicwangciswe kakuhle. Oku kubandakanyaukuqinisekisa ukuba igama lomncedisi lichanekile kwaye ukuba liyafikeleleka kwezinye iikhompyutha kumsebenzi womnatha. Kukwacetyiswa ukuba uqwalasele iTCP/IP protocol kwaye wenze udibaniso olukude ukuba uza kulawula ugcino lwedatha ukusuka. ezinye izixhobo.
2. Qwalasela iimvume zokhuseleko: Kubalulekile ukunika iimvume ezifanelekileyo kubasebenzisi be-SQL Server kunye neendima zokuqinisekisa ubumfihlo bedatha kunye nokuthembeka. Oku kubandakanya ukwenza amagama agqithisiweyo kunye namagama ayimfihlo akhuselekileyo kwaye uwanike iimvume eziyimfuneko kwiziko ledatha elihambelanayo. Kukwacetyiswa ukuba unciphise ufikelelo kwimithombo yenkqubo, efana neefayile kunye neefolda, ukuthintela ukwaphulwa kokhuseleko okunokwenzeka.
3. Lungiselela ukusebenza: Ukufumana okuninzi kwi-SQL Server 2014, kufuneka uhlengahlengise ezinye izicwangciso. Enye inketho kubungakanani bogcino-lwazi kunye nokungena iifayile ngokufanelekileyo ukuphepha imiba yendawo. Kukwacetyiswa ukwenza umfanekiso okhawulezayo isiseko sedatha ukuququzelela ukubuyiswa kwimeko yokusilela. Ukongezelela, unokuqwalasela isicwangciso sokulondoloza ukwenza imisebenzi ecwangcisiweyo, njengokuhlaziya izibalo kunye nokwakhiwa kwakhona kwezalathisi, ukuphucula ukusebenza kombuzo.
Ngokulandela la manyathelo okuqala okuseta, uya kuba ukulungele ukuthatha ithuba elipheleleyo lesakhono se-SQL Server 2014 kweyakho Windows 10 okusingqongileyo Khumbula ukuba kubalulekile ukuhlala usexesheni kunye nohlaziyo lokhuseleko ukuze uqinisekise ukuqina kunye indawo engqongileyo ekhuselweyo. Phonononga “zonke izinto ezinokwenzeka” esi sixhobo solawulo lwesiseko sedatha sikunika!
Iingqwalasela kunye nokulungisa iingxaki ngelixa ufaka iSQL Server 2014 Windows 10
Kuqhelekile ukuhlangabezana nemingeni ngexesha lofakelo lwe-SQL Server 2014 kwi-Windows 10. Ngethamsanqa, kukho izisombululo zokuzoyisa kunye nokuqinisekisa ukufakela okuyimpumelelo. Apha sibonisa iingqwalasela ezibalulekileyo kunye nesisombululo sezona ngxaki zixhaphakileyo onokujamelana nazo ngexesha lofakelo.
1. Iimfuno zenkqubo: Phambi kokuba uqhubeke nofakelo lwe-SQL Server 2014 Windows 10, kubalulekile ukuqinisekisa ukuba isixokelelwano sakho siyazanelisa ezona mfuno zisezantsi. Qinisekisa ukuba unendawo eyaneleyo kwidisk, i-RAM, kunye nenguqulelo ehambelanayo IiWindows 10. Ukongeza, kuyacetyiswa ukuba ukhubaze okwethutyana nayiphi na inkqubo ye-antivirus okanye i-firewall ukuphepha iingxabano ngexesha lofakelo.
2. Uguqulelo lwe-Visual C++: Enye yezona ngxaki zixhaphakileyo kukunqongophala kwenguqulelo efanelekileyo yeVisual C++ enokuphinda isasazwe. Ukulungisa oku, kufuneka ukhuphele kwaye ufake inguqulo echanekileyo ngaphambi kokuba uqalise ukufakwa kwe-SQL Server 2014. Qinisekisa ukuba ukhetha inguqulelo ehambelana nenkqubo yakho yokusebenza kunye ne-architecture (32 okanye 64 bits).
3. Uqwalaselo lweFirewall: Ukuba ujongene nobunzima bokudibanisa kwiseva yeSQL emva kofakelo, kusenokwenzeka ukuba Umlilo weWindows ivala ufikelelo. Ukulungisa oku, kufuneka uvumele uxhulumaniso olungenayo noluphumayo lwe-SQL Server kunye ne-SQL Browser kwi-Firewall izicwangciso. Unokwenza oku kwicandelo leWindows Firewall ngaphakathi kwePhaneli yoLawulo. Kwakhona, qiniseka ukuba uyaqinisekisa ukuba inkonzo ye-SQL Server iyasebenza kwaye igama lakho lomsebenzisi lineemvume ezifanelekileyo zokufikelela kwisiseko sedatha.
Le yingqwalasela kunye nezisombululo kwiingxaki eziqhelekileyo xa uhlohla iSQL Server 2014 Windows 10. Khumbula ukulandela imiyalelo yokuhlohla enikelwe nguMicrosoft kwaye ujonge amaxwebhu asemthethweni ngolwazi olongezelelweyo. kunye la macebiso, uya kukwazi ukoyisa nawuphi na umqobo kwaye wonwabele amandla kunye nokusebenza kweSQL Server 2014 kweyakho Windows 10 okusingqongileyo.
Iingcebiso zokhuseleko zokuqwalasela i-SQL Server 2014 Windows 10
Ngezantsi sinika iingcebiso ezingundoqo zokhuseleko lokuqwalasela i-SQL Server 2014 kwi-Windows 10. La manyathelo aya kukunceda uqinisekise ukukhuselwa kwedatha yakho kunye nokugcina indawo ekhuselekileyo yedatha.
1. Yenza kuphela iinkonzo eziyimfuneko
Kubalulekile ukuba uqwalasele i-SQL Server ukuze kuphela iinkonzo eziyimfuneko ekusebenzeni kwayo ziqhutywe. Khubaza naziphi na iinkonzo ezingeyomfuneko kwaye uqinisekise ukuba ngabasebenzisi abagunyazisiweyo kuphela abanokufikelela kuzo. Oku kuya kunciphisa umngcipheko wokuvezwa kubuthathaka kunye nokunciphisa indawo yokuhlaselwa kwiseva yakho.
2. Gcina uhlaziyo kunye neepetshi zisexesheni
Iseva ye-SQL, njengayo nayiphi na enye isoftware, inokuba nobuthathaka abanokuthi baxhatshazwe ngabahlaseli. Kubalulekile ukugcina ufakelo lwakho lusexesheni kwaye usebenzise rhoqo iipetshi zokhuseleko zamva nje. Cwangcisa uhlaziyo oluzenzekelayo ukuqinisekisa ukuba inkqubo yakho isoloko ikhuselwe kwizoyikiso zamva nje.
3. Sebenzisa ukuqinisekiswa okukhuselekileyo
Ukukhusela idatabase yakho, kuyacetyiswa ukuba usebenzise uqinisekiso olukhuselekileyo kwi-SQL Server. Kuphephe ukusebenzisa uQinisekiso oluDityanisiweyo lweWindows ukuba alufunwa kwaye endaweni yoko sebenzisa uqinisekiso lwe-SQL Server kwaye usete amagama ayimfihlo anamandla kuzo zonke iiakhawunti zomsebenzisi. Ukongeza, qwalasela ukuphumeza imigaqo-nkqubo yokuvala i-akhawunti kunye nokuqwalasela uphicotho lokungena ukuze ufumane iinzame zokufikelela okungagunyaziswanga.
Iingqwalaselo ezongezelelweyo ze-Eptimal SQL Server 2014 Performance on Windows 10
Ukuqinisekisa ukusebenza kakuhle xa usebenzisa i-SQL Server 2014 Windows 10, kubalulekile ukugcina ezinye iingqwalasela ezongezelelweyo engqondweni. Ngezantsi kukho iingcebiso ezinokukunceda ukwandise ukusebenza kwedatha yakho kunye nokuphucula ukusebenza kakuhle kweseva yakho:
- Ubumbeko lwenkqubo yokusebenza: Qinisekisa ukuba inkqubo yokusebenza iqwalaselwe ngokufanelekileyo ukuxhasa i-SQL Server 2014. Qinisekisa ukuba uhlaziyo lwamva nje kunye neepatches zifakiwe. Kukwacetyiswa ukuba ulungelelanise ukusebenza kwenkqubo yokusebenza, njengokukhubaza iimpawu ezingeyomfuneko okanye ukuqwalasela iinketho zamandla ukwenzela ukusebenza okuphezulu.
- Ubumbeko lweseva yeSQL: Yazi kwaye uqwalasele ngokufanelekileyo iinketho zoqwalaselo lomncedisi weSQL ukuze zilungele iimfuno zakho. Ezinye iisetingi eziphambili ziquka ubungakanani bememori enkulu, useto lweconcurrency, kunye nelog kunye neesayizi zeefayile zedatha. Ukongeza, cinga ukuvumela ucinezeleko lwedatha kunye nokusebenzisa izalathisi ezifanelekileyo ukunyusela umsebenzi wombuzo wakho.
- Ukubeka iliso rhoqo kunye nohlengahlengiso: Kubalulekile ukujonga rhoqo ukusebenza kwe-SQL Server kwaye wenze uhlengahlengiso oluyimfuneko. Sebenzisa izixhobo zokubeka iliso ukuchonga imiqobo okanye imiba yokusebenza kwaye uthathe amanyathelo okulungisa ngokufanelekileyo. Unokwenza imibuzo, isalathisi ngokufanelekileyo, kwaye uhlengahlengise iiparamitha zoqwalaselo ngokweemfuno zesicelo sakho.
Ngokulandela ezi ngqwalasela zongezelelweyo, uya kukwazi ukwandisa ukusebenza kwe-SQL Server 2014 yakho Windows 10. Khumbula ukuba indawo nganye ihlukile, ngoko ke kubalulekile ukuqwalasela iimfuno ezithile zesicelo sakho kwaye wenze uhlengahlengiso njengoko kuyimfuneko. Fumana okuninzi kwidathabheyisi yakho kwaye ufumane ukusebenza okugqibeleleyo!
Ukuqukumbela, ukufakwa kwe-SQL Server 2014 Windows 10 kunokwenziwa ngokufanelekileyo ngokulandela amanyathelo achazwe kwesi sikhokelo. Ukuba zonke iingcebiso ziyalandelwa kwaye iimfuno zenkqubo zifezekisiwe, akufanele kubekho iingxaki ekufakeni ngempumelelo kunye nokuqwalasela iseva yedatha.
Kubalulekile ukuqaphela ukuba ufakelo oluchanekileyo lwe-SQL Server 2014 lubalulekile ukuqinisekisa ukusebenza ngokufanelekileyo kwezicelo kunye neenkqubo ezixhomekeke kuyo Ukongeza, ukuqinisekisa ukuba unalo lonke uhlaziyo oluyimfuneko kunye neziqwenga ziya kuphucula ukhuseleko kunye nokusebenza kwe umncedisi.
Kuyacetyiswa ukuba ube nolwazi oluyimfuneko lobuchwephesha okanye ufune uncedo lwengcali kwimeko yobunzima obuvela ngexesha lofakelo. Kukwabalulekile ukuba ngamaxesha athile kwenziwe iikopi ezigciniweyo zogcino-lwazi ukuthintela ilahleko enokwenzeka yolwazi kwimeko yokusilela okanye iimeko ezingalindelekanga.
Isishwankathelo, esi sikhokelo sinikezele ngamanyathelo ayimfuneko okufaka iSQL Server 2014 Windows 10 ngempumelelo nangokukhuselekileyo. Ngolu lwazi olusesandleni, abasebenzisi baya kukwazi ukusebenzisa ngokupheleleyo imisebenzi kunye neenzuzo ezinikezelwa ngulo mncedisi wedatha onamandla. Ungalibazisi ukusebenzisa esi sikhokelo kwaye wonwabele zonke izibonelelo ezinikezelwa yi-SQL Server 2014!
NdinguSebastián Vidal, injineli yekhompyuter ethanda itekhnoloji kunye ne-DIY. Ngaphaya koko, ndingumdali we tecnobits.com, apho ndabelana ngee-tutorials ukwenza itekhnoloji ifikeleleke kwaye iqondeke kumntu wonke.