SQL Server 2012 Tutori
Microsoft SQL Server 2012 isangano rezvekodzero yekuchengetedza database (RDBMS) inopa zvinhu zvakasiyana-siyana zvekushandisa kuti zvigadzirise mitoro yekuvandudza dhesi, kugadzirisa, uye kutarisira. Muchikamu chino, tichazadza zvimwe zvekushandisa zvakanyanya: SQL Server Management Studio, SQL Profiler, SQL Server Agent, SQL Server Configuration Manager, SQL Server Integration Services uye Books Online. Ngatitorei muchidimbu chimwe nechimwe:
SQL Server Management Studio (SSMS)
SQL Server Management Studio (SSMS) ndiyo inonyanya kushandiswa yekushandura SQL Server. Inokupa iwe ne "shiri-eye" maonero ezvo yese ye SQL Server kuisa pa network yako. Iwe unogona kuita yakakwirira-maitiro ekufambisa mabasa anobata rimwe kana maserevhisi, ronga purogiramu yakawanda yekugadzirisa mabasa kana kugadzira nekugadzirisa chimiro chezvinyorwa zvevanhu. Iwe unogonawo kushandisa SSMS kuti uburise mibvunzo yakakurumidza uye yakashata zvakananga kurwisana neyese yeSQL Server databases. Vashanduri vevashanduro vekare veSQL Server vachaziva kuti SSMS inosanganisira mabasa akawanikwa kare muQuery Analyzer, Enterprise Manager, uye Analyse Manager. Heano mimwe mienzaniso yemabasa aunokwanisa kuita ne SSMS:
- Gadzira tafura ye database yeSQL Server
- Tune SQL Server inoshanda neDatabase Engine Tuning Advisor
- Saronga SQL Server yekuongorora mabhuku
- Gadzira SQL Server database replication
SQL Profiler
SQL Profiler inopa firiji mukati mekushanda kwebhuku rako rekodhi. Iwe unogona kutarisa mhando dzakawanda dzezviitiko uye ona kuchengetedzwa kwemasvomhu munguva chaiyo chaiyo. SQL Profiler inokubvumira kutora nekudzorera hurongwa hwe "maitiro" ayo anotora mabasa akasiyana-siyana. Icho chinhu chikuru chekugadzirisa databases nehutano hwekuita kana kukonzera matambudziko mamwe. Sezvo nevakawanda SQL Server mabasa, unogona kuwana SQL Profiler kuburikidza neSQL Server Management Studio. Kuti uwane mamwe mashoko, ona tutori yedu Yokusika Database Traces ne SQL Profiler .
SQL Server Agent
SQL Server Agent inokubvumira kuti uite maitiro akawanda emitambo yekutonga iyo inodya nguva yevatengi ve database. Iwe unogona kushandisa SQL Server mumiririri kuti aite mabasa anowedzera nenguva, mabasa anokonzerwa nehutsananguro uye mabasa ayo anotangwa nemagadzirirwo akachengetwa. Iyi mabasa inogona kusanganisira matanho anoita chero chero basa rekutarisira, kusanganisira kubatsiridza zvinyorwa, kushandisa mirayiridzo yehurongwa, kushandiswa kweSISIS nepakati. Kuti uwane mamwe mashoko pamusoro peSquL Server Agent, ona tutorial yedu Automating Database Administration ne SQL Server Agent .
SQL Server Mushandisi Wekuita
SQL Server Maintenance Manager is snap-in yeMicrosoft Management Console (MMC) inokubvumira kutarisira maSQL Server maitiro anoshanda kumaseva ako. Mabasa eSQL Server Maintenance Manager anosanganisira kutanga nekumira mabasa, kugadziridza mabasa ekugadzirisa uye kugadzira zvigadziridzo zvekubatanidza nhepfenyuro yepa database. Mimwe mienzaniso ye SQL Server Configuration Manager mabasa inosanganisira:
- Kutanga SQL Server Agent Service (kana mamwe maService SQL Server) neKupedza Meneja
- Encrypting SQL Server database connections ne SQL Server Configuration Manager
SQL Server Integration Services (SSIS)
SQL Server Integration Services (SSIS) inopa nzira yakanyatsoshandiswa yekutumira uye kutumira dhana pakati pekugadzirirwa kweSquL Server uye zvimwe zvakasiyana-siyana zvemamwe maitiro. Inotora nzvimbo yeData Transformation Services (DTS) inowanikwa mune zvinyorwa zvekare zveSQL Server. Kuti uwane mamwe mashoko pamusoro pekushandisa SSIS, ona tutori redu Kuisa nekutsvaga Dhipatimendi ne SQL Server Integration Services (SSIS) .
Mabhuku Online
Mabhuku ari paIndaneti ndiyo inowanzokanganwa ruzivo rwakapiwa SQL Server rine mhinduro kune zvakasiyana-siyana zvekutungamira, kubudirira nekugadzirisa nyaya. Icho chinhu chikuru chekushandisa kutarisana usati watendeukira kuGoogle kana kutsigirwa kwekambani. Iwe unokwanisa kupinda SQL Server 2012 Books Online pawebsite yeMicrosoft kana unogonawo kukopa makopi eMabhuku eDaily Online kumatunhu ako ega.
Panguva ino, iwe unofanirwa kuva nekunzwisisa kwakanaka kwezvigadzirwa zvemasikirwo nemasangano anobatanidza ne Microsoft SQL Server 2012. Kunyange zvazvo SQL Server iri yakaoma, yakasimba yekuchengetedza masayiti ehurumende, ino ruzivo rwepfungwa inofanira kukuendesa kune zvishandiso zvinobatsira kubatsira vatevedzeri vekudhinda SQL Server yavo yekuisa uye inokurudzira iwe nzira yakarurama yekudzidza zvakawanda nezve nyika yeSQL Server.
Sezvaunoramba uchifamba rwendo rwako rwekudzidzisa SQL Server, ndinokukoka kuti uongorore zvinhu zvakawanda zviripo pane ino. Iwe uchawana zvidzidzo zvinowanikwa zvizhinji zvemashoko ekutanga ekufambisa akaitwa ne SQL Server vatariri uye mazano ekuchengetedza SQL Server database yako yakachengeteka, yakavimbika uye yakanyatsogadziriswa.
Iwe unokokwawo kuti ubatane nesu mune About Databases Forum apo vazhinji vevamwe vako varipo vanogona kukurukura nyaya pamusoro peSQL Server kana mamwe mapuratifomu e database.