SQL Server -chigadzirwa chakasarudzika chinogona kushanda nehuwandu hukuru hwedhatabhesi yeruzivo uye inoita zvirongwa uye manejimendi mabasa.
Kudzora kwesql server kunosanganisira kuvandudzwa kweruzivo base system, kusikwa kwegadziriro yekuchengetedza, kuunganidzwa kwedhatabhesi, zvinhu, uye zvinoita kuti vashandisi vawane ruzivo rwunowanikwa mudhatabhesi.
Mutariri nguva nenguva anogadzira makopi ekuchengetedza, anotarisa kutendeseka kweiyo ruzivo system, uye anodzora vhoriyamu inobvumidzwa yemafaira eruzivo uye matanda ekutengeserana.
DB izita rezvikamu zvakabatana
Iyi database inotungamirirwa nehurongwa hunokosha, iyo yakaoma yemutauro uye software zvishandiso zvinochengetedza kukosha kwayo uye kuronga kukurumidza kutsvaga ruzivo rwakakosha.
Database structuring
Kuronga hwaro hwepamusoro-soro hweruzivo, maneja anofanira kuswedera kwairi zvine musoro, kunyatsodzidza zvakawanda zvingasarudzwa zvekushandisa ruzivo rwuripo, kupa mukana wekubatanidzwa nemamwe masisitimu uye kuwana, pamwe nekushandisa matekinoroji emazuva ano, kuita shanduko dzinodiwa hurongwa.
SQL server management inoitwa mushanduro mbiri
Yekutanga iseva yefaira, umo dhatabhesi iri pane sevha yefaira; inopa kuchengetedza kweiyo base yeruzivo uye kuwana kwairi nevatengi vanomhanya pamakomputa akasiyana. Kugadziriswa kunoitwa panzvimbo dzebasa uko mafaera e database anotamiswa. Makomputa evatengi ega ane system yekudzora iyo inogadzirisa ruzivo rwunofambiswa.
Iyo mutengi-server vhezheni, kuwedzera kune chengetedzo, inogadzirisa huwandu hwese data. Chikumbiro chakatumirwa kuurayiwa, chakapihwa nemutengi, chinotsamwisa kutsvaga uye kudzoreredza ruzivo rwakakosha. Ruzivo urwu rwunotakurwa netiweki kubva kuseva kuenda kune mutengi.
Iyo mutengi-server ine zvikamu zviviri: mutengi uye server.
Mutengi ari pakombuta yega; inoita mabasa ekupa graphical interface.
Sevha chikamu chiri pa yakatsaurirwa server uye inobatsira pakupihwa kwekugovana ruzivo, manejimendi ekutanga ruzivo, masevhisi ekutonga uye matanho ekuchengetedza.
A client-server system inoratidzirwa nekushandiswa kwehunyanzvi hwemutauro unogadzira mibvunzo uye zvakare inopa maturusi anoshanda ekuwana dhatabhesi.